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


539,95Lei(-13%) 468,58Lei

917,95Lei(-13%) 794,37Lei

377,96Lei(-13%) 327,66Lei

427,46Lei(-13%) 370,45Lei

494,96Lei(-13%) 428,78Lei

Sac De Dormit Fox R3 Camo 220x107

csb068
Livrare imediată!

809,95Lei(-13%) 701,95Lei

Sac De Dormit Ngt Profiler Cu Microfleece 5 Sezoane

ngt-fbc-sbag-profiler
Livrare imediată!

850,00Lei(-27%) 619,12Lei

Sac Impermeabil Coghlans 25l

c1110
Livrare imediată!

92,99Lei(-5%) 88,45Lei

Sac Solubil Carp Spirit 22mm 5mt

acs010059
Livrare imediată!

45,00Lei(-19%) 36,49Lei

Exclusiv online!

Safety Clip Jaxon Pro Carp Maro

ac-pc027c
Livrare 48-72 ore

5,40Lei(-21%) 4,25Lei

Exclusiv online!

Safety Clip Jaxon Pro Carp Transparent

ac-pc027a
Livrare 48-72 ore

5,40Lei(-21%) 4,25Lei

Exclusiv online!

Safety Clip Jaxon Pro Carp Verde

ac-pc027b
Livrare 48-72 ore

5,00Lei(-19%) 4,05Lei

13,00Lei(-22%) 10,15Lei

Exclusiv online!

397,00Lei(-29%) 283,67Lei

Exclusiv online!

Salopeta Cormoran Neopren Mar.40/41

a8.94.03041
Livrare 24-48 ore

692,39Lei(-10%) 624,15Lei

Exclusiv online!

Salopeta Cormoran Neopren Mar.42/43

a8.94.03243
Livrare 24-48 ore

692,39Lei(-10%) 624,15Lei

Exclusiv online!

Salopeta Cormoran Neopren Mar.44/45

a8.94.03445
Livrare 24-48 ore

692,39Lei(-10%) 624,15Lei

Exclusiv online!

Salopeta Cormoran Neopren Mar.46/47

a8.94.03647
Livrare 24-48 ore

692,39Lei(-10%) 624,15Lei

Exclusiv online!

693,31Lei(-8%) 636,30Lei

Exclusiv online!

250,00Lei(-35%) 163,59Lei

Afişare 7481 - 7500 din 9304 (466 pagini)
Queries: 6, Total time: 588.904 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = '664e33eeb0574124d6bc485037'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (264.856)
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 (323.422)
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 7480,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.252)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FREIKO HANDELSGESELLSCHAFT"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.174)
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