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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Skull -27%
Exclusiv online!

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Skull

arhkdr02
Livrare 48-72 ore

69,90Lei(-27%) 51,03Lei

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Green Flash -25%
Exclusiv online!

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Green Flash

arherak09b
Livrare 48-72 ore

33,60Lei(-25%) 25,20Lei

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Tri Shad Colmic -25%
Exclusiv online!

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Tri Shad Colmic

arherak09c
Livrare 48-72 ore

33,60Lei(-25%) 25,20Lei

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Qda -27%
Exclusiv online!

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Qda

arhkde01
Livrare 48-72 ore

87,89Lei(-27%) 63,84Lei

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Sardina Chartreuse -27%
Exclusiv online!

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Sardina Chartreuse

arhkde02
Livrare 48-72 ore

87,89Lei(-27%) 63,84Lei

Vobler Cormoran Minnow N35 Dying Roach 8.5cm, 7g -27%
Exclusiv online!

Vobler Cormoran Minnow N35 Dying Roach 8.5cm, 7g

f3.53.001857
Livrare 24-48 ore

37,52Lei(-27%) 27,26Lei

Vobler Crank Sakura Scb Micro Diver 39mm 4.40gr 101 Crayfish -26%

Vobler Crank Sakura Scb Micro Diver 39mm 4.40gr 101 Crayfish

131234saplh500239-101
Livrare imediată!

48,81Lei(-26%) 36,07Lei

Vobler Duo Jerkbait 100 F 10cm 13.7g Gpa3244 -16%

Vobler Duo Jerkbait 100 F 10cm 13.7g Gpa3244

4525918111519
Livrare imediată!

72,00Lei(-16%) 60,48Lei

Vobler Duo Realis Jerkbait 110 Sp 11cm 16.2g Ccc3816 Wakasagi Nd -12%

Vobler Duo Realis Jerkbait 110 Sp 11cm 16.2g Ccc3816 Wakasagi Nd

duo86480
Livrare imediată!

77,00Lei(-12%) 68,01Lei

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Acc3059 Mat Tiger S -16%

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Acc3059 Mat Tiger S

4525918119584
Livrare imediată!

68,99Lei(-16%) 58,04Lei

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Ccc3069 Red Tiger S -17%

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Ccc3069 Red Tiger S

duo37304
Livrare imediată!

68,99Lei(-17%) 57,12Lei

Vobler Holo Select Scamp F Om 7cm 7gr -26%
Exclusiv online!

Vobler Holo Select Scamp F Om 7cm 7gr

vj-sa07fom
Livrare 48-72 ore

33,00Lei(-26%) 24,49Lei

Vobler Jackall Tricoroll Gt 88sr-f Kitamura Gt Flash 8.8cm 9g -38%
Exclusiv online!

Vobler Jackall Tricoroll Gt 88sr-f Kitamura Gt Flash 8.8cm 9g

ja.418096227
Livrare 24-48 ore

93,19Lei(-38%) 57,86Lei

Vobler Jaxon Atract Multi Parts Xmp-a S D 12cm 33gr -20%

Vobler Jaxon Atract Multi Parts Xmp-a S D 12cm 33gr

vr-msa120d
Livrare imediată!

54,99Lei(-20%) 44,07Lei

Vobler Jaxon Atract Multi Parts Xmp-a S D 9.5cm 20gr -20%

Vobler Jaxon Atract Multi Parts Xmp-a S D 9.5cm 20gr

vr-msa095d
Livrare imediată!

49,01Lei(-20%) 39,23Lei

Vobler Jaxon Atract Multi Parts Xmp-a S E 12cm 33gr -20%

Vobler Jaxon Atract Multi Parts Xmp-a S E 12cm 33gr

vr-msa120e
Livrare imediată!

54,99Lei(-20%) 44,07Lei

Vobler Jaxon Atract Multi Parts Xmp-a S E 9.5cm 20gr -20%

Vobler Jaxon Atract Multi Parts Xmp-a S E 9.5cm 20gr

vr-msa095e
Livrare imediată!

49,01Lei(-20%) 39,23Lei

Vobler Jaxon Atract Multi Parts Xmp-a S G 9.5cm 20gr -15%

Vobler Jaxon Atract Multi Parts Xmp-a S G 9.5cm 20gr

vr-msa095g
Livrare imediată!

49,01Lei(-15%) 41,58Lei

Vobler Jaxon Atract Multi Parts Xmp-a S H 12cm 33gr -20%

Vobler Jaxon Atract Multi Parts Xmp-a S H 12cm 33gr

vr-msa120h
Livrare imediată!

54,99Lei(-20%) 44,07Lei

Vobler Jaxon Atract Multi Parts Xmp-a S H 9.5cm 20gr -20%

Vobler Jaxon Atract Multi Parts Xmp-a S H 9.5cm 20gr

vr-msa095h
Livrare imediată!

49,01Lei(-20%) 39,23Lei

Afişare 8881 - 8900 din 9311 (466 pagini)
Queries: 5, Total time: 619.622 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = 'c1ce92665df1a85248fe5da832'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (307.875)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (311.371)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 8880,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.171)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37