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


Jacheta Imax Arx Thermo Marimea M -29%
Exclusiv online!

Jacheta Imax Arx Thermo Marimea M

a8.imx.57248
Livrare 24-48 ore

315,34Lei(-29%) 225,45Lei

Jacheta Imax Arx Thermo Marimea Xl -29%

Jacheta Imax Arx Thermo Marimea Xl

a8.imx.57250
Livrare imediată!

416,65Lei(-29%) 297,56Lei

Jacheta Imax Arx Thermo Marimea Xxl -29%
Exclusiv online!

Jacheta Imax Arx Thermo Marimea Xxl

a8.imx.57251
Livrare 24-48 ore

416,65Lei(-29%) 297,56Lei

Jacheta Jackall Timon Rain Wear, Marime L -29%
Exclusiv online!

Jacheta Jackall Timon Rain Wear, Marime L

ja.807294033
Livrare 24-48 ore

1.881,61Lei(-29%) 1.340,27Lei

Jacheta Nash Waterproof Jacket, Marimea M -30%

Jacheta Nash Waterproof Jacket, Marimea M

c0031
Livrare imediată!

439,99Lei(-30%) 308,47Lei

Jacheta Prologic Fleece Tech Marime L -18%
Exclusiv online!

Jacheta Prologic Fleece Tech Marime L

a8.pro.57273
Livrare 24-48 ore

291,23Lei(-18%) 237,91Lei

Jacheta Prologic Fleece Tech Marime S -18%
Exclusiv online!

Jacheta Prologic Fleece Tech Marime S

a8.pro.57271
Livrare 24-48 ore

291,23Lei(-18%) 237,91Lei

Jacheta Prologic Fleece Tech Marime Xl -18%
Exclusiv online!

Jacheta Prologic Fleece Tech Marime Xl

a8.pro.57274
Livrare 24-48 ore

291,23Lei(-18%) 237,91Lei

Jacheta Prologic Fleece Tech Marime Xxl -18%
Exclusiv online!

Jacheta Prologic Fleece Tech Marime Xxl

a8.pro.57275
Livrare 24-48 ore

291,23Lei(-18%) 237,91Lei

Jacheta Prologic Thermo Armour Pro Max5 Marime: L -39%
Exclusiv online!

Jacheta Prologic Thermo Armour Pro Max5 Marime: L

a8.pro.48025
Livrare 24-48 ore

760,03Lei(-39%) 464,66Lei

Jacheta Ridgemonkey Dropback Lightweight Hydrophobic Green, S -31%

Jacheta Ridgemonkey Dropback Lightweight Hydrophobic Green, S

rm211
Livrare imediată!

296,95Lei(-31%) 204,26Lei

Jacheta Salmo Soft Shell Marime Xxl -23%

Jacheta Salmo Soft Shell Marime Xxl

qpr031
Livrare imediată!

350,95Lei(-23%) 269,55Lei

Jacheta Savage Gear Jacket Coastal Race Smock S, Black-gray-yellow -43%
Exclusiv online!

Jacheta Savage Gear Jacket Coastal Race Smock S, Black-gray-yellow

svs77660
Livrare 7-14 zile

674,95Lei(-43%) 383,42Lei

Jacheta Savage Gear Reflection Hybrid Jacket S, Black-gray -41%
Exclusiv online!

Jacheta Savage Gear Reflection Hybrid Jacket S, Black-gray

svs76559
Livrare 7-14 zile

499,95Lei(-41%) 294,41Lei

Jacheta Savage Gear Sg2 Hybrid Slate Green Marime M -65%
Exclusiv online!

Jacheta Savage Gear Sg2 Hybrid Slate Green Marime M

svs73719
Livrare 7-14 zile

849,96Lei(-65%) 299,15Lei

Jacheta Savage Gear Sg2 Hybrid Slate Green Marime S -57%
Exclusiv online!

Jacheta Savage Gear Sg2 Hybrid Slate Green Marime S

svs73718
Livrare 7-14 zile

849,95Lei(-57%) 364,73Lei

Jacheta Savage Gear Sg4 Wading, Olive Green, Marime S -55%
Exclusiv online!

Jacheta Savage Gear Sg4 Wading, Olive Green, Marime S

svs73723
Livrare 7-14 zile

1.099,95Lei(-55%) 499,13Lei

Jacheta Savage Pro Guard Thermo Mas.m -49%
Exclusiv online!

Jacheta Savage Pro Guard Thermo Mas.m

a8.sg.47900
Livrare 24-48 ore

492,70Lei(-49%) 251,49Lei

Jacheta Trakker Cr Downpour Jacket, Kaki, Marimea L -13%

Jacheta Trakker Cr Downpour Jacket, Kaki, Marimea L

206446
Livrare imediată!

474,95Lei(-13%) 411,50Lei

Jacheta Trakker Cr Downpour Jacket, Kaki, Marimea M -13%

Jacheta Trakker Cr Downpour Jacket, Kaki, Marimea M

206445
Livrare imediată!

474,95Lei(-13%) 411,50Lei

Afişare 1121 - 1140 din 9291 (465 pagini)
Queries: 5, Total time: 745.617 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '536e1195c2455eacf59ea3ed40'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (342.840)
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 (402.489)
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 1120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.122)
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