Daiwa


BUFF DAIWA ALBASTRU/ALB -17%

BUFF DAIWA ALBASTRU/ALB

d.tdcbw
Livrare 24-48 ore

34,71Lei(-17%) 28,79Lei

Lanseta DAIWA Ninja X XF Spin 2.25m, 15-40g, 2seg

Lanseta DAIWA Ninja X XF Spin 2.25m, 15-40g, 2seg

d.11204.225
Livrare 24-48 ore

227,30Lei

Mulineta DAIWA 20 Ninja BR LT Spin 5000-C, 5.2:1, 0.25mm/330m, 1rul

Mulineta DAIWA 20 Ninja BR LT Spin 5000-C, 5.2:1, 0.25mm/330m, 1rul

d.10150.505
Livrare 24-48 ore

465,18Lei

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

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

d.11770.365r
Livrare imediată!

35,78Lei

TRICOU DAIWA POLO BLEU MARIME XL

TRICOU DAIWA POLO BLEU MARIME XL

d.dpsb.xl
Livrare 24-48 ore

135,65Lei

Cosulet Daiwa Feeder N Zon Square Medium 60g

Cosulet Daiwa Feeder N Zon Square Medium 60g

a.13340.060
Livrare 24-48 ore

17,90Lei

JIG MUSTAD BIG EYE BUCKTAIL BLACK SILVER/BW SILVER CRYSTAL FLASH 14G -45%

JIG MUSTAD BIG EYE BUCKTAIL BLACK SILVER/BW SILVER CRYSTAL FLASH 14G

f.m.bebbksi.1.2
Livrare imediată!

22,45Lei(-45%) 12,41Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS G40 2SEG -10%

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS G40 2SEG

d.11584.364
Livrare imediată!

271,42Lei(-10%) 244,93Lei

MATRITA DAIWA MOULD NZON METHOD MAR.M

MATRITA DAIWA MOULD NZON METHOD MAR.M

a.13345.100
Livrare imediată!

15,40Lei

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.60m, 30-90g, 3seg

Lanseta Universala Daiwa Black Widow XT Bait 3.60m, 30-90g, 3seg

d.11554.361
Livrare 24-48 ore

292,47Lei

Varf Daiwa pentru Ninja X Stalker Feeder 270, Green, 100g

Varf Daiwa pentru Ninja X Stalker Feeder 270, Green, 100g

d.11605.270g
Livrare 24-48 ore

31,25Lei

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg -18%

Lanseta Daiwa N Zon Super Slim Power Feeder 3.66m, 150g, 3+2seg

d.11161.360
Livrare imediată!

562,15Lei(-18%) 458,28Lei

Cap Suport Spate pentru Lansete Daiwa U N Zon Universal

Cap Suport Spate pentru Lansete Daiwa U N Zon Universal

a6.13406.000
Livrare 24-48 ore

26,54Lei

Mulineta Daiwa Fuego LT2000S, 0.14mm/150m, 6.2:1, 6rul

Mulineta Daiwa Fuego LT2000S, 0.14mm/150m, 6.2:1, 6rul

d.10333.201
Livrare 24-48 ore

560,56Lei

Lanseta Daiwa Ninja X Feeder 3.90m, 220g, 3+3seg -9%

Lanseta Daiwa Ninja X Feeder 3.90m, 220g, 3+3seg

d.11608.396
Livrare 24-48 ore

392,94Lei(-9%) 356,87Lei

Mulineta Daiwa Certate FC LT 2000-P 0.16mm/150m, 4.9:1, 10rul

Mulineta Daiwa Certate FC LT 2000-P 0.16mm/150m, 4.9:1, 10rul

d.10424.200
Livrare imediată!

3.078,63Lei

Set Masurare Distanta Daiwa N'Zone Distance Sticks

Set Masurare Distanta Daiwa N'Zone Distance Sticks

a6.13420.800
Livrare imediată!

206,50Lei

Lanseta DAIWA N'Zon PBR Feeding 3.96m, 230g, 3seg

Lanseta DAIWA N'Zon PBR Feeding 3.96m, 230g, 3seg

d.11166.390
Livrare imediată!

533,13Lei

Benzi Prindere Lanseta Daiwa, 2buc/pac

Benzi Prindere Lanseta Daiwa, 2buc/pac

a8.15803.200
Livrare imediată!

11,77Lei

Afişare 201 - 220 din 1583 (80 pagini)
Queries: 7, Total time: 105.892 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '4549cf0817ff96ff49642e2881'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
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.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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (41.643)
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 (63.564)
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 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.270)
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