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


Grub Relax Turbo Twister Standard Blister, Ts127, 11cm, 8g, 4buc/plic -8%
Exclusiv online!

Grub Relax Turbo Twister Standard Blister, Ts127, 11cm, 8g, 4buc/plic

trt5-ts127-b
Livrare 24-48 ore

9,00Lei(-8%) 8,32Lei

Grub Viber Colmic Herakles 11.4cm Black Red Flk 6buc/plic -35%
Exclusiv online!

Grub Viber Colmic Herakles 11.4cm Black Red Flk 6buc/plic

arhkcz07
Livrare 48-72 ore

31,90Lei(-35%) 20,82Lei

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

Hanger Prologic Senzor Hanger, Blue, 1buc/pac

svs77675
Livrare 7-14 zile

124,94Lei(-37%) 79,10Lei

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

Hanger Prologic Senzor Hanger, Red, 1buc/pac

svs77676
Livrare 7-14 zile

124,94Lei(-37%) 79,10Lei

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

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

svs72839
Livrare 7-14 zile

49,95Lei(-74%) 12,84Lei

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

Hanorac Cu Fermoar Black Cat Zipper, Marime S

8778301
Livrare 7-14 zile

270,00Lei(-18%) 220,22Lei

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

Hanorac Cu Fermoar Black Cat Zipper, Marime Xl

8778304
Livrare 7-14 zile

270,00Lei(-18%) 220,22Lei

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

Hanorac Cu Fermoar Black Cat Zipper, Marime Xxl

8778305
Livrare 7-14 zile

270,00Lei(-18%) 220,22Lei

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

Hanorac Impermeabil Nash Scope Waterproof Smock, Marime 2xl

c0504
Livrare imediată!

909,99Lei(-33%) 613,02Lei

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

Hanorac Jackall Zip Up Black Marime L

ja.807176520
Livrare 24-48 ore

539,45Lei(-18%) 439,81Lei

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

Hanorac Jackall Zip Up Black Marime L

ja.807249767
Livrare 24-48 ore

484,29Lei(-18%) 394,94Lei

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

Hanorac Jackall Zip Up Black Marime Xl

ja.807249774
Livrare 24-48 ore

484,29Lei(-18%) 394,94Lei

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

Hanorac Korda Le Lightweight, Light Kamo, Marime M

kcl371
Livrare imediată!

324,75Lei(-27%) 237,81Lei

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

Hanorac Korda Le Lightweight, Light Kamo, Marime S

kcl370
Livrare imediată!

324,75Lei(-22%) 254,18Lei

Hanorac Madcat Mega Logo Black Caviar L -28%

Hanorac Madcat Mega Logo Black Caviar L

8053173801
Livrare imediată!

211,02Lei(-28%) 151,20Lei

Hanorac Nash Lightweight Hoody Marime Xxxl -30%

Hanorac Nash Lightweight Hoody Marime Xxxl

c5695
Livrare imediată!

210,00Lei(-30%) 147,93Lei

Hanorac Nash Lightweight Hoody, Marime S -24%

Hanorac Nash Lightweight Hoody, Marime S

c5690
Livrare imediată!

210,00Lei(-24%) 160,54Lei

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

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

c1101
Livrare imediată!

196,00Lei(-10%) 176,81Lei

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

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

c1127
Livrare imediată!

196,00Lei(-10%) 176,81Lei

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

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

c1128
Livrare imediată!

196,00Lei(-10%) 176,81Lei

Afişare 1041 - 1060 din 9292 (465 pagini)
Queries: 5, Total time: 689.099 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '5d2882e0b94c90ad8ad7d76caf'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (277.100)
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 (411.594)
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 1040,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.142)
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