DAM


Varga Dam Tele Base-X, 5m

Varga Dam Tele Base-X, 5m

svs71043
Livrare imediată!

74,21Lei

Lanseta DAM Yagi V2 Spin MH, 15-53g, 2.44m, 2seg

Lanseta DAM Yagi V2 Spin MH, 15-53g, 2.44m, 2seg

1619292
Livrare 7-14 zile

241,98Lei

Lanseta DAM Rod Impulse-X Quiver 10FT, 10-40g, 3.00m, 2+3seg

Lanseta DAM Rod Impulse-X Quiver 10FT, 10-40g, 3.00m, 2+3seg

1619255
Livrare 7-14 zile

250,12Lei

Lanseta DAM XT1 Carp Rod, 3.5lbs, 3.60m, 2seg

Lanseta DAM XT1 Carp Rod, 3.5lbs, 3.60m, 2seg

svs70889
Livrare imediată!

299,93Lei

Lanseta DAM XT1 Carp Rod, 3.25lbs, 3.60m, 3seg

Lanseta DAM XT1 Carp Rod, 3.25lbs, 3.60m, 3seg

svs70887
Livrare 7-14 zile

312,14Lei

Vartej Rapid DAM Detek Quick Change Swivel Nr.12

Vartej Rapid DAM Detek Quick Change Swivel Nr.12

4030466003
Livrare imediată!

18,83Lei

Lanseta Dam Madcat White Deluxe G2 3.20m, 350g, 2seg -28%

Lanseta Dam Madcat White Deluxe G2 3.20m, 350g, 2seg

2033151834
Livrare imediată!

745,02Lei(-28%) 538,86Lei

Mulineta DAM QUICK FUN-TECH 3 MK1 1000 FD

Mulineta DAM QUICK FUN-TECH 3 MK1 1000 FD

dam.72974
Livrare imediată!

127,22Lei

Momitor Method Feeder DAM Detek Inline, Marime S, 25g, 1buc/pac -21%

Momitor Method Feeder DAM Detek Inline, Marime S, 25g, 1buc/pac

a.dam.66017
Livrare 24-48 ore

12,73Lei(-21%) 10,06Lei

Set Varfuri DAM Impulse-X Feeder Tips Kit1, 10-75g, 3buc/pac

Set Varfuri DAM Impulse-X Feeder Tips Kit1, 10-75g, 3buc/pac

1625227
Livrare 7-14 zile

87,43Lei

Mulineta DAM Runshift 3 6000 FS Carp Reel

Mulineta DAM Runshift 3 6000 FS Carp Reel

svs73034
Livrare imediată!

142,34Lei

Salopeta DAM Hydroforce Nylon Taslan, Marime 42-43

Salopeta DAM Hydroforce Nylon Taslan, Marime 42-43

a8.dam.8713042
Livrare 24-48 ore

300,73Lei

Lanseta Telescopica DAM Shadow Tele Rod, 5-25g, 3.60m, 6seg

Lanseta Telescopica DAM Shadow Tele Rod, 5-25g, 3.60m, 6seg

svs70361
Livrare 7-14 zile

287,74Lei

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

4200466039
Livrare imediată!

27,78Lei

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

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

2040970616
Livrare imediată!

233,08Lei(-25%) 174,77Lei

Mulineta DAM Quick Darkside 4QF FD 6000S

Mulineta DAM Quick Darkside 4QF FD 6000S

svs73059
Livrare imediată!

221,65Lei

Fir Monofilament Damyl Spezi Line Coarse Transparent, 0.12mm, 1.4kg, 500m

Fir Monofilament Damyl Spezi Line Coarse Transparent, 0.12mm, 1.4kg, 500m

a.dam.66640
Livrare imediată!

18,63Lei

Mulineta DAM RUNSHIFT 4 5000S BF

Mulineta DAM RUNSHIFT 4 5000S BF

svs73045
Livrare imediată!

167,75Lei

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

svs66275
Livrare imediată!

163,69Lei

Mulineta DAM Quick Dynabraid 4 3000S FD 0.25mm/205m, 5.2:1, 3+1BB + Fir Textil

Mulineta DAM Quick Dynabraid 4 3000S FD 0.25mm/205m, 5.2:1, 3+1BB + Fir Textil

svs73002
Livrare 7-14 zile

200,29Lei

Afişare 41 - 60 din 866 (44 pagini)
Queries: 7, Total time: 84.225 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = '379df76cbc434368a8ce444bc5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.114)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
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
5 (39.341)
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:1699
6 (44.336)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.137)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37