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


Pantaloni Trakker Cr Jogger Black, Marime S -13%

Pantaloni Trakker Cr Jogger Black, Marime S

207871
Livrare imediată!

204,95Lei(-13%) 178,14Lei

Pantaloni Trakker Cr Jogger Black, Marime Xl -13%

Pantaloni Trakker Cr Jogger Black, Marime Xl

207874
Livrare imediată!

204,95Lei(-13%) 178,14Lei

Pantaloni Tubertini Men's Trousers Winter Under Pants Noir, Masura Xxl -13%
Exclusiv online!

Pantaloni Tubertini Men's Trousers Winter Under Pants Noir, Masura Xxl

714820d
Livrare 7-14 zile

162,50Lei(-13%) 141,45Lei

Pantaloni Tubertini Men's Trousers Winter Under Pants Noir, Masura Xxxl -13%
Exclusiv online!

Pantaloni Tubertini Men's Trousers Winter Under Pants Noir, Masura Xxxl

714820e
Livrare 7-14 zile

162,50Lei(-13%) 141,45Lei

Pantaloni Tubertini Men's Trousers Winter Under Pants Noir, Masura Xxxxl -13%
Exclusiv online!

Pantaloni Tubertini Men's Trousers Winter Under Pants Noir, Masura Xxxxl

714820f
Livrare 7-14 zile

162,50Lei(-13%) 141,45Lei

Pantofi Casual Coolfit Savage Gear Marime 42 -28%

Pantofi Casual Coolfit Savage Gear Marime 42

a8.sg.51146
Livrare imediată!

206,08Lei(-28%) 147,67Lei

Pantofi Casual Coolfit Savage Gear Marimea 43 -28%

Pantofi Casual Coolfit Savage Gear Marimea 43

a8.sg.51147
Livrare imediată!

206,08Lei(-28%) 147,67Lei

Pantofi Casual Coolfit Savage Gear Marimea 44 -28%

Pantofi Casual Coolfit Savage Gear Marimea 44

a8.sg.51148
Livrare imediată!

206,08Lei(-28%) 147,67Lei

Pantofi Nash Water Shoe Uk Marime 44 -45%

Pantofi Nash Water Shoe Uk Marime 44

c5533
Livrare imediată!

169,99Lei(-45%) 93,02Lei

Pantofi Savage Sport Gear Sneakers Mar. 44 -47%
Exclusiv online!

Pantofi Savage Sport Gear Sneakers Mar. 44

a8.sg.62318
Livrare 24-48 ore

361,75Lei(-47%) 190,66Lei

Pantofi Sport Okuma Light, Marime 38 -18%
Exclusiv online!

Pantofi Sport Okuma Light, Marime 38

a8.okr.h001k.38
Livrare 24-48 ore

172,97Lei(-18%) 141,72Lei

Pantofi Sport Savage Urban, Marime 42 -33%
Exclusiv online!

Pantofi Sport Savage Urban, Marime 42

a8.sg.64954
Livrare 24-48 ore

236,23Lei(-33%) 157,74Lei

Pantofi Sport Savage Urban, Marime 44 -33%
Exclusiv online!

Pantofi Sport Savage Urban, Marime 44

a8.sg.64956
Livrare 24-48 ore

236,23Lei(-33%) 157,74Lei

Papuci Nash Sliders Black, Nr.42 -35%

Papuci Nash Sliders Black, Nr.42

c5525
Livrare imediată!

215,55Lei(-35%) 140,20Lei

Papuci Nash Zt Deluxe Bivvy Camo Nr.41 -18%

Papuci Nash Zt Deluxe Bivvy Camo Nr.41

c6131
Livrare imediată!

149,99Lei(-18%) 122,92Lei

Papuci Nash Zt Deluxe Bivvy Nr.40 -48%

Papuci Nash Zt Deluxe Bivvy Nr.40

c6135
Livrare imediată!

139,98Lei(-48%) 73,18Lei

Papuci Nash Zt Deluxe Bivvy Nr.41 -30%

Papuci Nash Zt Deluxe Bivvy Nr.41

c6136
Livrare imediată!

139,98Lei(-30%) 97,49Lei

Papuci Nash Zt Deluxe Bivvy Nr.42 -30%

Papuci Nash Zt Deluxe Bivvy Nr.42

c6137
Livrare imediată!

139,98Lei(-30%) 97,49Lei

Papuci Prologic Bank Slippers Marimea 47 -38%
Exclusiv online!

Papuci Prologic Bank Slippers Marimea 47

a8.pro.55374
Livrare 24-48 ore

173,41Lei(-38%) 106,79Lei

Pasta Solubila Dynamite Baits Swim Stim Ready To Use Paste Betaine Green 250g -17%

Pasta Solubila Dynamite Baits Swim Stim Ready To Use Paste Betaine Green 250g

dy1195
Livrare imediată!

39,01Lei(-17%) 32,57Lei

Afişare 7041 - 7060 din 9296 (465 pagini)
Queries: 5, Total time: 615.303 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '7bb09af999e59fc053f564d3f8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (310.799)
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 (304.198)
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 7040,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.112)
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