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


Carlige Avid Armorok Hooks Curve Barbless, Nr.8, 10buc/pac -56%

Carlige Avid Armorok Hooks Curve Barbless, Nr.8, 10buc/pac

a0520008
Livrare imediată!

29,95Lei(-56%) 13,18Lei

Carlige Avid Armorok Hooks Wide Gape Barbless, Nr.8, 10buc/pac -56%
Exclusiv online!

Carlige Avid Armorok Hooks Wide Gape Barbless, Nr.8, 10buc/pac

a0520024
Livrare 7-14 zile

29,95Lei(-56%) 13,18Lei

Carlige Bkk Chinu Diamond Black Nickel Nr.2 8buc/plic -11%

Carlige Bkk Chinu Diamond Black Nickel Nr.2 8buc/plic

6939067097620
Livrare imediată!

9,00Lei(-11%) 8,02Lei

Carlige Bkk Chinu Shark Nr.4 10buc/plic -8%

Carlige Bkk Chinu Shark Nr.4 10buc/plic

6939067098634
Livrare imediată!

9,80Lei(-8%) 9,03Lei

Carlige Bkk Chinu Tournament Nr.10, 12buc/plic -13%

Carlige Bkk Chinu Tournament Nr.10, 12buc/plic

6939067098153
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Carlige Bkk Chinu Tournament Nr.4, 10buc/plic -13%

Carlige Bkk Chinu Tournament Nr.4, 10buc/plic

6939067098214
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Carlige Bkk Chinu Tournament Nr.6, 10buc/plic -13%

Carlige Bkk Chinu Tournament Nr.6, 10buc/plic

6939067098191
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Carlige Bkk Chinu Tournament Nr.8, 12buc/plic -13%

Carlige Bkk Chinu Tournament Nr.8, 12buc/plic

6939067098177
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Carlige Bkk Chinu-r Diamond Black Nickel Nr.4 10buc/plic -12%

Carlige Bkk Chinu-r Diamond Black Nickel Nr.4 10buc/plic

6939067017499
Livrare imediată!

8,00Lei(-12%) 7,01Lei

Carlige Bkk Chinu-r Shark Nr.2, 8buc/plic -13%

Carlige Bkk Chinu-r Shark Nr.2, 8buc/plic

6970595289057
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Carlige Bkk Classic Boiles Diamond Nr.2, 10buc/plic -11%

Carlige Bkk Classic Boiles Diamond Nr.2, 10buc/plic

4101201311066
Livrare imediată!

12,50Lei(-11%) 11,07Lei

Carlige Bkk Classic Boiles Diamond Nr.4, 10buc/plic -11%

Carlige Bkk Classic Boiles Diamond Nr.4, 10buc/plic

4101201311080
Livrare imediată!

12,50Lei(-11%) 11,07Lei

Carlige Bkk Classic Boiles Super Slide Bait Hook Nr.2, 10buc/plic -33%

Carlige Bkk Classic Boiles Super Slide Bait Hook Nr.2, 10buc/plic

4101201301067
Livrare imediată!

19,51Lei(-33%) 13,10Lei

Carlige Bkk Iseama Diamond Black Nickel Nr.2 8buc/plic -12%

Carlige Bkk Iseama Diamond Black Nickel Nr.2 8buc/plic

6939067097491
Livrare imediată!

8,00Lei(-12%) 7,01Lei

Carlige Bkk Iseama Diamond Black Nickel Nr.4 10buc/plic -12%

Carlige Bkk Iseama Diamond Black Nickel Nr.4 10buc/plic

6939067097477
Livrare imediată!

8,00Lei(-12%) 7,01Lei

Carlige Bkk Iseama Diamond Black Nickel Nr.6 12buc/plic -12%

Carlige Bkk Iseama Diamond Black Nickel Nr.6 12buc/plic

6939067097453
Livrare imediată!

8,00Lei(-12%) 7,01Lei

Carlige Bkk Iseama Diamond Black Nickel Nr.8 12buc/plic -12%

Carlige Bkk Iseama Diamond Black Nickel Nr.8 12buc/plic

6939067097439
Livrare imediată!

8,00Lei(-12%) 7,01Lei

Carlige Bkk Iseama Tournament Competition Nr 10 12/plic -13%

Carlige Bkk Iseama Tournament Competition Nr 10 12/plic

6939067098047
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Carlige Bkk Iseama Tournament Competition Nr 12 12/plic -13%

Carlige Bkk Iseama Tournament Competition Nr 12 12/plic

6939067098023
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Carlige Bkk Iseama Tournament Competition Nr 2 8/plic -13%

Carlige Bkk Iseama Tournament Competition Nr 2 8/plic

6939067098122
Livrare imediată!

11,50Lei(-13%) 10,06Lei

Afişare 461 - 480 din 9311 (466 pagini)
Queries: 5, Total time: 656.345 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '03e2450f2387a13a1ea713cf7a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (289.405)
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 (366.615)
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 460,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.137)
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