DAM


Cosulet, Naditor, DAM, Detek, Maggot, Feeder, Inline, 20gr, a.dam.66034, Pellet Feeder Maggot Feeder, Pellet Feeder Maggot Feeder DAM, Pellet DAM, Feeder DAM, Maggot DAM, Feeder DAM, DAM -30%
Mulineta, DAM, Quick, 1, Pink, FD3000, dam.75952, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, D.A.M
Lanseta DAM Base-X Allround 2.40m 30-60g

Lanseta DAM Base-X Allround 2.40m 30-60g

2040970371
Livrare 48-72 ore

112,50Lei

Avertizor Electronic DAM Madcat Topcat Red

Avertizor Electronic DAM Madcat Topcat Red

a.mad.707630001
Livrare imediată!

380,25Lei

Mulineta DAM QUICK IMPULSE 3L 2500

Mulineta DAM QUICK IMPULSE 3L 2500

dam.72971
Livrare imediată!

102,07Lei

Momitor, Method, Feeder, DAM, Detek, Inline,, Marime, L,, 80g,, 1buc/pac, a.dam.66021, Momitoare Method Feeder, Momitoare Method Feeder DAM, Momitoare DAM, Method DAM, Feeder DAM, DAM
Mulineta DAM QUICK IMPULSE 4QF 4000S

Mulineta DAM QUICK IMPULSE 4QF 4000S

dam.73000
Livrare imediată!

183,86Lei

Forceps, DAM, Madcat, Unhooking, Pliers, 28, cm, a.mad.70790, Clesti Patenti Pense, Clesti Patenti Pense D.A.M, Clesti D.A.M, Patenti D.A.M, Pense D.A.M, D.A.M
Lanseta DAM Base-X Carp MF 3.60m, 3.0lb, 40mm, 2seg

Lanseta DAM Base-X Carp MF 3.60m, 3.0lb, 40mm, 2seg

dam.70383
Livrare imediată!

159,46Lei

Mulineta, DAM, Quick, Fahrenheit, 6, 2500, S, FD,, 0.22mm-190m,, 5.2:1,, 5+1BB, dam.73007, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M
Varga Dam Tele Base-X, 6m

Varga Dam Tele Base-X, 6m

dam.71044
Livrare imediată!

91,11Lei

Mulineta, DAM, Feeder, Quick, 1, 4000FD, 3054673201, Mulinete Feeder, Mulinete Feeder DAM, Mulinete DAM, Feeder DAM, DAM
Lanseta, DAM, Imax, Boat, 2.10m, XH, 150-450gr, , 2030970604, Lansete Pescuit din Barca, Lansete Pescuit din Barca DAM, 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 -27%

Lanseta DAM Madcat White Spin 2.85m 175gr

2033156876
Livrare imediată!

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

Mulineta, DAM, RUNSHIFT, 4, 5000S, BF, dam.73045, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M
Struna DAM Kink Free Titanium 30cm, 15kig, 2buc/pac

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

a7.dam.56401
Livrare 24-48 ore

31,01Lei

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 41

Cizme DAM Flex Cauciuc Neopren 3mm, Marime 41

a8.dam.8739241
Livrare 24-48 ore

358,87Lei

Mulineta DAM Quick 2 Feeder 4000, 0.22mm-240m, 5.2:1, 5+1BB -20%

Mulineta DAM Quick 2 Feeder 4000, 0.22mm-240m, 5.2:1, 5+1BB

dam.75984
Livrare 24-48 ore

204,14Lei(-20%) 163,32Lei

Afişare 1 - 20 din 1127 (57 pagini)
Queries: 9, Total time: 86.105 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '2a5f163db1069e567de05b16e5'
/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.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.093)
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.116)
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 (49.268)
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.150)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.126)
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