Daiwa


Lanseta Daiwa N'Zon Distance Special X Power Feeder 3.96m, 180g, 3+3seg -8%

Lanseta Daiwa N'Zon Distance Special X Power Feeder 3.96m, 180g, 3+3seg

d.11173.390
Livrare imediată!

1.330,62Lei(-8%) 1.221,16Lei

Lanseta Spinning Daiwa Preso IPRIMI 1.95m, 1-7g, 2seg

Lanseta Spinning Daiwa Preso IPRIMI 1.95m, 1-7g, 2seg

d.11719.196
Livrare 24-48 ore

400,76Lei

Mulineta DAIWA 23 Revros LT 1000, 0.14mm/150m, 5.2:1, 4rul -10%

Mulineta DAIWA 23 Revros LT 1000, 0.14mm/150m, 5.2:1, 4rul

d.10221.102
Livrare imediată!

325,96Lei(-10%) 294,36Lei

Cosulet Daiwa Nzon Window Feeder M, 60g, 1buc/pac

Cosulet Daiwa Nzon Window Feeder M, 60g, 1buc/pac

a3.13356.060
Livrare 24-48 ore

20,12Lei

Lanseta DAIWA Black Widow XT Stalker Carp 3.60m, 365g / 3.5lbs, 2seg -8%

Lanseta DAIWA Black Widow XT Stalker Carp 3.60m, 365g / 3.5lbs, 2seg

d.11583.365
Livrare imediată!

302,78Lei(-8%) 278,08Lei

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Gya, 4.1cm, 6.5g, 1buc/pac

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Gya, 4.1cm, 6.5g, 1buc/pac

f3.d15263.401
Livrare 24-48 ore

46,34Lei

Shad DAIWA Prorex Belly, Chartreuse Shocker, 6cm, 2g, 4buc/pac

Shad DAIWA Prorex Belly, Chartreuse Shocker, 6cm, 2g, 4buc/pac

d.15320.110
Livrare 24-48 ore

25,62Lei

Lanseta Bolognesa DAIWA Ninja Tele Bolo, 25g, 5.00m, 5seg

Lanseta Bolognesa DAIWA Ninja Tele Bolo, 25g, 5.00m, 5seg

d.11628.500
Livrare 24-48 ore

270,22Lei

Mulineta DAIWA 24 N Zon Plus LT6000SS-CP 5RUL/150MX028M/4.9:1

Mulineta DAIWA 24 N Zon Plus LT6000SS-CP 5RUL/150MX028M/4.9:1

d.10317.600
Livrare 24-48 ore

1.224,08Lei

Fir Monofilament DAIWA Tournament SF, Grey, 3000m, 0.36mm, 11.1kg

Fir Monofilament DAIWA Tournament SF, Grey, 3000m, 0.36mm, 11.1kg

d.12205.636
Livrare imediată!

225,53Lei

MULINETA DAIWA N ZON PLUS LT 5000S-CP -21%

MULINETA DAIWA N ZON PLUS LT 5000S-CP

d.10311.500
Livrare 24-48 ore

987,44Lei(-21%) 783,17Lei

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime 2XL

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime 2XL

d.21lshirt30dg2xl
Livrare 24-48 ore

147,18Lei

Lanseta Spinning DAIWA Prorex E Casting 662 MHFB 1.98m, 7-28g, 2seg

Lanseta Spinning DAIWA Prorex E Casting 662 MHFB 1.98m, 7-28g, 2seg

d.pxe662mhfbbf
Livrare 24-48 ore

441,44Lei

Mulineta DAIWA 25 RZ 1000 Spinning 3Rul, 0,06mm-250m, 5.1:1

Mulineta DAIWA 25 RZ 1000 Spinning 3Rul, 0,06mm-250m, 5.1:1

d.25rz1000
Livrare 24-48 ore

225,11Lei

Fir Monofilament DAIWA Tournament SF, Grey, 300m, 0.23mm, 4.5kg

Fir Monofilament DAIWA Tournament SF, Grey, 300m, 0.23mm, 4.5kg

d.12205.323
Livrare imediată!

31,90Lei

LINGURITA DAIWA ROTATIVA 3G SILVER GREEN -14%

LINGURITA DAIWA ROTATIVA 3G SILVER GREEN

d.07410884
Livrare 24-48 ore

23,66Lei(-14%) 20,24Lei

TAMBUR DAIWA UNIVERSAL MULINETA LT 5000D -40%

TAMBUR DAIWA UNIVERSAL MULINETA LT 5000D

d.19115.500
Livrare imediată!

127,20Lei(-40%) 76,44Lei

Lanseta Spinning Daiwa Sweepfire Spin 2.10m, 5-25g, 2seg

Lanseta Spinning Daiwa Sweepfire Spin 2.10m, 5-25g, 2seg

d.11446.210
Livrare imediată!

158,84Lei

Mulineta Daiwa Emblem BR 10000 25A 0.32mm/320m, 5.3:1, 6rul -19%

Mulineta Daiwa Emblem BR 10000 25A 0.32mm/320m, 5.3:1, 6rul

d.10158.100
Livrare 24-48 ore

1.095,13Lei(-19%) 891,83Lei

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.66m, 240g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.66m, 240g, 3+2seg

d.11165.360
Livrare imediată!

535,82Lei

Afişare 101 - 120 din 1583 (80 pagini)
Queries: 7, Total time: 119.906 ms [By time] [By id] [By file]
1 (0.187)
SELECT data
FROM `oc_session`
WHERE session_id = 'ac5ab48dedf708ecab2d598b10'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.105)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.100)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '11' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (56.331)
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 = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (62.935)
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 = '0' AND p.manufacturer_id = '11' 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:440
7 (0.156)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37