Daiwa


SAPCA DAIWA CARP KAKI

SAPCA DAIWA CARP KAKI

d.ca258647
Livrare imediată!

47,46Lei

HUSA DAIWA NEOPREN PT. MULINETA BAITCAST 12X12,5CM

HUSA DAIWA NEOPREN PT. MULINETA BAITCAST 12X12,5CM

a8.15802.025
Livrare imediată!

44,41Lei

Lanseta DAIWA Fuego Predator Spin Fast 2.40m, 15-50g, 2seg

Lanseta DAIWA Fuego Predator Spin Fast 2.40m, 15-50g, 2seg

d.11124.241
Livrare 24-48 ore

317,40Lei

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC FIRETIGER

SHAD DAIWA PROREX DUCK FIN 4.5CM 8BUC/PLIC FIRETIGER

d.15604.804
Livrare imediată!

42,91Lei

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.18mm 12.50kg

Fir Textil Daiwa J-Braid Grand X8 Albastru 135m 0.18mm 12.50kg

d.12796.018
Livrare 24-48 ore

57,18Lei

Muste DAIWA Fly Pack Modern Traditional Flies, 12buc/pac

Muste DAIWA Fly Pack Modern Traditional Flies, 12buc/pac

f3.dfc2
Livrare 24-48 ore

72,72Lei

STRUNA DAIWA PROREX TITAN 20CM 12KG

STRUNA DAIWA PROREX TITAN 20CM 12KG

a7.17925.712
Livrare 24-48 ore

18,68Lei

DAIWA GEANTA UMAR STREET BLACK GOLD 35X38X12CM -39%

DAIWA GEANTA UMAR STREET BLACK GOLD 35X38X12CM

d.msbg
Livrare 24-48 ore

233,09Lei(-39%) 143,22Lei

Agrafa cu Vartej DAIWA Emerillons a Agrafe Snap Swivel Nr.10, 8kg, 20buc/pac

Agrafa cu Vartej DAIWA Emerillons a Agrafe Snap Swivel Nr.10, 8kg, 20buc/pac

a7.em258098
Livrare 24-48 ore

12,52Lei

Geanta Feeder Daiwa N Zon 4 38x26x31cm

Geanta Feeder Daiwa N Zon 4 38x26x31cm

d.13305.010
Livrare 24-48 ore

500,00Lei

Lanseta Daiwa N Zone Feeder 3.90m 100g 3+2seg -11%

Lanseta Daiwa N Zone Feeder 3.90m 100g 3+2seg

d.11131.395
Livrare imediată!

434,04Lei(-11%) 386,81Lei

SHAD DAIWA TOURNAMENT D.FIN 7.5CM FP 10BUC/PLIC -19%

SHAD DAIWA TOURNAMENT D.FIN 7.5CM FP 10BUC/PLIC

d.16502.808
Livrare imediată!

31,62Lei(-19%) 25,72Lei

GEANTA DAIWA N ZON FEEDER TACKLE M 30X20X25CM

GEANTA DAIWA N ZON FEEDER TACKLE M 30X20X25CM

d.13405.050
Livrare imediată!

255,52Lei

Croseta Daiwa N Zon

Croseta Daiwa N Zon

a.13319.002
Livrare imediată!

8,97Lei

Lanseta Daiwa N Zone Distance Feeder 3.66m 150g 3+2seg

Lanseta Daiwa N Zone Distance Feeder 3.66m 150g 3+2seg

d.11332.366
Livrare imediată!

451,05Lei

FIR MONOFILAMENT DAIWA TOURNAMENT NYLON RED 1200M 0.28MM 6.6KG

FIR MONOFILAMENT DAIWA TOURNAMENT NYLON RED 1200M 0.28MM 6.6KG

d.tn120028r
Livrare 24-48 ore

112,22Lei

CUTIE DAIWA DOUBLE SIDE 19X11X4CM

CUTIE DAIWA DOUBLE SIDE 19X11X4CM

a4.15809.805
Livrare 24-48 ore

74,57Lei

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

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

d.11789.305
Livrare imediată!

272,90Lei

Fir Fluorocarbon Daiwa J, 0.50mm, 14.5kg, 50m

Fir Fluorocarbon Daiwa J, 0.50mm, 14.5kg, 50m

d.12220.050
Livrare imediată!

62,04Lei

Tambur Rezerva Mulineta Daiwa N Zone Distance 25

Tambur Rezerva Mulineta Daiwa N Zone Distance 25

d.19133.325
Livrare 24-48 ore

116,18Lei

Afişare 1501 - 1520 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: 121.063 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = 'a790d621a069beb2aef72cad44'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.147)
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 (52.596)
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 (67.769)
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 1500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.184)
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