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

Oferte speciale


Shad Colmic Herakles Ow105 White Impact 4.2 Inch 6/plic -29%
Exclusiv online!

Shad Colmic Herakles Ow105 White Impact 4.2 Inch 6/plic

arhksofa33
Livrare 48-72 ore

43,90Lei(-29%) 31,00Lei

Shad Colmic Herakles Viber 9.7cm Black Chartreuse -29%
Exclusiv online!

Shad Colmic Herakles Viber 9.7cm Black Chartreuse

arhkel07
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 2.4" 6cm Motor Pepper -29%
Exclusiv online!

Shad Colmic Vobbler 2.4" 6cm Motor Pepper

arhkfw09
Livrare 48-72 ore

21,90Lei(-29%) 15,60Lei

Shad Colmic Vobbler 2.4" 6cm Orange -29%
Exclusiv online!

Shad Colmic Vobbler 2.4" 6cm Orange

arhkfw08
Livrare 48-72 ore

21,90Lei(-29%) 15,60Lei

Shad Colmic Vobbler 2.4" 6cm Peach -29%
Exclusiv online!

Shad Colmic Vobbler 2.4" 6cm Peach

arhkfw03
Livrare 48-72 ore

21,90Lei(-29%) 15,60Lei

Shad Colmic Vobbler 2.4" 6cm Smoke Pink Shad -29%

Shad Colmic Vobbler 2.4" 6cm Smoke Pink Shad

arhkfw01
Livrare imediată!

21,90Lei(-29%) 15,60Lei

Shad Colmic Vobbler 4" 10cm Arkasas Shiner -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Arkasas Shiner

arhkfv11
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Baitfish -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Baitfish

arhkfv05
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Chartreuse Impact -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Chartreuse Impact

arhkfv03
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Magic Shad -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Magic Shad

arhkfv08
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Motor Pepper -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Motor Pepper

arhkfv10
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Orange Shiner -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Orange Shiner

arhkfv09
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Shiner -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Shiner

arhkfv07
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Smoke Pink Shad -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Smoke Pink Shad

arhkfv01
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 4" 10cm Smoker -29%
Exclusiv online!

Shad Colmic Vobbler 4" 10cm Smoker

arhkfv06
Livrare 48-72 ore

29,90Lei(-29%) 21,21Lei

Shad Colmic Vobbler 6cm White Silver -29%
Exclusiv online!

Shad Colmic Vobbler 6cm White Silver

arhkfw02
Livrare 48-72 ore

21,90Lei(-29%) 15,60Lei

Shad Crazy Fish Nano Minnow 7cm 22 Squid Shrimp Floating -11%

Shad Crazy Fish Nano Minnow 7cm 22 Squid Shrimp Floating

5370227f
Livrare imediată!

23,00Lei(-11%) 20,44Lei

Shad Crazy Fish Nano Minnow 7cm 55r Squid Shrimp Floating -28%

Shad Crazy Fish Nano Minnow 7cm 55r Squid Shrimp Floating

537055r7
Livrare imediată!

23,00Lei(-28%) 16,51Lei

Shad Crazy Fish Nano Minnow 7cm 9 Squid Shrimp -25%

Shad Crazy Fish Nano Minnow 7cm 9 Squid Shrimp

537097
Livrare imediată!

22,00Lei(-25%) 16,51Lei

Shad Crazy Fish Vibro Worm 7.5cm 20 Squid -7%

Shad Crazy Fish Vibro Worm 7.5cm 20 Squid

1175206
Livrare imediată!

12,00Lei(-7%) 11,10Lei

Afişare 7641 - 7660 din 9140 (457 pagini)
Queries: 5, Total time: 628.044 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = 'd851441a19e561b2da13db949e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (286.134)
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 = '0' 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 (341.600)
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 = '0' 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 7640,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.116)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37