Daiwa


Mulineta Daiwa Emblem 45 SCW QD 2024 -27%

Mulineta Daiwa Emblem 45 SCW QD 2024

d.10158.800
Livrare imediată!

1.181,44Lei(-27%) 865,90Lei

Mulineta Daiwa Legalis LT2500(U), 0.20mm/150m, 5.3:1, 5rul

Mulineta Daiwa Legalis LT2500(U), 0.20mm/150m, 5.3:1, 5rul

d.10435.251
Livrare 24-48 ore

471,21Lei

Lanseta Spinning Daiwa Preso Trout Spin 1.90m, 0.5-5g, 2seg

Lanseta Spinning Daiwa Preso Trout Spin 1.90m, 0.5-5g, 2seg

d.11718.190
Livrare 24-48 ore

608,67Lei

Mulineta Daiwa 23 Super Spod 45 SCW QD-OT

Mulineta Daiwa 23 Super Spod 45 SCW QD-OT

d.10158.505
Livrare 24-48 ore

964,98Lei

Cosulet Daiwa Nzon Window Feeder L, 45g, 1buc/pac

Cosulet Daiwa Nzon Window Feeder L, 45g, 1buc/pac

a3.13357.045
Livrare 24-48 ore

19,07Lei

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

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

f3.d15263.405
Livrare 24-48 ore

46,34Lei

Shad DAIWA Prorex Belly, Ghost Firetiger, 6cm, 2g, 4buc/pac

Shad DAIWA Prorex Belly, Ghost Firetiger, 6cm, 2g, 4buc/pac

d.15320.114
Livrare 24-48 ore

31,99Lei

Lanseta Bolognesa DAIWA Ninja Tele Bolo, 25g, 4.00m, 4seg

Lanseta Bolognesa DAIWA Ninja Tele Bolo, 25g, 4.00m, 4seg

d.11628.400
Livrare 24-48 ore

227,30Lei

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.33mm, 9kg

Fir Monofilament DAIWA Tournament SF, Grey, 3000m, 0.33mm, 9kg

d.12205.633
Livrare imediată!

193,15Lei

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

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

d.21lshirt30dg3xl
Livrare 24-48 ore

147,18Lei

Lanseta Spinning DAIWA Ninja SP 702 MHFSE 2.13m, 7-28g, 2seg

Lanseta Spinning DAIWA Ninja SP 702 MHFSE 2.13m, 7-28g, 2seg

d.njsp702mhfsecf
Livrare 24-48 ore

224,85Lei

Fir DAIWA Justron DPLS Yellow, 500m, 0.285mm, 5.5kg/12.12lbs

Fir DAIWA Justron DPLS Yellow, 500m, 0.285mm, 5.5kg/12.12lbs

d.07300461
Livrare 24-48 ore

53,72Lei

VARF DAIWA PENTRU NINJA X METHOD FEEDER GREEN 80g

VARF DAIWA PENTRU NINJA X METHOD FEEDER GREEN 80g

d.11603.000g
Livrare imediată!

40,16Lei

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G FIRETIGER

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G FIRETIGER

f3.d16711.206
Livrare imediată!

74,72Lei

LINGURITA DAIWA ROTATIVA 4G GOLD METAL -14%

LINGURITA DAIWA ROTATIVA 4G GOLD METAL

d.07411554
Livrare 24-48 ore

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

Mulineta Daiwa Silver Creek LT 2500S XH

Mulineta Daiwa Silver Creek LT 2500S XH

d.sclt2500sxh
Livrare 24-48 ore

1.401,24Lei

TRICOU DAIWA CARP CAMO XL

TRICOU DAIWA CARP CAMO XL

d.18865.040
Livrare imediată!

116,16Lei

Vobler Daiwa TN Mega Scounter Chart Back Pearl, 6.8cm, 14g

Vobler Daiwa TN Mega Scounter Chart Back Pearl, 6.8cm, 14g

f3.d16710.001
Livrare 24-48 ore

70,28Lei

Lanseta Spinning Daiwa Tele Sweepfire 2.40m, 10-30g, 6seg

Lanseta Spinning Daiwa Tele Sweepfire 2.40m, 10-30g, 6seg

d.11421.241
Livrare 24-48 ore

184,86Lei

Afişare 181 - 200 din 1665 (84 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 111.020 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '22fd07cc68370af6c1f4763545'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.065)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.084)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.087)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (39.472)
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 = '2' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (71.091)
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 = '2' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.138)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37