Daiwa


BUFF, DAIWA, GREEN, CAMO, d.18206.102, Sepci Caciuli si Cagule, Sepci Caciuli si Cagule Daiwa, Daiwa -20%

BUFF, DAIWA, GREEN, CAMO, d.18206.102, Sepci Caciuli si Cagule, Sepci Caciuli si Cagule Daiwa, Daiwa

d.18206.102
Livrare 24-48 ore

37,08Lei(-20%) 29,67Lei

Husa lansete Daiwa IS 3 lansete 3.60m 200X25X12CM

Husa lansete Daiwa IS 3 lansete 3.60m 200X25X12CM

d.18851.012
Livrare 24-48 ore

376,58Lei

Lanseta Spinning XX Lans Daiwa 2seg Silver Creek UL Spin, 2.20m, 3-14g -23%

Lanseta Spinning XX Lans Daiwa 2seg Silver Creek UL Spin, 2.20m, 3-14g

d.11430.221
Livrare imediată!

323,44Lei(-23%) 248,90Lei

Mulineta Daiwa Crosscast Surf Type - R 35 SCW QD 3+1rul

Mulineta Daiwa Crosscast Surf Type - R 35 SCW QD 3+1rul

d.ccs2235scw5000qdr
Livrare imediată!

797,10Lei

Lanseta, Spinning, Daiwa, MF, Travel, Spin, 2.25,, 5-25,, 4seg, d.11253.225, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
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

287,58Lei

Lanseta Daiwa Ballistic X Spin 2.10m, 20-60g, 2seg

Lanseta Daiwa Ballistic X Spin 2.10m, 20-60g, 2seg

d.11525.212
Livrare 24-48 ore

553,20Lei

Pantaloni Daiwa Joggers Camo, Marime 2XL

Pantaloni Daiwa Joggers Camo, Marime 2XL

d.18865.550
Livrare imediată!

262,48Lei

Mulineta, Daiwa, Lexa, LT, 4000,, 0.28mm/150m,, 5.2:1,, 5rul, d.10228.400, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Lanseta, Daiwa, Ninja, X, Feeder, 3.90m,, 120g,, 3+3seg, d.11608.390, Lansete Feeder, Lansete Feeder Daiwa, Lansete Daiwa, Feeder Daiwa, Daiwa
Mulineta Daiwa Tatula TW 100HL 0.33mm/100m, 8.1:1, 7rul

Mulineta Daiwa Tatula TW 100HL 0.33mm/100m, 8.1:1, 7rul

d.10714.112
Livrare 24-48 ore

1.124,76Lei

Lanseta, Spinning, Daiwa, Tatula, 711MHFS, 2.16m,, 7-28g,, 1seg, d.tat711mhfsbf, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
Lanseta Spinning Daiwa Ninja X Kids Green, 1.80m, 20-60g, 2seg

Lanseta Spinning Daiwa Ninja X Kids Green, 1.80m, 20-60g, 2seg

d.11208.180
Livrare imediată!

148,85Lei

Mulineta, DAIWA, 23, Revros, LT, 4000-C,, 0.28mm/150m,, 5.2:1,, 4rul, d.10221.402, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
MULINETA DAIWA EMCAST BR LT 3000 -17%

MULINETA DAIWA EMCAST BR LT 3000

d.10148.300
Livrare imediată!

581,10Lei(-17%) 482,76Lei

Cosulet Daiwa Feeder N Zon Distance Medium 50g

Cosulet Daiwa Feeder N Zon Distance Medium 50g

a.13331.050
Livrare imediată!

15,71Lei

Husa Daiwa Prorez Rod Bag 127x8cm

Husa Daiwa Prorez Rod Bag 127x8cm

d.15810.240
Livrare imediată!

98,25Lei

Momitor Feeder Daiwa Feeder N Zon M 20g

Momitor Feeder Daiwa Feeder N Zon M 20g

a.13321.020
Livrare imediată!

13,10Lei

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 24-48 ore

33,26Lei

Cosulet Daiwa Feeder N Zon Tunel Medium 60g

Cosulet Daiwa Feeder N Zon Tunel Medium 60g

a.13335.060
Livrare 24-48 ore

16,51Lei

Afişare 101 - 120 din 1475 (74 pagini)
Queries: 7, Total time: 96.631 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '047e5d66faf2391bacff623179'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
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.110)
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 (39.356)
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:1667
6 (56.753)
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 = '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:438
7 (0.122)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38