articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Mulineta Delphin MAMUT 10000 -31%

Mulineta Delphin MAMUT 10000

286033080
Stoc epuizat

269,00Lei(-31%) 186,90Lei

Lanseta Delphin Catkong WALKYRA 3.00m 850g

Lanseta Delphin Catkong WALKYRA 3.00m 850g

160914300
Stoc epuizat

363,40Lei

Umbrela Delphin Cu Perete Lateral Extins 250cm Verde -28%

Umbrela Delphin Cu Perete Lateral Extins 250cm Verde

435001zel
Stoc epuizat

319,00Lei(-28%) 230,00Lei

Lanseta Delphin RIVER Trophy Feeder X-TRA Plus 4 varfuri 3.60m 200g -32%

Lanseta Delphin RIVER Trophy Feeder X-TRA Plus 4 varfuri 3.60m 200g

130382310
Stoc epuizat

410,00Lei(-32%) 279,50Lei

Rod pod Delphin STATIC 3 Posturi -28%

Rod pod Delphin STATIC 3 Posturi

870000320
Stoc epuizat

456,00Lei(-28%) 330,00Lei

Avertizor Delphin Electronic EASY -19%

Avertizor Delphin Electronic EASY

900021011
Stoc epuizat

35,00Lei(-19%) 28,41Lei

Set Statie Avertizoare Delphin BRITON 3 Plus 1 -36%

Set Statie Avertizoare Delphin BRITON 3 Plus 1

900022431
Stoc epuizat

706,00Lei(-36%) 449,00Lei

Ochelari de soare polarizați Delphin SG BLACK lentile portocalii

Ochelari de soare polarizați Delphin SG BLACK lentile portocalii

920121290
Stoc epuizat

144,39Lei

Saibe carbon Delphin ODYSEA 3Buc

Saibe carbon Delphin ODYSEA 3Buc

286023900
Stoc epuizat

33,00Lei

Rod pod Delphin BRONX 4 picioare -27%

Rod pod Delphin BRONX 4 picioare

870000326
Stoc epuizat

274,00Lei(-27%) 199,00Lei

Rod pod Delphin RPX 4 BlackWay pentru 3 lansete -31%

Rod pod Delphin RPX 4 BlackWay pentru 3 lansete

870000329
Stoc epuizat

608,99Lei(-31%) 419,00Lei

Avertizor Delphin Briton Galben

Avertizor Delphin Briton Galben

900022470
Stoc epuizat

101,40Lei

Covor Delphin Retro Stiuca, 60x40cm

Covor Delphin Retro Stiuca, 60x40cm

795000203
Stoc epuizat

39,00Lei

Strună Delphin din oțel BOMB cu agrafa 49 fibre 11kg -42%

Strună Delphin din oțel BOMB cu agrafa 49 fibre 11kg

917201135
Stoc epuizat

5,00Lei(-42%) 2,90Lei

Rodpod Delphin BBQ -26%

Rodpod Delphin BBQ

870000328
Stoc epuizat

335,00Lei(-26%) 249,00Lei

Degetar Delphin WRAP -29%

Degetar Delphin WRAP

197000010
Stoc epuizat

24,00Lei(-29%) 17,01Lei

Avertizor DELPHIN MEMORY 9V -31%

Avertizor DELPHIN MEMORY 9V

900021017
Stoc epuizat

86,00Lei(-31%) 59,00Lei

Sticker Delphin Chyť a pusť 7x7cm

Sticker Delphin Chyť a pusť 7x7cm

795010030
Stoc epuizat

6,00Lei

Agrafe rapide tip cărlig Delphin B 03 BN NR.14

Agrafe rapide tip cărlig Delphin B 03 BN NR.14

969b03014
Stoc epuizat

10,00Lei

Saltea de primire Delphin C-RADLE -33%

Saltea de primire Delphin C-RADLE

955001030
Stoc epuizat

446,00Lei(-33%) 299,90Lei

Afişare 2681 - 2700 din 3993 (200 pagini)
Queries: 5, Total time: 115.710 ms [By time] [By id] [By file]
1 (0.090)
SELECT data
FROM `oc_session`
WHERE session_id = '4d40b5c1bfe378fde31301908f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (100.483)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+delphin' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (14.903)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 2680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.148)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38