DAM


Mulineta DAM Nova FD 7000 + Fir Monofilament, 0.40mm-337m, 4.1:1, 1BB

Mulineta DAM Nova FD 7000 + Fir Monofilament, 0.40mm-337m, 4.1:1, 1BB

dam.75960
Livrare 24-48 ore

112,46Lei

Lanseta, DAM, Yagi, Spin, F,, 2.20m,, 42-120g,, 2seg, dam.60044, Lansete Rapitori, Lansete Rapitori DAM, DAM
Mulineta, DAM, Shadow, 7, 8000, SLS, BF/, 0.35MM-550M,, 4.1:1,, 6+1BB, dam.73057, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M -30%
Lanseta, DAM, Madcat, Green, Vertical, 1.80m,, 150-250g,, 1seg, mad.1604084, Lansete Somn, Lansete Somn DAM, Lansete 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

Lanseta DAM Salt-X SW Spin 2.20m 7-30gr -29%

Lanseta DAM Salt-X SW Spin 2.20m 7-30gr

2040965742
Livrare imediată!

275,73Lei(-29%) 195,77Lei

Lanseta, DAM, Imax, Nova, Hard, Core, Downrigger, 2.10m, 12-25lb, 2030975549, Lansete Pescuit din Barca, Lansete Pescuit din Barca DAM, DAM
Momitor, DAM, Detek, Groundbait, Feedee, Inline, 15g, a.dam.66040, Cosulete Feeder, Cosulete Feeder DAM, Cosulete DAM, Feeder DAM, DAM -30%
Mulineta DAM Quick Darkside 8 FD 5000s

Mulineta DAM Quick Darkside 8 FD 5000s

dam.73028
Livrare imediată!

321,68Lei

Lanseta, DAM, Imax, Boat, Quiver, 2.10m,, 250g,, 2+2seg, dam.70634, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM
Lanseta, DAM, Yagi, Classic, Spin, F,, 2.10m,, 10-30g,, 2seg, dam.65915, Lansete Rapitori, Lansete Rapitori DAM, DAM
Mulineta DAM Quick Finessa 8 5000S FD, 0.33mm-230m, 5.1:1, 7+1BB

Mulineta DAM Quick Finessa 8 5000S FD, 0.33mm-230m, 5.1:1, 7+1BB

dam.73021
Livrare 24-48 ore

281,07Lei

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

Kit DAM Detek Method Feeder 2+1 L

Kit DAM Detek Method Feeder 2+1 L

4190466024
Livrare imediată!

61,01Lei

Mulineta, DAM, Quick, 2, 2000, FD, V2, dam.75978, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M -20%
Fir Monofilament Damyl Spezi Line Salau Light Brown, 0.28mm, 6.7kg, 450m

Fir Monofilament Damyl Spezi Line Salau Light Brown, 0.28mm, 6.7kg, 450m

a.dam.66634
Livrare imediată!

20,83Lei

Avertizor Electronic Multicolor DAM Madcat Smart MCL Nonwireless

Avertizor Electronic Multicolor DAM Madcat Smart MCL Nonwireless

a.mad.70843
Livrare imediată!

256,30Lei

Mulineta DAM QUICK FUN-TECH 3 MK1 4000 FD

Mulineta DAM QUICK FUN-TECH 3 MK1 4000 FD

dam.72978
Livrare imediată!

137,83Lei

Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.70mm, 36.2kg/80lb, 100m

Fir Monofilament Inaintas DAM Tectan Soft Leader Transparent, 0.70mm, 36.2kg/80lb, 100m

a.dam.66200
Livrare 24-48 ore

32,80Lei

Afişare 101 - 120 din 1121 (57 pagini)
Queries: 7, Total time: 90.394 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '9388c5a34145aeb8027100aeb2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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
5 (39.505)
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:1667
6 (50.237)
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 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.150)
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