Daiwa


Lanseta Feeder DAIWA N Zon Tele Feeder, Up To 60g, 3.00m, 6+2seg

Lanseta Feeder DAIWA N Zon Tele Feeder, Up To 60g, 3.00m, 6+2seg

d.11334.300
Livrare 24-48 ore

276,04Lei

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

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

a2.13470.050
Livrare 24-48 ore

84,30Lei

Lanseta DAIWA Ninja X Light Spin 2.25m, 4-18g, 2seg

Lanseta DAIWA Ninja X Light Spin 2.25m, 4-18g, 2seg

d.11204.220
Livrare 24-48 ore

227,30Lei

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Red 3.60m/3.90m, 120g

Varf Quiver Lanseta DAIWA Triforce Distance Feeder QT Red 3.60m/3.90m, 120g

d.11770.360r
Livrare imediată!

36,99Lei

Varga DAIWA Tele Aqualite Alborella, 3.5m, 4seg

Varga DAIWA Tele Aqualite Alborella, 3.5m, 4seg

d.aqlalb35cf
Livrare imediată!

157,66Lei

LINGURITA DAIWA ROTATIVA 6G GOLD ORANGE

LINGURITA DAIWA ROTATIVA 6G GOLD ORANGE

d.07410897
Livrare 24-48 ore

23,52Lei

Lanseta Spinning Daiwa Silver Creek UL Spin 1.80m, 3-14g, 2seg

Lanseta Spinning Daiwa Silver Creek UL Spin 1.80m, 3-14g, 2seg

d.11441.180
Livrare imediată!

281,89Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 20-60g, 3seg

Lanseta Universala Daiwa Black Widow XT Bait 3.30m, 20-60g, 3seg

d.11554.330
Livrare 24-48 ore

268,77Lei

Lanseta Daiwa N‘Zon Extension Feeder 3.65m, 80g, 2+2seg -20%

Lanseta Daiwa N‘Zon Extension Feeder 3.65m, 80g, 2+2seg

d.11333.360
Livrare imediată!

467,89Lei(-20%) 374,07Lei

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

Lanseta Daiwa N Zon Super Slim Method Feeder 3.35m, 60g, 2+2seg

d.11160.330
Livrare imediată!

388,17Lei

Lanseta Daiwa Tournament Feeder 3.60m, 50g, 3+3seg

Lanseta Daiwa Tournament Feeder 3.60m, 50g, 3+3seg

d.tnsf12q.au
Livrare 24-48 ore

3.172,79Lei

Mulineta Daiwa MATCHMAN 4000, 0.33mm/250m, 5.3:1, 3rul

Mulineta Daiwa MATCHMAN 4000, 0.33mm/250m, 5.3:1, 3rul

d.10113.400
Livrare 24-48 ore

314,00Lei

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

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

d.11608.360
Livrare 24-48 ore

322,39Lei

Lanseta DAIWA Ninja X Stalker Feeder 11610, 3.60m, 80g, 3+3seg

Lanseta DAIWA Ninja X Stalker Feeder 11610, 3.60m, 80g, 3+3seg

d.11610.361
Livrare 24-48 ore

300,26Lei

Lanseta Daiwa Megaforce Boat 24MH ST 2.40m, 50-150g, 2seg

Lanseta Daiwa Megaforce Boat 24MH ST 2.40m, 50-150g, 2seg

d.mfb24mhcf
Livrare 24-48 ore

172,88Lei

Mulineta Daiwa 24 TDR 2508QD, 4.8:1, 0.23mm/150m, 8+1rul

Mulineta Daiwa 24 TDR 2508QD, 4.8:1, 0.23mm/150m, 8+1rul

d.10516.258
Livrare 24-48 ore

1.396,35Lei

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

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

a.15419.730
Livrare 24-48 ore

28,50Lei

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.501
Livrare imediată!

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

Costum DAIWA D-Vec Winter, Marime XXL

Costum DAIWA D-Vec Winter, Marime XXL

d.18868.040
Livrare 24-48 ore

1.063,74Lei

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

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

d.15320.307
Livrare 24-48 ore

31,36Lei

Afişare 41 - 60 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: 108.081 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '24854608a84395c6085d0229d3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.110)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.131)
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 (45.256)
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 (62.288)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.087)
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