Daiwa


Mulineta Daiwa Legalis LT5000-C(U), 0.37mm/150m, 5.2:1, 5rul

Mulineta Daiwa Legalis LT5000-C(U), 0.37mm/150m, 5.2:1, 5rul

d.10435.500
Livrare 24-48 ore

492,51Lei

Lanseta Spinning Daiwa Crossfire 180ML 1.80m, 5-14g, 2seg

Lanseta Spinning Daiwa Crossfire 180ML 1.80m, 5-14g, 2seg

d.cf180mlaf
Livrare 24-48 ore

174,09Lei

Lanseta Spinning Daiwa Morethan Shad Attack Ultra Fast, 2.40m, 14-56g, 2seg

Lanseta Spinning Daiwa Morethan Shad Attack Ultra Fast, 2.40m, 14-56g, 2seg

d.11116.241
Livrare 24-48 ore

1.860,64Lei

Fir Textil DAIWA J-Braid Expedition X8 PE 0.13mm, 8.40kg, 150m, Orange

Fir Textil DAIWA J-Braid Expedition X8 PE 0.13mm, 8.40kg, 150m, Orange

d.12550.013
Livrare imediată!

82,11Lei

Plumb Daiwa N Zone Bomb Inline, 20g, 2buc/pac

Plumb Daiwa N Zone Bomb Inline, 20g, 2buc/pac

a.13361.020
Livrare 24-48 ore

26,40Lei

Mulineta DAIWA 21 Presso LT 2000SS-P, 4.9:1, 0.12mm/100m, 12rul

Mulineta DAIWA 21 Presso LT 2000SS-P, 4.9:1, 0.12mm/100m, 12rul

d.00060381
Livrare 24-48 ore

2.096,80Lei

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

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

f3.d15263.412
Livrare 24-48 ore

46,34Lei

Shad DAIWA Prorex Belly, White Ghost, 8.5cm, 4g, 4buc/pac

Shad DAIWA Prorex Belly, White Ghost, 8.5cm, 4g, 4buc/pac

d.15320.207
Livrare 24-48 ore

28,89Lei

Lanseta DAIWA N Zone XL Distance Feeder, 150g, 3.30m, 3+2seg

Lanseta DAIWA N Zone XL Distance Feeder, 150g, 3.30m, 3+2seg

d.11332.330
Livrare 24-48 ore

448,18Lei

Mulineta Daiwa 23 Ninja LT 2000, 5.2:1, 0.16mm/150m, 4rul -8%

Mulineta Daiwa 23 Ninja LT 2000, 5.2:1, 0.16mm/150m, 4rul

d.10005.200
Livrare imediată!

352,76Lei(-8%) 323,82Lei

Fir Monofilament DAIWA Bass-X Nylon, Brown, 300m, 0.37mm, 20lbs/9.07kg

Fir Monofilament DAIWA Bass-X Nylon, Brown, 300m, 0.37mm, 20lbs/9.07kg

d.bsxny20lb300
Livrare 24-48 ore

33,96Lei

DAIWA FEEDER N ZON OPEN END M 40G

DAIWA FEEDER N ZON OPEN END M 40G

a.13351.040
Livrare imediată!

16,58Lei

Bluza DAIWA D Old Shirt Long Sleeve 30, Light Gray, Marime L

Bluza DAIWA D Old Shirt Long Sleeve 30, Light Gray, Marime L

d.21lshirt30lgl
Livrare 24-48 ore

147,18Lei

Momitor Feeder Daiwa Feeder N Zon M 20g

Momitor Feeder Daiwa Feeder N Zon M 20g

a.13321.020
Livrare imediată!

14,36Lei

Lanseta Spinning DAIWA Ninja SP 704 MHFSE 2.13m, 7-28g, 4seg

Lanseta Spinning DAIWA Ninja SP 704 MHFSE 2.13m, 7-28g, 4seg

d.njsp704mhfsecf
Livrare 24-48 ore

247,41Lei

Fir DAIWA Tournament SF, Grey, 300m, 0.18mm, 2.9kg

Fir DAIWA Tournament SF, Grey, 300m, 0.18mm, 2.9kg

d.12205.318
Livrare imediată!

30,17Lei

Vobler DAIWA Silver Creek Minnow 44S, Keimura Ayu, 4.4cm, 4.2g

Vobler DAIWA Silver Creek Minnow 44S, Keimura Ayu, 4.4cm, 4.2g

f3.scm44skay
Livrare 24-48 ore

54,73Lei

MULINETA DAIWA CROSSCAST 35 SCW 5000LD QD 3RUL -8%

MULINETA DAIWA CROSSCAST 35 SCW 5000LD QD 3RUL

d.10128.609
Livrare imediată!

611,59Lei(-8%) 560,69Lei

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

d.18850.200
Livrare imediată!

395,36Lei

JIG DAIWA PROREX COVER JIG TG 8G ZARIGANI

JIG DAIWA PROREX COVER JIG TG 8G ZARIGANI

f2.15429.108
Livrare 24-48 ore

22,54Lei

Afişare 1 - 20 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: 115.297 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = 'aa94efcb26337d4a10f4dbad57'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.101)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.096)
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 (41.038)
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 (73.788)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.110)
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