DAM


Cosulet, Naditor, DAM, Detek, Maggot, Feeder, cu, Vartej, 100gr, a.dam.66038, Pellet Feeder Maggot Feeder, Pellet Feeder Maggot Feeder DAM, Pellet DAM, Feeder DAM, Maggot DAM, Feeder DAM, DAM -30%
Lanseta DAM Base-X Spin 2.40 20-40g

Lanseta DAM Base-X Spin 2.40 20-40g

dam.70369
Livrare 24-48 ore

104,80Lei

Mulineta, DAM, Quick, Darkside, 4, Spod, FD, 7000S, , dam.78882, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M
Mulineta DAM Nova FD 5000 + Fir Monofilament, 0.35mm-220m, 5.2:1, 1BB

Mulineta DAM Nova FD 5000 + Fir Monofilament, 0.35mm-220m, 5.2:1, 1BB

dam.75958
Livrare imediată!

70,29Lei

Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

a.mad.70764
Livrare imediată!

1.509,87Lei

Mulineta DAM IMPULSE 8 4000 FEEDER

Mulineta DAM IMPULSE 8 4000 FEEDER

dam.73070
Livrare 24-48 ore

267,31Lei

Momitor, Method, Feeder, DAM, Detek, Inline,, Marime, M,, 40g,, 1buc/pac, a.dam.66019, Momitoare Method Feeder, Momitoare Method Feeder DAM, Momitoare DAM, Method DAM, Feeder DAM, DAM
Lanseta DAM Sensomax Il Carp Picker 2.75m, 15-55g, 2+3seg

Lanseta DAM Sensomax Il Carp Picker 2.75m, 15-55g, 2+3seg

dam.66315
Livrare 24-48 ore

257,79Lei

Varga Dam Tele Base-X, 3m

Varga Dam Tele Base-X, 3m

dam.71041
Livrare imediată!

40,91Lei

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

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

2033170696
Livrare imediată!

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

Lanseta DAM XT5 50 3.90m 2seg 3.50Lbs

Lanseta DAM XT5 50 3.90m 2seg 3.50Lbs

2020970899
Livrare 48-72 ore

661,45Lei

Mulineta, DAM, Quick, Impressa, 3, FD, 2500, dam.72981, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, Mulinete Bolognese, Mulinete Bolognese D.A.M, Mulinete D.A.M, Bolognese D.A.M, Mulinete Match, Mulinete Match D.A.M, Mulinete D.A.M, Match D.A.M, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M
Lanseta DAM Madcat White Spin 2.10m 175gr -27%

Lanseta DAM Madcat White Spin 2.10m 175gr

2033156873
Livrare imediată!

494,93Lei(-27%) 361,90Lei

Mulineta DAM RUNSHIFT 3A 5000 BF -30%

Mulineta DAM RUNSHIFT 3A 5000 BF

dam.73041
Livrare imediată!

164,95Lei(-30%) 115,45Lei

Struna DAM Kink Free Titanium 20cm, 15kig, 2buc/pac

Struna DAM Kink Free Titanium 20cm, 15kig, 2buc/pac

a7.dam.56397
Livrare 24-48 ore

28,60Lei

Suport DAM Salt-X pentri 1 Lanseta, Ajustabil, 75cm

Suport DAM Salt-X pentri 1 Lanseta, Ajustabil, 75cm

a6.dam.52810
Livrare 24-48 ore

73,63Lei

Mulineta, DAM, Quick, 2, 4000, BF,, 0.25mm-340m,, 5.2:1,, 5+1BB, dam.75986, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M -30%
Carlige, DAM, Madcat, A-Static, Teaser, Nr.5/0,, 5buc/pac, a.mad.56837, Carlige Somn, Carlige Somn DAM, Carlige DAM, Somn DAM, DAM
Fir, DAM, Damyl, New, Spezi, Line, Coarse, Transparent, 1.90kg, 0.14mm, 500m, a.dam.66641, Fire Monofilament Crap, Fire Monofilament Crap DAM, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder DAM, Fire Monofilament Rapitori, Fire Monofilament Rapitori DAM, DAM
Bocanci DAM WP Boot Grey Black 41

Bocanci DAM WP Boot Grey Black 41

8140965340
Livrare imediată!

505,77Lei

Afişare 1 - 20 din 1125 (57 pagini)
Queries: 9, Total time: 98.977 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = 'e38508b2796aacbe82a35a641a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.128)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.144)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.140)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '124' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (36.660)
SELECT COUNT(1) AS total
FROM oc_product p
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 pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '3' AND p.manufacturer_id = '124'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (61.439)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
FROM oc_product p
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 pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '3' AND p.manufacturer_id = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.110)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.093)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38