Daiwa


Lanseta DAIWA Ninja X Spin, 10-30g, 2.10m, 2seg

Lanseta DAIWA Ninja X Spin, 10-30g, 2.10m, 2seg

d.11204.211
Livrare imediată!

208,45Lei

VARTEJ DAIWA N ZON CU OPRITOR L

VARTEJ DAIWA N ZON CU OPRITOR L

a7.13317.010
Livrare 24-48 ore

12,92Lei

VARF DAIWA PENTRU N ZON CARBON HEAVY 80-180G WHITE 1OZ -28%

VARF DAIWA PENTRU N ZON CARBON HEAVY 80-180G WHITE 1OZ

d.11138.010
Livrare imediată!

130,23Lei(-28%) 93,69Lei

MULINETA DAIWA FUEGO LT 3000-CXH 6RUL 150MX023

MULINETA DAIWA FUEGO LT 3000-CXH 6RUL 150MX023

d.10223.301
Livrare 24-48 ore

428,22Lei

Lanseta Daiwa Crosscast Extention Carp 2.74m 2.75lbs 2seg -18%

Lanseta Daiwa Crosscast Extention Carp 2.74m 2.75lbs 2seg

d.11560.278
Livrare imediată!

383,75Lei(-18%) 313,16Lei

POP-UP DAIWA ADVANTAGE ORANGE 6/8MM 18G

POP-UP DAIWA ADVANTAGE ORANGE 6/8MM 18G

a0.13300.300
Livrare 24-48 ore

34,80Lei

CAP MINCIOG DAIWA N ZON NANO MESH 55CM

CAP MINCIOG DAIWA N ZON NANO MESH 55CM

a2.m13415.055
Livrare imediată!

78,09Lei

Fir monofilament Daiwa Shorecast Red 0.35mm 10.1kg 840m

Fir monofilament Daiwa Shorecast Red 0.35mm 10.1kg 840m

d.shc35r
Livrare imediată!

82,61Lei

MINCIOG DAIWA PROREX 55X45CM

MINCIOG DAIWA PROREX 55X45CM

a2.m15809.745
Livrare 24-48 ore

342,21Lei

LANSETA DAIWA BLACK WIDOW FEEDER 2.70M 80G 3+2seg

LANSETA DAIWA BLACK WIDOW FEEDER 2.70M 80G 3+2seg

d.11789.275
Livrare 24-48 ore

260,00Lei

Fir Fluorocarbon Daiwa J, 0.45mm, 11.8kg, 50m

Fir Fluorocarbon Daiwa J, 0.45mm, 11.8kg, 50m

d.12220.045
Livrare imediată!

57,55Lei

Ochelari Polarizati Daiwa Clip L, Lentila Galbena

Ochelari Polarizati Daiwa Clip L, Lentila Galbena

d.df808y
Livrare 24-48 ore

56,17Lei

Mulineta Daiwa Freams LT 2000D 0.20mm/150m, 5.3:1, 5rul -8%

Mulineta Daiwa Freams LT 2000D 0.20mm/150m, 5.3:1, 5rul

d.10229.201
Livrare 24-48 ore

752,90Lei(-8%) 690,00Lei

Husa Lanseta cu Mulineta Daiwa Prorex, 2 Posturi, 145cm

Husa Lanseta cu Mulineta Daiwa Prorex, 2 Posturi, 145cm

d.15813.270
Livrare imediată!

147,54Lei

Lanseta Spinning Daiwa Tournament XT 2.35m, 14-42g, 2seg

Lanseta Spinning Daiwa Tournament XT 2.35m, 14-42g, 2seg

d.11128.236
Livrare imediată!

2.102,41Lei

Cutie pentru Momeala Daiwa D-Box SS Smoke, 21.7x16.4x4.8cm

Cutie pentru Momeala Daiwa D-Box SS Smoke, 21.7x16.4x4.8cm

d.14310.005
Livrare 24-48 ore

35,30Lei

SHAD DAIWA D.FIN 7,5CM GREEN PEARL/10BUC

SHAD DAIWA D.FIN 7,5CM GREEN PEARL/10BUC

d.16500.108
Livrare imediată!

30,60Lei

AGRAFA DAIWA TOURNAMENT W-SNAP S 10BUC/PL

AGRAFA DAIWA TOURNAMENT W-SNAP S 10BUC/PL

d.16512.200
Livrare imediată!

25,49Lei

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.18MM 12,0KG 150M

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.18MM 12,0KG 150M

d.12751.018
Livrare 24-48 ore

66,42Lei

FIR DAIWA PROREX FC LEADER 0.33MM/7.4KG/50M

FIR DAIWA PROREX FC LEADER 0.33MM/7.4KG/50M

d.12995.033
Livrare 24-48 ore

29,02Lei

Afişare 1301 - 1320 din 1662 (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: 218.323 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = 'ce375975836972bf4d6652f4c2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.111)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
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 (123.562)
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 (94.177)
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 1300,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.152)
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