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


Cutie Meiho Versus Vs-508 Black

4963189126366
Livrare imediată!

22,00Lei(-9%) 20,00Lei

Cutie Meiho Versus Vs-820ndm Black

4963189143837
Livrare imediată!

30,00Lei(-20%) 23,99Lei

Cutie Meiho Vs-3010nd Black

4963189126588
Livrare imediată!

42,00Lei(-21%) 32,99Lei

Cutie Meiho Vs-702 Black

4963189126212
Livrare imediată!

15,01Lei(-7%) 13,99Lei

Cutie Meiho Vs-708 Black

4963189126359
Livrare imediată!

24,00Lei(-17%) 19,99Lei

Exclusiv online!

82,00Lei(-20%) 65,60Lei

Cutie Nash Needle Box 0.2x3.2x2.4cm

t0282
Livrare imediată!

87,99Lei(-20%) 70,40Lei

Cutie Nash Shallow Box T0283

t0283
Livrare imediată!

34,99Lei(-38%) 21,75Lei

Cutie Nash Slim Box 3 T0287

t0287
Livrare imediată!

34,99Lei(-40%) 21,00Lei

Cutie Nash Slim Box 8 T0288

t0288
Livrare imediată!

35,00Lei(-6%) 32,80Lei

215,95Lei(-47%) 113,69Lei

Cutie Pentru Momeala Cresta Baitbox Holed, 0.25l

006403-00301-00000
Livrare imediată!

11,80Lei(-25%) 8,90Lei

179,96Lei(-21%) 141,90Lei

119,50Lei(-44%) 66,90Lei

104,95Lei(-67%) 34,97Lei

89,50Lei(-44%) 49,90Lei

114,50Lei(-44%) 63,90Lei

249,50Lei(-44%) 138,90Lei

Cutie Plano Six-compartment Stowaway 3600

pmc2360600
Livrare imediată!

37,45Lei(-12%) 33,03Lei

Exclusiv online!

Cutie Plumbi Maver Alice Refill - Aaa

k356
Livrare 48-72 ore

13,99Lei(-19%) 11,40Lei

Afişare 4401 - 4420 din 9004 (451 pagini)
Queries: 5, Total time: 630.287 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '3e62895dd89520c85be0b3282c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (282.226)
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 (347.680)
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 4400,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.132)
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