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


TRICOU DELPHIN CATCH ME MARIME M

TRICOU DELPHIN CATCH ME MARIME M

750003401
Livrare imediată!

87,00Lei

Ochelari de soare polarizati Delphin SG Flash maro -42%

Ochelari de soare polarizati Delphin SG Flash maro

920121260
Livrare imediată!

118,00Lei(-42%) 68,90Lei

Hanger Delphin CSW II rosu -18%

Hanger Delphin CSW II rosu

900021421
Livrare imediată!

30,00Lei(-18%) 24,50Lei

Momitor Delphin plumb cu tub 30g -20%

Momitor Delphin plumb cu tub 30g

925001025
Livrare imediată!

5,00Lei(-20%) 4,00Lei

Carlig Delphin HKD 4xISEAMA NR.8

Carlig Delphin HKD 4xISEAMA NR.8

622015008
Livrare imediată!

11,00Lei

Suport telescopic lanseta din otel Delphin fata 60-100cm

Suport telescopic lanseta din otel Delphin fata 60-100cm

900032250
Livrare imediată!

17,01Lei

Carlig Delphin HKD CATFISH NR.2/0

Carlig Delphin HKD CATFISH NR.2/0

622055200
Livrare imediată!

20,00Lei

Suport telescopic lanseta din otel Delphin fata 50-90cm -22%

Suport telescopic lanseta din otel Delphin fata 50-90cm

900032260
Livrare imediată!

15,01Lei(-22%) 11,70Lei

Scaun Delphin XKO

Scaun Delphin XKO

410300130
Livrare imediată!

92,00Lei

Tungsten Delphin The End -42%

Tungsten Delphin The End

830410310
Livrare imediată!

19,00Lei(-42%) 11,00Lei

Carlig Delphin HKD CATFISH NR.8/0 -60%

Carlig Delphin HKD CATFISH NR.8/0

622055800
Livrare imediată!

20,00Lei(-60%) 7,90Lei

Swinger Delphin SKIPER BlackWay negru -18%

Swinger Delphin SKIPER BlackWay negru

900021434
Livrare imediată!

46,01Lei(-18%) 37,60Lei

Fir monofilament Delphin RODEO rosu 0,35mm 23lbs 600m

Fir monofilament Delphin RODEO rosu 0,35mm 23lbs 600m

101001335
Livrare imediată!

41,00Lei

Fir monofilament Delphin RODEO rosu 0.35mm 23lbs 1200m

Fir monofilament Delphin RODEO rosu 0.35mm 23lbs 1200m

101001338
Livrare imediată!

57,00Lei

Mulineta Delphin HORNET 3000

Mulineta Delphin HORNET 3000

286037030
Livrare imediată!

94,90Lei

Minciog spinning Delphin SPIN-R plasa de guma 60x50cm -37%

Minciog spinning Delphin SPIN-R plasa de guma 60x50cm

942000355
Livrare imediată!

131,99Lei(-37%) 83,00Lei

Anti Tangle Feeder Delphin FDR-T 5buc 22 cm

Anti Tangle Feeder Delphin FDR-T 5buc 22 cm

935002022
Livrare imediată!

10,00Lei

Momitor Delphin zinc striat cu tub 20g

Momitor Delphin zinc striat cu tub 20g

925001203
Livrare imediată!

5,00Lei

Carlig Delphin HKD CHINU NR.8

Carlig Delphin HKD CHINU NR.8

622020008
Livrare imediată!

11,00Lei

Cuie Cort Delphin KL, 10buc -45%

Cuie Cort Delphin KL, 10buc

436007900
Livrare imediată!

87,00Lei(-45%) 47,90Lei

Afişare 441 - 460 din 4001 (201 pagini)
Queries: 5, Total time: 94.278 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = 'f1470798518fdca41acdd6a46f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.140)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (79.417)
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 = '3' 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.469)
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 440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.166)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38