Daiwa


Pantaloni Scurti Daiwa Camo, Marime M

Pantaloni Scurti Daiwa Camo, Marime M

d.18865.620
Livrare imediată!

193,48Lei

Mulineta Daiwa Exceler LT2500-XH, 0.20mm/150m, 6.2:1, 5rul -8%

Mulineta Daiwa Exceler LT2500-XH, 0.20mm/150m, 6.2:1, 5rul

d.10336.251
Livrare 24-48 ore

527,16Lei(-8%) 483,41Lei

Lanseta Daiwa Prorex XR BC 2.40, 40-120g, 2seg

Lanseta Daiwa Prorex XR BC 2.40, 40-120g, 2seg

d.11336.245
Livrare 24-48 ore

881,93Lei

Lanseta Spinning Daiwa Preso Trout Spin 1.90m, 0.5-5g, 2seg

Lanseta Spinning Daiwa Preso Trout Spin 1.90m, 0.5-5g, 2seg

d.11718.190
Livrare 24-48 ore

608,67Lei

Fir Textil DAIWA J-Braid Expedition X8 PE 0.06mm, 5.20kg, 150m, Orange

Fir Textil DAIWA J-Braid Expedition X8 PE 0.06mm, 5.20kg, 150m, Orange

d.12550.006
Livrare imediată!

82,11Lei

Cosulet Daiwa Nzon Window Feeder PB, 45g, 1buc/pac

Cosulet Daiwa Nzon Window Feeder PB, 45g, 1buc/pac

a3.13358.045
Livrare 24-48 ore

20,12Lei

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Firetiger, 4.1cm, 6.5g, 1buc/pac

Vobler DAIWA Prorex Chibi Fuku 1 Crank Floating, Firetiger, 4.1cm, 6.5g, 1buc/pac

f3.d15263.403
Livrare 24-48 ore

46,34Lei

Shad DAIWA Prorex Belly, Natural Green Roach, 6cm, 2g, 4buc/pac

Shad DAIWA Prorex Belly, Natural Green Roach, 6cm, 2g, 4buc/pac

d.15320.119
Livrare 24-48 ore

31,99Lei

Mulineta DAIWA 24 N Zon Plus LT6000SS-CP 5RUL/150MX028M/4.9:1

Mulineta DAIWA 24 N Zon Plus LT6000SS-CP 5RUL/150MX028M/4.9:1

d.10317.500
Livrare 24-48 ore

1.184,31Lei

Mulineta Daiwa 23 Ninja LT 2000, 5.2:1, 0.16mm/150m, 4rul -8%

Mulineta Daiwa 23 Ninja LT 2000, 5.2:1, 0.16mm/150m, 4rul

d.10005.200
Livrare imediată!

352,76Lei(-8%) 323,82Lei

MULINETA DAIWA N ZON PLUS LT 5000S-CP -21%

MULINETA DAIWA N ZON PLUS LT 5000S-CP

d.10311.500
Livrare 24-48 ore

987,44Lei(-21%) 783,17Lei

Fir Monofilament DAIWA Bass-X Nylon, Brown, 300m, 0.37mm, 20lbs/9.07kg

Fir Monofilament DAIWA Bass-X Nylon, Brown, 300m, 0.37mm, 20lbs/9.07kg

d.bsxny20lb300
Livrare 24-48 ore

33,96Lei

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime 2XL

Bluza DAIWA D Old Shirt Long Sleeve 30, Dark Gray, Marime 2XL

d.21lshirt30dg2xl
Livrare 24-48 ore

147,18Lei

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 747 HM HFSCF 2.24m, 10-35g, 2seg

Lanseta Spinning DAIWA Morethan Branzino Expert AGS 747 HM HFSCF 2.24m, 10-35g, 2seg

d.mtbrexags742hmhfsc
Livrare 24-48 ore

3.849,82Lei

Mulineta DAIWA 25 RZ 2000 Spinning 3Rul, 0,10mm-250m, 5.1:1

Mulineta DAIWA 25 RZ 2000 Spinning 3Rul, 0,10mm-250m, 5.1:1

d.25rz2000
Livrare 24-48 ore

225,11Lei

Fir Daiwa Tournament SF Green 0.30mm 300m 7.9kg

Fir Daiwa Tournament SF Green 0.30mm 300m 7.9kg

d.12200.330
Livrare 24-48 ore

34,32Lei

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

GEANTA DAIWA IS CARRYALL 64X39X27CM ISLLC

d.18850.200
Livrare imediată!

395,36Lei

TRICOU DAIWA POLO BLEU MARIME XL

TRICOU DAIWA POLO BLEU MARIME XL

d.dpsb.xl
Livrare 24-48 ore

135,65Lei

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.18mm 2.90kg

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.18mm 2.90kg

d.12200.318
Livrare imediată!

29,68Lei

JIG MUSTAD TRACESHOT BLACK FLASH 15G 8MM

JIG MUSTAD TRACESHOT BLACK FLASH 15G 8MM

f.m.jig07.blf.15
Livrare 24-48 ore

33,15Lei

Afişare 101 - 120 din 1588 (80 pagini)
Queries: 7, Total time: 128.199 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = 'cd5af7971fe099f51d86b8fd99'
/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.114)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
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 (55.908)
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 (71.716)
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 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.131)
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