DAM


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

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

dam.70395
Livrare 24-48 ore

159,25Lei

Lanseta DAM Yagi Classic Spin MF, 2.40m, 3-12g, 2seg

Lanseta DAM Yagi Classic Spin MF, 2.40m, 3-12g, 2seg

dam.65931
Livrare 24-48 ore

274,24Lei

Mulineta DAM Runshift 3 6000 BF, 0.35mm-295mm, 5.1:1, 2+1BB

Mulineta DAM Runshift 3 6000 BF, 0.35mm-295mm, 5.1:1, 2+1BB

dam.73034
Livrare imediată!

152,03Lei

Lanseta, DAM, Madcat, White, Belly, Cat,, 1.80m,, 60-150g,, 2seg, mad.1603777, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM
Fir DAM Damyl New Spezi Line Feeder 5.60kg 0.25mm 500m

Fir DAM Damyl New Spezi Line Feeder 5.60kg 0.25mm 500m

11070966639
Livrare imediată!

24,24Lei

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

dam.70890
Livrare imediată!

351,50Lei

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

11020966575
Livrare 48-72 ore

46,68Lei

Mulineta, DAM, Quick, 4, Trent, Centrepin, dam.75953, Mulinete Musca, Mulinete Musca D.A.M, Mulinete D.A.M, Musca D.A.M, D.A.M
Lanseta DAM Base-X Allround 2.70m 30-60g

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

2040970372
Livrare imediată!

121,21Lei

Avertizor Electronic DAM Madcat Topcat Green

Avertizor Electronic DAM Madcat Topcat Green

a.mad.707630002
Livrare imediată!

380,25Lei

Mulineta, DAM, QUICK, IMPULSE, 3L, 3000, dam.72972, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M
Momitor DAM Detek Pellet Feeder Inline 15g -30%

Momitor DAM Detek Pellet Feeder Inline 15g

a.dam.66031
Livrare 24-48 ore

15,98Lei(-30%) 11,17Lei

Penar pentru Documente DAM Intenze Neopren 22x15x5cm -20%

Penar pentru Documente DAM Intenze Neopren 22x15x5cm

a8.dam.60339
Livrare 24-48 ore

45,43Lei(-20%) 36,34Lei

Lanseta DAM Base-X Carp MF 3.90m, 3.5lb, 40mm, 2seg

Lanseta DAM Base-X Carp MF 3.90m, 3.5lb, 40mm, 2seg

dam.70384
Livrare 24-48 ore

173,15Lei

Mulineta, DAM, Quick, Fahrenheit, 6, 3000, S, FD,, 0.25mm-205m,, 5.2:1,, 5+1BB, dam.73008, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M
Varga Dam Tele Base-X, 7m

Varga Dam Tele Base-X, 7m

dam.71045
Livrare imediată!

118,48Lei

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

a.dam.66626
Livrare imediată!

20,83Lei

Momitor DAM Detek Pellet Feeder Inline 25g -30%

Momitor DAM Detek Pellet Feeder Inline 25g

a.dam.66032
Livrare 24-48 ore

17,15Lei(-30%) 12,00Lei

Mulineta DAM Feeder Quick 2 4000FD

Mulineta DAM Feeder Quick 2 4000FD

3054673200
Livrare imediată!

173,95Lei

Lanseta DAM Imax SW Spin 2.15m ML 5-25gr -27%

Lanseta DAM Imax SW Spin 2.15m ML 5-25gr

2040970615
Livrare imediată!

230,04Lei(-27%) 167,99Lei

Afişare 161 - 180 din 1127 (57 pagini)
Queries: 9, Total time: 86.490 ms [By time] [By id] [By file]
1 (0.167)
SELECT data
FROM `oc_session`
WHERE session_id = 'b72e792979dddab01c7acc01df'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.134)
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 (35.376)
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 (50.257)
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 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.123)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.090)
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