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 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Geanta DAM Hip Shoulder Bag S 35x17x18cm 2 Cutii

Geanta DAM Hip Shoulder Bag S 35x17x18cm 2 Cutii

9040960347
Stoc epuizat

255,79Lei

Lanseta DAM Madcat New Black Heavy Duty 3.00m 200-300gr -27%

Lanseta DAM Madcat New Black Heavy Duty 3.00m 200-300gr

2033170696
Stoc epuizat

384,38Lei(-27%) 280,90Lei

Bocanci DAM WP Boot 45-9 Grey Black

Bocanci DAM WP Boot 45-9 Grey Black

8140965344
Stoc epuizat

505,77Lei

Bocanci DAM High Grip Boot 45-10 Dark Green

Bocanci DAM High Grip Boot 45-10 Dark Green

8140965351
Stoc epuizat

431,34Lei

Cosulet Naditor DAM Detek Groundbait Feeder Inline 35gr -30%

Cosulet Naditor DAM Detek Groundbait Feeder Inline 35gr

a.dam.66042
Stoc epuizat

13,58Lei(-30%) 9,50Lei

Lanseta DAM Effzett Z1 Twitch and Jig 2.10m 7-30g

Lanseta DAM Effzett Z1 Twitch and Jig 2.10m 7-30g

2042960058
Stoc epuizat

866,01Lei

Vartej Rapid DAM Detek Quick Change Swivel Nr.12

Vartej Rapid DAM Detek Quick Change Swivel Nr.12

a.dam.66003
Stoc epuizat

17,01Lei

Lanseta Telescopica DAM New Shadow Mini Spin 2.40m 7-30g 9seg

Lanseta Telescopica DAM New Shadow Mini Spin 2.40m 7-30g 9seg

dam.70794
Stoc epuizat

281,22Lei

Lanseta Telescopica DAM New Shadow Mini Spin 2.10m 5-15g 8seg

Lanseta Telescopica DAM New Shadow Mini Spin 2.10m 5-15g 8seg

dam.70792
Stoc epuizat

234,36Lei

Lanseta DAM Yagi Light Spoon 2.10m 3-6g

Lanseta DAM Yagi Light Spoon 2.10m 3-6g

dam.70666
Stoc epuizat

234,63Lei

Fir textil DAM Crosspower 4 Braid 0.13mm 150m

Fir textil DAM Crosspower 4 Braid 0.13mm 150m

11020966576
Stoc epuizat

46,68Lei

Lanseta DAM Yagi Light Spoon 1.90m 3-6gr

Lanseta DAM Yagi Light Spoon 1.90m 3-6gr

2040970663
Stoc epuizat

225,39Lei

Mulineta DAM Quick Nova FS 5000

Mulineta DAM Quick Nova FS 5000

dam.75968
Stoc epuizat

107,77Lei

Conector Magnetic DAM Minciog Cablu Siguranta

Conector Magnetic DAM Minciog Cablu Siguranta

601098420222
Stoc epuizat

41,53Lei

Fir textil DAM Crosspower 4 Braid 0.22mm 150m

Fir textil DAM Crosspower 4 Braid 0.22mm 150m

11020966580
Stoc epuizat

43,80Lei

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

11020966575
Stoc epuizat

46,68Lei

Mulineta DAM Nova FD 6000 + Fir Monofilament, 0.40mm-210m, 5.2:1, 1BB

Mulineta DAM Nova FD 6000 + Fir Monofilament, 0.40mm-210m, 5.2:1, 1BB

dam.75959
Stoc epuizat

74,97Lei

Lanseta DAM Yagi Light Spoon 1.90m 1-4gr

Lanseta DAM Yagi Light Spoon 1.90m 1-4gr

2040970661
Stoc epuizat

222,85Lei

Conector DAM Detek Quick Change Bead

Conector DAM Detek Quick Change Bead

4060466007
Stoc epuizat

11,69Lei

Lanseta DAM Imax Boat 2.10m H 100-300gr

Lanseta DAM Imax Boat 2.10m H 100-300gr

2030970603
Stoc epuizat

304,71Lei

Afişare 1141 - 1160 din 1506 (76 pagini)
Queries: 6, Total time: 41.912 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '1ebe0e19c3d69f75357bfb0fc3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (35.970)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+dam' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (5.502)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 1140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.157)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.093)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38