Daiwa


LINGURITA, DAIWA, ROTATIVA, 4G, SILVER, METAL, d.07411555, Lingurite Rotative, Lingurite Rotative Daiwa, Daiwa -20%

LINGURITA, DAIWA, ROTATIVA, 4G, SILVER, METAL, d.07411555, Lingurite Rotative, Lingurite Rotative Daiwa, Daiwa

d.07411555
Livrare 24-48 ore

23,65Lei(-20%) 18,92Lei

BLUZA, DAIWA, D-VEC, LS, BLACK, MARIME, S, d.18206.210, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa -20%

BLUZA, DAIWA, D-VEC, LS, BLACK, MARIME, S, d.18206.210, Bluze si Pulovere, Bluze si Pulovere Daiwa, Daiwa

d.18206.210
Livrare 24-48 ore

200,79Lei(-20%) 160,63Lei

MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 1seg -23%

MINCIOG DAIWA INFINITY LNH 1.80M 105X105CM 1seg

a2.m11990.180
Livrare imediată!

658,09Lei(-23%) 506,90Lei

Lanseta, Spinning, Daiwa, 2seg, Triforce, Spin, Trout,, 2,10m,, 5-20g, d.11400.215, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Geanta Daiwa Back Widow Compact BWCTB 52x30x24cm

Geanta Daiwa Back Widow Compact BWCTB 52x30x24cm

d.18705.055
Livrare imediată!

190,55Lei

Lanseta Spinning Daiwa Tele Sweepfire 2.40m, 10-30g, 6seg -23%

Lanseta Spinning Daiwa Tele Sweepfire 2.40m, 10-30g, 6seg

d.11421.241
Livrare imediată!

201,49Lei(-23%) 155,90Lei

Cicada Daiwa DZA 3.1cm, 2.5g, Silver

Cicada Daiwa DZA 3.1cm, 2.5g, Silver

f.d15445.108
Livrare 24-48 ore

42,07Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 50-125g, 2seg -23%

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 50-125g, 2seg

d.11554.302
Livrare imediată!

280,04Lei(-23%) 215,90Lei

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

602,98Lei

Mulineta Daiwa Certate FC LT 4000D-C 0.37mm/150m, 5.2:1, 10rul

Mulineta Daiwa Certate FC LT 4000D-C 0.37mm/150m, 5.2:1, 10rul

d.10424.400
Livrare 24-48 ore

3.381,52Lei

Lanseta Daiwa Hyper Spod 3500 3.90m, 5.0lbs, 2seg

Lanseta Daiwa Hyper Spod 3500 3.90m, 5.0lbs, 2seg

d.dhspd3500ax
Livrare imediată!

412,13Lei

Lanseta Spinning Daiwa Preso IPRIMI 2.15m, 0.5-6g, 2seg

Lanseta Spinning Daiwa Preso IPRIMI 2.15m, 0.5-6g, 2seg

d.11719.215
Livrare 24-48 ore

450,28Lei

MULINETA DAIWA LEXA E LT 2500 -26%

MULINETA DAIWA LEXA E LT 2500

d.10226.250
Livrare imediată!

1.073,31Lei(-26%) 792,61Lei

Lanseta Feeder Daiwa N Zon Z Power Feeder 3.60m 150g

Lanseta Feeder Daiwa N Zon Z Power Feeder 3.60m 150g

d.11138.366
Livrare 24-48 ore

1.268,84Lei

Fir Daiwa Tournament SF Green 0.16mm 300m 2.3kg

Fir Daiwa Tournament SF Green 0.16mm 300m 2.3kg

d.12200.316
Livrare imediată!

32,34Lei

TAMBUR DAIWA MULINETA NINJA LT 6000

TAMBUR DAIWA MULINETA NINJA LT 6000

d.19219.600
Livrare imediată!

121,37Lei

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

Set borsete Daiwa IS EVA Small Accessory Pouch Set - Small

d.18850.010
Livrare imediată!

190,55Lei

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G LIME CHART

VOBLER DAIWA TN WISE MINNOW 5,0CM/5,2G LIME CHART

f3.d16711.203
Livrare 24-48 ore

73,34Lei

PILKER MUSTAD DAGGERMAN FULL CHROME 100G 20MM

PILKER MUSTAD DAGGERMAN FULL CHROME 100G 20MM

f.m.jig02.fcr.100
Livrare 24-48 ore

42,49Lei

GEANTA DAIWA PLIABILA IMPERMEABILA EVA 36X25X23CM

GEANTA DAIWA PLIABILA IMPERMEABILA EVA 36X25X23CM

d.15809.125
Livrare 24-48 ore

166,96Lei

Afişare 1 - 20 din 1475 (74 pagini)
Queries: 7, Total time: 88.088 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = 'a91ac0e6bd8ddc171265058035'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.133)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.141)
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 = '3' AND p.manufacturer_id = '11'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (52.357)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '3' AND p.manufacturer_id = '11' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38