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


Hanger Fl Iluminat Culoare Galben -9%

Hanger Fl Iluminat Culoare Galben

fl-sw-11-yellow
Livrare imediată!

21,90Lei(-9%) 19,90Lei

Hanger Fl Iluminat Culoare Rosu -9%

Hanger Fl Iluminat Culoare Rosu

fl-sw-11-red
Livrare imediată!

21,90Lei(-9%) 19,90Lei

Hanger Prologic Senzor Hanger, Blue, 1buc/pac -39%
Exclusiv online!

Hanger Prologic Senzor Hanger, Blue, 1buc/pac

svs77675
Livrare 7-14 zile

124,95Lei(-39%) 76,81Lei

Hanger Prologic Senzor Hanger, Red, 1buc/pac -39%
Exclusiv online!

Hanger Prologic Senzor Hanger, Red, 1buc/pac

svs77676
Livrare 7-14 zile

124,95Lei(-39%) 76,81Lei

Hangere Prologic K1 Midi Indicator, Alb, 1buc/pac -77%
Exclusiv online!

Hangere Prologic K1 Midi Indicator, Alb, 1buc/pac

svs72839
Livrare 7-14 zile

49,94Lei(-77%) 11,64Lei

Hanorac Cu Fermoar Black Cat Zipper, Marime S -20%
Exclusiv online!

Hanorac Cu Fermoar Black Cat Zipper, Marime S

8778301
Livrare 7-14 zile

270,00Lei(-20%) 215,60Lei

Hanorac Cu Fermoar Black Cat Zipper, Marime Xl -20%
Exclusiv online!

Hanorac Cu Fermoar Black Cat Zipper, Marime Xl

8778304
Livrare 7-14 zile

270,00Lei(-20%) 215,60Lei

Hanorac Cu Fermoar Black Cat Zipper, Marime Xxl -20%
Exclusiv online!

Hanorac Cu Fermoar Black Cat Zipper, Marime Xxl

8778305
Livrare 7-14 zile

270,00Lei(-20%) 215,60Lei

Hanorac Impermeabil Nash Scope Waterproof Smock, Marime 2xl -34%

Hanorac Impermeabil Nash Scope Waterproof Smock, Marime 2xl

c0504
Livrare imediată!

909,99Lei(-34%) 601,90Lei

Hanorac Jackall Zip Up Black Marime L -20%
Exclusiv online!

Hanorac Jackall Zip Up Black Marime L

ja.807176520
Livrare 24-48 ore

539,45Lei(-20%) 431,57Lei

Hanorac Jackall Zip Up Black Marime L -20%
Exclusiv online!

Hanorac Jackall Zip Up Black Marime L

ja.807249767
Livrare 24-48 ore

484,29Lei(-20%) 387,43Lei

Hanorac Jackall Zip Up Black Marime Xl -20%
Exclusiv online!

Hanorac Jackall Zip Up Black Marime Xl

ja.807249774
Livrare 24-48 ore

484,29Lei(-20%) 387,43Lei

Hanorac Korda Le Lightweight, Light Kamo, Marime M -28%

Hanorac Korda Le Lightweight, Light Kamo, Marime M

kcl371
Livrare imediată!

324,75Lei(-28%) 232,89Lei

Hanorac Korda Le Lightweight, Light Kamo, Marime S -23%

Hanorac Korda Le Lightweight, Light Kamo, Marime S

kcl370
Livrare imediată!

324,75Lei(-23%) 249,00Lei

Hanorac Madcat Mega Logo Black Caviar L -30%

Hanorac Madcat Mega Logo Black Caviar L

8053173801
Livrare imediată!

211,03Lei(-30%) 147,71Lei

Hanorac Nash Lightweight Hoody Marime Xxxl -31%

Hanorac Nash Lightweight Hoody Marime Xxxl

c5695
Livrare imediată!

209,99Lei(-31%) 144,51Lei

Hanorac Nash Lightweight Hoody, Marime S -25%

Hanorac Nash Lightweight Hoody, Marime S

c5690
Livrare imediată!

209,99Lei(-25%) 156,90Lei

Hanorac Nash Tackle Hoody, Black, Marime 12-14 Ani -12%

Hanorac Nash Tackle Hoody, Black, Marime 12-14 Ani

c1101
Livrare imediată!

195,99Lei(-12%) 172,90Lei

Hanorac Nash Tackle Hoody, Geen, Marime 10-12 Ani -12%

Hanorac Nash Tackle Hoody, Geen, Marime 10-12 Ani

c1127
Livrare imediată!

195,99Lei(-12%) 172,90Lei

Hanorac Nash Tackle Hoody, Geen, Marime 12-14 Ani -12%

Hanorac Nash Tackle Hoody, Geen, Marime 12-14 Ani

c1128
Livrare imediată!

195,99Lei(-12%) 172,90Lei

Afişare 981 - 1000 din 8893 (445 pagini)
Queries: 5, Total time: 867.145 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '230d4d7a9f4add5e1681310396'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (483.834)
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 (382.908)
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 980,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.149)
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