DAM

DAM

Sortare după:

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

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

dam.75983

Livrare 24-48 ore

279,72Lei(-20%) 223,77Lei

Lanseta DAM Madcat White Deluxe G2 2.75m, 150-350g, 2seg

Lanseta DAM Madcat White Deluxe G2 2.75m, 150-350g, 2seg

2033151833

Livrare imediată!

702,20Lei(-29%) 498,55Lei

Kit DAM Feeder Detek Method M, 25+40g, 2+1buc/pac

Kit DAM Feeder Detek Method M, 25+40g, 2+1buc/pac

a.dam.66023

Livrare imediată!

44,33Lei

Mulineta DAM Quick Insider 7 FD 5000S

Mulineta DAM Quick Insider 7 FD 5000S

dam.73015

Livrare imediată!

253,77Lei

Mulineta DAM QUICK IMPRESSA 4S 5000S

Mulineta DAM QUICK IMPRESSA 4S 5000S

dam.72996

Livrare imediată!

198,14Lei

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, dam.60036, Lansete Rapitori, Lansete Rapitori DAM, DAM

Lanseta, DAM, Yagi, Spin, F,, 2.10m,, 12-42g,, 2seg, dam.60036, Lansete Rapitori, Lansete Rapitori DAM, DAM

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

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

dam.73038

Livrare 24-48 ore

163,63Lei(-30%) 114,53Lei

Lanseta, DAM, Madcat, White, Clonk, Teaser,, 2.40m,, 1200-250g,, 2seg, mad.1604091, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM

Lanseta, DAM, Madcat, White, Clonk, Teaser,, 2.40m,, 1200-250g,, 2seg, mad.1604091, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM

mad.1604091

Livrare 24-48 ore

602,47Lei

Fir DAM Damyl New Spezi Line Coarse Transparent, 2.80kg, 0.18mm, 500m

Fir DAM Damyl New Spezi Line Coarse Transparent, 2.80kg, 0.18mm, 500m

11070966643

Livrare imediată!

24,24Lei

Lanseta DAM Shadow Tele 2.10m 25-40gr

Lanseta DAM Shadow Tele 2.10m 25-40gr

2040970347

Livrare imediată!

217,81Lei

Fir textil DAM Crosspower 4 Braid 0.15mm 150m

Fir textil DAM Crosspower 4 Braid 0.15mm 150m

11020966577

Livrare imediată!

43,80Lei

Lanseta, DAM, Imax, SW, Spin, 2.40m, 20-50g, 2040970620, Lansete Rapitori, Lansete Rapitori DAM, DAM

Lanseta, DAM, Imax, SW, Spin, 2.40m, 20-50g, 2040970620, Lansete Rapitori, Lansete Rapitori DAM, DAM

2040970620

Livrare 48-72 ore

249,75Lei

Lanseta, Spinning, DAM, Aqua-X, Shad, Pilk, MF, 2.70m,, 50-150g,, 2seg, dam.66270, Lansete Rapitori, Lansete Rapitori DAM, DAM

Lanseta, Spinning, DAM, Aqua-X, Shad, Pilk, MF, 2.70m,, 50-150g,, 2seg, dam.66270, Lansete Rapitori, Lansete Rapitori DAM, DAM

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

Mulineta DAM QUICK FUN-TECH 3 MK1 1000 FD

dam.72974

Livrare imediată!

124,13Lei

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, dam.73010, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M

Mulineta, DAM, Quick, Fahrenheit, 6, 5000, S, FD,, 0.33mm-230m,, 5.1:1,, 5+1BB, dam.73010, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M

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 Trout 0.18mm 500m

Fir DAM Damyl New Spezi Line Trout 0.18mm 500m

11070966629

Livrare imediată!

24,24Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 1127 (57 pagini)

Queries: 9, Total time: 86.006 ms [By time] [By id] [By file]

1 (0.104)

SELECT data
FROM `oc_session`
WHERE session_id = 'a92fad85c1aa2087aa68cbf900'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.104)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.099)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (0.133)

SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

5 (0.130)

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 (37.608)

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 (47.620)

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 0,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438

8 (0.101)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.107)

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