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


Shad Colmic Herakles Ispanic 11.4cm Smoker -24%
Exclusiv online!

Shad Colmic Herakles Ispanic 11.4cm Smoker

arhkisp13
Livrare 48-72 ore

27,90Lei(-24%) 21,13Lei

Shad Colmic Herakles Ispanic 11.4cm White -23%
Exclusiv online!

Shad Colmic Herakles Ispanic 11.4cm White

arhkisp27
Livrare 48-72 ore

23,90Lei(-23%) 18,30Lei

Shad Colmic Herakles Ow105 Shiner Melon 4.2 Inch 6/plic -26%
Exclusiv online!

Shad Colmic Herakles Ow105 Shiner Melon 4.2 Inch 6/plic

arhksofa32
Livrare 48-72 ore

43,90Lei(-26%) 32,52Lei

Shad Colmic Herakles Ow105 Smoker 4.2 Inch 6/plic -26%
Exclusiv online!

Shad Colmic Herakles Ow105 Smoker 4.2 Inch 6/plic

arhksofa13
Livrare 48-72 ore

43,90Lei(-26%) 32,52Lei

Shad Colmic Herakles Ow105 Summer Craw 4.2 Inch 6/plic -26%
Exclusiv online!

Shad Colmic Herakles Ow105 Summer Craw 4.2 Inch 6/plic

arhksofa09
Livrare 48-72 ore

43,90Lei(-26%) 32,52Lei

Shad Colmic Herakles Ow105 Wakasagi 4.2 Inch 6/plic -26%
Exclusiv online!

Shad Colmic Herakles Ow105 Wakasagi 4.2 Inch 6/plic

arhksofa25
Livrare 48-72 ore

43,90Lei(-26%) 32,52Lei

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

Shad Colmic Herakles Ow105 White Impact 4.2 Inch 6/plic

arhksofa33
Livrare 48-72 ore

43,90Lei(-26%) 32,52Lei

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

Shad Colmic Herakles Viber 9.7cm Black Chartreuse

arhkel07
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 2.4" 6cm Motor Pepper

arhkfw09
Livrare 48-72 ore

21,90Lei(-23%) 16,86Lei

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

Shad Colmic Vobbler 2.4" 6cm Orange

arhkfw08
Livrare 48-72 ore

21,90Lei(-23%) 16,86Lei

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

Shad Colmic Vobbler 2.4" 6cm Peach

arhkfw03
Livrare 48-72 ore

21,90Lei(-23%) 16,86Lei

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

Shad Colmic Vobbler 2.4" 6cm Smoke Pink Shad

arhkfw01
Livrare imediată!

21,90Lei(-23%) 16,86Lei

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

Shad Colmic Vobbler 4" 10cm Arkasas Shiner

arhkfv11
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 4" 10cm Baitfish

arhkfv05
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 4" 10cm Chartreuse Impact

arhkfv03
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 4" 10cm Magic Shad

arhkfv08
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 4" 10cm Motor Pepper

arhkfv10
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 4" 10cm Orange Shiner

arhkfv09
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 4" 10cm Shiner

arhkfv07
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

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

Shad Colmic Vobbler 4" 10cm Smoke Pink Shad

arhkfv01
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

Afişare 7741 - 7760 din 9206 (461 pagini)
Queries: 5, Total time: 688.843 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '3754521ea79ce2da472278f2c4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (306.851)
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 (381.669)
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 7740,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.137)
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