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


Husa Mulineta Dam O.t.t. Reel Case 10x20x16cm -42%
Exclusiv online!

Husa Mulineta Dam O.t.t. Reel Case 10x20x16cm

svs74982
Livrare 7-14 zile

59,96Lei(-42%) 34,85Lei

Husa Mulinete Carryall Abu Garcia Beast Beast Pro Reel Pouch -36%
Exclusiv online!

Husa Mulinete Carryall Abu Garcia Beast Beast Pro Reel Pouch

1528434
Livrare 7-14 zile

71,28Lei(-36%) 45,64Lei

Husa Mulinete Team Feeder By Dome S 21x16x9cm -17%

Husa Mulinete Team Feeder By Dome S 21x16x9cm

5301-004
Livrare imediată!

51,00Lei(-17%) 42,50Lei

Husa Rhino Rc Bag Universal, 16x8x4cm -36%
Exclusiv online!

Husa Rhino Rc Bag Universal, 16x8x4cm

9944003
Livrare 7-14 zile

39,95Lei(-36%) 25,37Lei

Husa Rigida Fl 1 Compartiment 115cm -43%

Husa Rigida Fl 1 Compartiment 115cm

5752123467530
Livrare imediată!

90,00Lei(-43%) 51,74Lei

Husa Tigaie Delphin Pancase 46x30x9cm -41%

Husa Tigaie Delphin Pancase 46x30x9cm

101003321
Livrare imediată!

87,00Lei(-41%) 51,74Lei

Husa Ușoară Delphin Light Space C2g -39%

Husa Ușoară Delphin Light Space C2g

101002386
Livrare imediată!

101,00Lei(-39%) 61,92Lei

Jacheta Avid Carp Ripstop Camo Jacket Marime S -43%

Jacheta Avid Carp Ripstop Camo Jacket Marime S

a0620180
Livrare imediată!

442,76Lei(-43%) 253,06Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea L -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea L

a0620334
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea M -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea M

a0620333
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea S -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea S

a0620332
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xl -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xl

a0620335
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxl -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxl

a0620336
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxxl -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxxl

a0620337
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Browning Xpo Coldkill Pp Verde Marime M -13%
Exclusiv online!

Jacheta Browning Xpo Coldkill Pp Verde Marime M

bo.30469540.m
Livrare 24-48 ore

547,21Lei(-13%) 474,49Lei

Jacheta Cu Gluga Fox Rage Wind Blocker Jacket Masura Xl -18%

Jacheta Cu Gluga Fox Rage Wind Blocker Jacket Masura Xl

npr276
Livrare imediată!

424,89Lei(-18%) 347,54Lei

Jacheta Fleece Korda Kore Polar, Olive, Marime S -5%

Jacheta Fleece Korda Kore Polar, Olive, Marime S

kcl322
Livrare imediată!

374,95Lei(-5%) 355,34Lei

Jacheta Fox Rage Voyager Lightweight Wind Blocker S -25%

Jacheta Fox Rage Voyager Lightweight Wind Blocker S

npr424
Livrare imediată!

427,46Lei(-25%) 321,19Lei

Jacheta Gamakatsu Gama G Quilted Fleece, Marime L -18%
Exclusiv online!

Jacheta Gamakatsu Gama G Quilted Fleece, Marime L

a8.gk.7245.300
Livrare 24-48 ore

359,73Lei(-18%) 293,62Lei

Jacheta Gamakatsu Gama G Quilted Fleece, Marime M -18%
Exclusiv online!

Jacheta Gamakatsu Gama G Quilted Fleece, Marime M

a8.gk.7245.200
Livrare 24-48 ore

359,73Lei(-18%) 293,62Lei

Afişare 1101 - 1120 din 9291 (465 pagini)
Queries: 5, Total time: 662.743 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '055660ad60935bc3e7ef0c8a09'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (315.965)
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 (346.415)
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 1100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.118)
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