Daiwa


Lanseta DAIWA Ninja X Jiggerspin 2.70m, 8-35g, 2seg

Lanseta DAIWA Ninja X Jiggerspin 2.70m, 8-35g, 2seg

d.11203.275
Livrare 24-48 ore

264,87Lei

Tricou DAIWA D Old Shirt Short Sleeve 31, Light Blue, Marime L

Tricou DAIWA D Old Shirt Short Sleeve 31, Light Blue, Marime L

d.21sshirt31lbl
Livrare 24-48 ore

122,08Lei

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Yellow 3.60m/3.90m, 180g

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Yellow 3.60m/3.90m, 180g

d.11770.366y
Livrare imediată!

35,78Lei

Varga DAIWA Tele Aqualite Alborella, 4m, 4seg

Varga DAIWA Tele Aqualite Alborella, 4m, 4seg

d.aqlalb40cf
Livrare imediată!

194,89Lei

LINGURITA DAIWA ROTATIVA 4G SILVER GREEN

LINGURITA DAIWA ROTATIVA 4G SILVER GREEN

d.07410892
Livrare 24-48 ore

22,87Lei

Lanseta DAIWA EXCELER CATFISH BOJE 2.70M 200-600G 2seg

Lanseta DAIWA EXCELER CATFISH BOJE 2.70M 200-600G 2seg

d.11818.276
Livrare imediată!

374,07Lei

Mulineta Daiwa Crossfire LT 3000 4BS A -17%

Mulineta Daiwa Crossfire LT 3000 4BS A

d.10186.300
Livrare imediată!

241,37Lei(-17%) 199,27Lei

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

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

d.11447.241
Livrare 24-48 ore

186,93Lei

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

Pantaloni Daiwa Joggers Camo, Marime XL

Pantaloni Daiwa Joggers Camo, Marime XL

d.18865.540
Livrare imediată!

253,59Lei

Mulineta Daiwa Fuego LT3000D-C, 0.23mm/150m, 6.2:1, 6rul

Mulineta Daiwa Fuego LT3000D-C, 0.23mm/150m, 6.2:1, 6rul

d.10333.305
Livrare 24-48 ore

573,81Lei

Lanseta Daiwa Ninja X Feeder 3.30m, 120g, 3+3seg

Lanseta Daiwa Ninja X Feeder 3.30m, 120g, 3+3seg

d.11608.330
Livrare 24-48 ore

305,49Lei

Fir Monofilament Daiwa Tournament SF 0.30mm, 7.90kg, 150m, Grey

Fir Monofilament Daiwa Tournament SF 0.30mm, 7.90kg, 150m, Grey

d.12205.130
Livrare 24-48 ore

27,98Lei

Lanseta Spinning Daiwa Tele Ninja X-Compact Spin 2.45m, 15-50g, 9+1seg

Lanseta Spinning Daiwa Tele Ninja X-Compact Spin 2.45m, 15-50g, 9+1seg

d.11208.240
Livrare 24-48 ore

415,96Lei

Montura DAIWA PX Screw-In Shallow Rig Nr.2/0+1/0

Montura DAIWA PX Screw-In Shallow Rig Nr.2/0+1/0

a.15419.720
Livrare 24-48 ore

27,19Lei

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul -10%

Mulineta DAIWA Vertice35-5000C, 4.1:1, 0.35mm/300m, 5rul

d.10131.500
Livrare imediată!

646,29Lei(-10%) 582,66Lei

Costum DAIWA D-Vec Winter, Marime M

Costum DAIWA D-Vec Winter, Marime M

d.18868.010
Livrare 24-48 ore

1.063,74Lei

Shad DAIWA Prorex Belly, Flash Minnow, 11cm, 12g, 4buc/pac

Shad DAIWA Prorex Belly, Flash Minnow, 11cm, 12g, 4buc/pac

d.15320.303
Livrare 24-48 ore

28,89Lei

Vobler DAIWA Prorex Swift Crank Floating, Chrome Wakasagi, 7cm, 12.9g, 1buc/pac

Vobler DAIWA Prorex Swift Crank Floating, Chrome Wakasagi, 7cm, 12.9g, 1buc/pac

f3.d15264.702
Livrare 24-48 ore

53,03Lei

BAC DAIWA EVA CU MANER PT.NADA 23X20CM

BAC DAIWA EVA CU MANER PT.NADA 23X20CM

a8.15809.120
Livrare imediată!

79,19Lei

Afişare 641 - 660 din 1664 (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: 97.925 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = 'e73095bd6eba7eadab0e221c68'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.070)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.095)
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.913)
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 (57.533)
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 640,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.133)
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