Daiwa


Cap Minciog DAIWA N'Zone Rubber Mesh Landing Net 45cm

Cap Minciog DAIWA N'Zone Rubber Mesh Landing Net 45cm

a2.13470.045
Livrare 24-48 ore

78,58Lei

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 Universala Daiwa Black Widow XT Bait 3.00m, 20-60g, 2seg

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 20-60g, 2seg

d.11554.300
Livrare 24-48 ore

232,28Lei

Lanseta Daiwa N Zon Super Slim Method Feeder 3.05m, 40g, 2+2seg

Lanseta Daiwa N Zon Super Slim Method Feeder 3.05m, 40g, 2+2seg

d.11160.300
Livrare 24-48 ore

374,68Lei

Tricou Daiwa Polo Red, Marime L

Tricou Daiwa Polo Red, Marime L

d.dpsr.l
Livrare 24-48 ore

135,65Lei

Mulineta Daiwa MATCHMAN 2500, 0.28mm/150m, 5.3:1, 3rul

Mulineta Daiwa MATCHMAN 2500, 0.28mm/150m, 5.3:1, 3rul

d.10113.250
Livrare 24-48 ore

273,38Lei

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

Afişare 221 - 240 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: 106.388 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = '22fd07cc68370af6c1f4763545'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.116)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.090)
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 (50.030)
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 (55.798)
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 220,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