DAM


Mulineta, DAM, QUICK, IMPRESSA, 4S, 5000S, dam.72996, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, D.A.M
Lanseta DAM Base X Feeder M 3.60m, pana la 90g, 3+3seg

Lanseta DAM Base X Feeder M 3.60m, pana la 90g, 3+3seg

dam.70396
Livrare imediată!

168,83Lei

Lanseta DAM Yagi Spin F, 2.10m, 12-42g, 2seg

Lanseta DAM Yagi Spin F, 2.10m, 12-42g, 2seg

dam.60036
Livrare 24-48 ore

234,36Lei

Mulineta, DAM, Runshift, 3QF, 5000, BF,, 0.33mm-265m,, 5.1:1,, 2+1BB, dam.73038, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M -30%
Lanseta, DAM, Madcat, White, Clonk, Teaser,, 2.40m,, 1200-250g,, 2seg, mad.1604091, Lansete Somn, Lansete Somn DAM, Lansete 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

Fir textil DAM Crosspower 4 Braid 0.15mm 150m

Fir textil DAM Crosspower 4 Braid 0.15mm 150m

11020966577
Livrare imediată!

43,80Lei

Mulineta, DAM, Quick, 2, 8000, FD, V2, dam.75983, 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 -20%
Lanseta DAM Imax SW Spin 2.40m 20-50g

Lanseta DAM Imax SW Spin 2.40m 20-50g

2040970620
Livrare 48-72 ore

249,75Lei

Lanseta Spinning DAM Aqua-X Shad Pilk MF 2.70m, 50-150g, 2seg

Lanseta Spinning DAM Aqua-X Shad Pilk MF 2.70m, 50-150g, 2seg

dam.66270
Livrare imediată!

164,01Lei

Set Avertizoare DAM Madcat Smart Mcl 3+1

Set Avertizoare DAM Madcat Smart Mcl 3+1

a.mad.70840
Livrare imediată!

1.206,49Lei

Mulineta, DAM, QUICK, FUN-TECH, 3, MK1, 1000, FD, dam.72974, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, D.A.M
Lanseta cu Aplicatie Universala DAM Aqua X AllRound MF 2.10m, 100-170g, 2seg

Lanseta cu Aplicatie Universala DAM Aqua X AllRound MF 2.10m, 100-170g, 2seg

dam.66273
Livrare 24-48 ore

136,70Lei

Mulineta DAM Quick Fahrenheit 6 5000 S FD, 0.33mm-230m, 5.1:1, 5+1BB

Mulineta DAM Quick Fahrenheit 6 5000 S FD, 0.33mm-230m, 5.1:1, 5+1BB

dam.73010
Livrare 24-48 ore

259,96Lei

Lanseta Dam Iconic Carp, 3.50lbs, 3.90m, 3seg

Lanseta Dam Iconic Carp, 3.50lbs, 3.90m, 3seg

dam.75847
Livrare imediată!

267,16Lei

Fir, DAM, Damyl, New, Spezi, Line, Carp, 0.35mm, 300m, a.dam.66627, Fire Monofilament Crap, Fire Monofilament Crap DAM, DAM
Momitor DAM Detek Pellet Feeder Elasticated 25g -30%

Momitor DAM Detek Pellet Feeder Elasticated 25g

a.dam.66029
Livrare imediată!

13,61Lei(-30%) 9,52Lei

Mulineta, DAM, Quick, Nova, FS, 5000, dam.75968, 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
Lanseta DAM Nanoflex Pro+ 2.70m 14-40g

Lanseta DAM Nanoflex Pro+ 2.70m 14-40g

2040970274
Livrare 48-72 ore

309,50Lei

Afişare 41 - 60 din 1125 (57 pagini)
Queries: 9, Total time: 131.977 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = 'cf72a807152194efabb00652ef'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.136)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.135)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (55.730)
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 = '0' AND p.manufacturer_id = '124'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (75.364)
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 = '0' AND p.manufacturer_id = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.118)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38