DAM


Lanseta DAM Nanoflex Pro+ 2.10m 14-40g

Lanseta DAM Nanoflex Pro+ 2.10m 14-40g

2040970269
Livrare 48-72 ore

269,90Lei

Mulineta, DAM, Quick, Dynabraid, 4, 2500, FD, cu, Fir, Textil, 15Lb, 3024673001, Mulinete Rapitori, Mulinete Rapitori D.A.M, D.A.M
Lanseta, DAM, Madcat, White, Spin, 2.85m, 175gr, 2033156876, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM -27%

Lanseta, DAM, Madcat, White, Spin, 2.85m, 175gr, 2033156876, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM

2033156876
Livrare imediată!

657,61Lei(-27%) 480,90Lei

Momitor DAM Detek Pellet Feeder Inline 35g -30%

Momitor DAM Detek Pellet Feeder Inline 35g

a.dam.66033
Livrare imediată!

13,86Lei(-30%) 9,70Lei

Mulineta DAM Quick Darkside 8 FD 2500S

Mulineta DAM Quick Darkside 8 FD 2500S

dam.73025
Livrare imediată!

275,71Lei

Mulineta, DAM, QUICK, IMPULSE, 4QF, 3000S, dam.72999, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, D.A.M
Mulineta DAM Impulse 4OTT 4000 Feed / Match 2XGRAPH, 0.25mm-100m, 5.2:1, 3+1BB

Mulineta DAM Impulse 4OTT 4000 Feed / Match 2XGRAPH, 0.25mm-100m, 5.2:1, 3+1BB

dam.73074
Livrare 24-48 ore

229,82Lei

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

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

dam.60038
Livrare 24-48 ore

271,86Lei

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB -20%

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB

dam.73049
Livrare 24-48 ore

216,52Lei(-20%) 173,20Lei

Montura, DAM, Madcat, Profi, River, Rig, Noseclip,, Nr.3/0,, 1.3mm,, 250cm, a.mad.1604099, Monturi Somn, Monturi Somn DAM, Monturi DAM, Somn DAM, DAM
Lanseta DAM New Yagi Light Jig 2.70m 5-26g

Lanseta DAM New Yagi Light Jig 2.70m 5-26g

2040960312
Livrare 48-72 ore

274,79Lei

Fir textil DAM Crosspower 4 Braid 0.20mm 150m

Fir textil DAM Crosspower 4 Braid 0.20mm 150m

11020966579
Livrare imediată!

43,80Lei

Avertizor Electronic Multicolor DAM Madcat Smart MCL

Avertizor Electronic Multicolor DAM Madcat Smart MCL

a.mad.70842
Livrare imediată!

289,52Lei

Mulineta, DAM, QUICK, FUN-TECH, 3, MK1, 3000, FD, dam.72976, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, D.A.M
Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.45mm, 18.1kg/40lb, 100m

Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.45mm, 18.1kg/40lb, 100m

a.dam.66197
Livrare imediată!

32,80Lei

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

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

dam.66275
Livrare 24-48 ore

164,01Lei

Lanseta DAM Base-X Spin M, 1.80, 5-25g, 2seg

Lanseta DAM Base-X Spin M, 1.80, 5-25g, 2seg

dam.70367
Livrare 24-48 ore

91,11Lei

Mulineta, DAM, Quick, Finessa, 8, 2500S, FD,, 0.22mm-190m,, 5.2:1,, 7+1BB, dam.73018, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, D.A.M
Mulineta, DAM, Quick, Dynabraid, 4, 2500S, FD, 0.22mm/190m,, 5.2:1,, 3+1BB, +, Fir, Textil, dam.73001, Mulinete Rapitori, Mulinete Rapitori DAM, Mulinete DAM, Rapitori DAM, DAM
Fir DAM Damyl New Spezi Line Zander 0.25mm 500m

Fir DAM Damyl New Spezi Line Zander 0.25mm 500m

11050966633
Livrare 48-72 ore

24,24Lei

Afişare 61 - 80 din 1127 (57 pagini)
Queries: 9, Total time: 141.420 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '3593d507a9224b1aa503091c9a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.069)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.112)
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 (70.239)
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:1661
7 (70.419)
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 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.137)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.125)
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