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


Lanseta DAM Cult-X SW Spin 2.40m 7-28gr

Lanseta DAM Cult-X SW Spin 2.40m 7-28gr

2040965954
Stoc epuizat

326,39Lei

Mulineta DAM Quick 1 3000 FS

Mulineta DAM Quick 1 3000 FS

3020956972
Stoc epuizat

180,15Lei

Lingura Rotativa 6gr DAM Effzett Fluo Orange

Lingura Rotativa 6gr DAM Effzett Fluo Orange

803090041
Stoc epuizat

13,51Lei

Vartej DAM Effzett Diamond Rolling Swivels No.6 21kg

Vartej DAM Effzett Diamond Rolling Swivels No.6 21kg

40956387
Stoc epuizat

8,47Lei

Lanseta DAM Sensomax II Match 3.90m 5-25gr

Lanseta DAM Sensomax II Match 3.90m 5-25gr

2060966330
Stoc epuizat

299,31Lei

Rig Crap DAM MAD Obstacle Rig Nr 1 25Lb

Rig Crap DAM MAD Obstacle Rig Nr 1 25Lb

711096873001
Stoc epuizat

14,15Lei

Spinner DAM Effzett Pike Rattlin 40 g Silver

Spinner DAM Effzett Pike Rattlin 40 g Silver

80952727
Stoc epuizat

74,36Lei

Waders DAM Hydroforce Nylon Taslan Chestwader 46

Waders DAM Hydroforce Nylon Taslan Chestwader 46

5068713046
Stoc epuizat

410,79Lei

Lanseta DAM Cult-X SW Spin 2.70m 7-28gr

Lanseta DAM Cult-X SW Spin 2.70m 7-28gr

2040965957
Stoc epuizat

374,77Lei

Lanseta DAM Cult-X SW Spin 2.40m 12-42gr

Lanseta DAM Cult-X SW Spin 2.40m 12-42gr

2040965955
Stoc epuizat

336,26Lei

Vesta DAM Effzett Pro-Tact Spinning cu 2 Cutii

Vesta DAM Effzett Pro-Tact Spinning cu 2 Cutii

8062971258
Stoc epuizat

522,59Lei

Husa Lanseta DAM Madcat Single Rod Holdall 300cm

Husa Lanseta DAM Madcat Single Rod Holdall 300cm

9053152012
Stoc epuizat

156,89Lei

Cicada DAM Salt-X Pilk-Blade 75gr Japanese Red UV

Cicada DAM Salt-X Pilk-Blade 75gr Japanese Red UV

13060966082
Stoc epuizat

47,93Lei

Cicada DAM Salt-X Pilk-Blade 100gr Mackerel

Cicada DAM Salt-X Pilk-Blade 100gr Mackerel

13060966083
Stoc epuizat

55,03Lei

Lingura Rotativa 6gr DAM Effzett Fluo Yellow

Lingura Rotativa 6gr DAM Effzett Fluo Yellow

803090031
Stoc epuizat

15,37Lei

Vartej DAM Effzett Diamond Rolling Swivels No.8 17kg

Vartej DAM Effzett Diamond Rolling Swivels No.8 17kg

40956386
Stoc epuizat

8,47Lei

Lingura Oscilanta 28gr 90mm DAM Effzett Original Heintz Silver Copper

Lingura Oscilanta 28gr 90mm DAM Effzett Original Heintz Silver Copper

8025027090
Stoc epuizat

24,19Lei

Lingura Rotativa 7gr DAM Effzett Minnow Silver Black

Lingura Rotativa 7gr DAM Effzett Minnow Silver Black

803090150
Stoc epuizat

21,75Lei

Shad DAM Effzett 200mm Green Catfish Curl Tail

Shad DAM Effzett 200mm Green Catfish Curl Tail

801095820102
Stoc epuizat

46,29Lei

Pluta Culisanta Somn DAM Madcat Chemical Light Float 150g

Pluta Culisanta Somn DAM Madcat Chemical Light Float 150g

417097122150
Stoc epuizat

45,12Lei

Afişare 1281 - 1300 din 1509 (76 pagini)
Queries: 5, Total time: 41.147 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '99e08650afd36aeca714fcecf9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (34.863)
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.958)
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 1280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.141)
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