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


Tricou Fox Rage Limited Edition Zander T-shirt Black Mar Xxl -27%

Tricou Fox Rage Limited Edition Zander T-shirt Black Mar Xxl

npr408
Livrare imediată!

139,95Lei(-27%) 101,53Lei

Tricou Jackall Graphinc Tee Water Side, Black, Marime L -18%
Exclusiv online!

Tricou Jackall Graphinc Tee Water Side, Black, Marime L

ja.807250220
Livrare 24-48 ore

379,61Lei(-18%) 309,78Lei

Tricou Korum Dri-active Short Sleeve Shirt, Marime Xxl -49%

Tricou Korum Dri-active Short Sleeve Shirt, Marime Xxl

k0350082
Livrare imediată!

131,94Lei(-49%) 66,71Lei

Tricou Korum Dri-active Short Sleeve Shirt, Marime Xxxl -49%

Tricou Korum Dri-active Short Sleeve Shirt, Marime Xxxl

k0350083
Livrare imediată!

131,94Lei(-49%) 66,71Lei

Tricou Madcat Clonk M Black Caviar Marime M -28%

Tricou Madcat Clonk M Black Caviar Marime M

8083173792
Livrare imediată!

108,59Lei(-28%) 78,29Lei

Tricou Madcat Clonk M Black Caviar Marime Xxl -28%

Tricou Madcat Clonk M Black Caviar Marime Xxl

8083173795
Livrare imediată!

108,42Lei(-28%) 78,17Lei

Tricou Madcat Clonk Teaser Dark Grey Melange, Marime 2xl -18%

Tricou Madcat Clonk Teaser Dark Grey Melange, Marime 2xl

a8.mad.73791
Livrare imediată!

102,49Lei(-18%) 84,37Lei

Tricou Nash Polo Shirt, Brown, Marimea S -31%

Tricou Nash Polo Shirt, Brown, Marimea S

c5700
Livrare imediată!

115,99Lei(-31%) 80,21Lei

Tricou Nash Tackle T-shirt Green 10-12 Ani -8%

Tricou Nash Tackle T-shirt Green 10-12 Ani

c1136
Livrare imediată!

92,99Lei(-8%) 85,29Lei

Tricou Polo Tubertini Bianaca, Marime L -13%
Exclusiv online!

Tricou Polo Tubertini Bianaca, Marime L

720950b
Livrare 7-14 zile

131,50Lei(-13%) 114,65Lei

Tricou Polo Tubertini Bianaca, Marime M -13%
Exclusiv online!

Tricou Polo Tubertini Bianaca, Marime M

720950a
Livrare 7-14 zile

131,50Lei(-13%) 114,65Lei

Tricou Polo Tubertini Bianaca, Marime S -13%
Exclusiv online!

Tricou Polo Tubertini Bianaca, Marime S

720950g
Livrare 7-14 zile

131,50Lei(-13%) 114,65Lei

Tricou Polo Tubertini Bianaca, Marime Xl -13%
Exclusiv online!

Tricou Polo Tubertini Bianaca, Marime Xl

720950c
Livrare 7-14 zile

131,50Lei(-13%) 114,65Lei

Tricou Polo Tubertini Bianaca, Marime Xxxl -13%
Exclusiv online!

Tricou Polo Tubertini Bianaca, Marime Xxxl

720950e
Livrare 7-14 zile

131,50Lei(-13%) 114,65Lei

Tricou Polo Tubertini Bianaca, Marime Xxxxl -13%
Exclusiv online!

Tricou Polo Tubertini Bianaca, Marime Xxxxl

720950f
Livrare 7-14 zile

131,50Lei(-13%) 114,65Lei

Tricou Polo Tubertini Corta, Marime S -13%
Exclusiv online!

Tricou Polo Tubertini Corta, Marime S

720960g
Livrare 7-14 zile

136,50Lei(-13%) 118,98Lei

Tricou Polo Tubertini Corta, Marime Xxl -13%
Exclusiv online!

Tricou Polo Tubertini Corta, Marime Xxl

720960d
Livrare 7-14 zile

136,50Lei(-13%) 118,98Lei

Tricou Polo Tubertini Corta, Marime Xxxl -13%
Exclusiv online!

Tricou Polo Tubertini Corta, Marime Xxxl

720960e
Livrare 7-14 zile

136,50Lei(-13%) 118,98Lei

Tricou Polo Tubertini Corta, Marime Xxxxl -13%
Exclusiv online!

Tricou Polo Tubertini Corta, Marime Xxxxl

720960f
Livrare 7-14 zile

136,50Lei(-13%) 118,98Lei

Tricou Polo Tubertini Flag Dry, Marime Xxl -13%
Exclusiv online!

Tricou Polo Tubertini Flag Dry, Marime Xxl

720900d
Livrare 7-14 zile

199,50Lei(-13%) 173,42Lei

Afişare 2561 - 2580 din 9198 (460 pagini)
Queries: 5, Total time: 626.360 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = '543194f4124fcb52e96298840e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (284.871)
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.060)
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 2560,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.215)
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