Daiwa


Fir Textil DAIWA N'Zone 8X Braid Steel Gray, 0.12mm, 8.50kg, 150m

Fir Textil DAIWA N'Zone 8X Braid Steel Gray, 0.12mm, 8.50kg, 150m

d.12410.112
Livrare 24-48 ore

72,23Lei

Cosulet Daiwa Feeder N Zon Square Medium 20g

Cosulet Daiwa Feeder N Zon Square Medium 20g

a.13340.020
Livrare 24-48 ore

12,44Lei

Momitor, Feeder, Daiwa, Feeder, N, Zon, XL, 40g, a.13324.040, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

Momitor, Feeder, Daiwa, Feeder, N, Zon, XL, 40g, a.13324.040, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

a.13324.040
Livrare imediată!

15,18Lei

Fir, Daiwa, Tournament, SF, Grey, 0.20mm, 300m, 3.5kg, d.12205.320, Fire Monofilament Crap, Fire Monofilament Crap Daiwa, Daiwa
NADA DAIWA METHOD SWEET FISHMEAL 1KG

NADA DAIWA METHOD SWEET FISHMEAL 1KG

a0.13300.009
Livrare imediată!

33,19Lei

VARF, DAIWA, PENTRU, NINJA, X, FEEDER, RED, d.11605.001r, Varfuri Feeder, Varfuri Feeder Daiwa, Daiwa

VARF, DAIWA, PENTRU, NINJA, X, FEEDER, RED, d.11605.001r, Varfuri Feeder, Varfuri Feeder Daiwa, Daiwa

d.11605.001r
Livrare imediată!

29,33Lei

Suport, feeder, Daiwa, N, Zon, EVA, Feeder, 50cm, a6.13309.305, Capete Suport Feeder, Capete Suport Feeder Daiwa, Daiwa
FIR, MONOFILAMENT, DAIWA, TOURNAMENT, SF, GREEN, 300M, 0.36mm, 11.10kg, d.12200.336, Fire Monofilament Crap, Fire Monofilament Crap Daiwa, Daiwa
LINGURITA DAIWA ROTATIVA 4G GOLD ORANGE -20%

LINGURITA DAIWA ROTATIVA 4G GOLD ORANGE

d.07410880
Livrare 24-48 ore

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

LANSETA DAIWA CROSSCAST XT CARP 3.90M 3.5LBS 2SEG

LANSETA DAIWA CROSSCAST XT CARP 3.90M 3.5LBS 2SEG

d.11562.395
Livrare 24-48 ore

727,16Lei

LANSETA DAIWA BLACK WIDOW CARP 3.90M 3,5LBS 2seg -11%

LANSETA DAIWA BLACK WIDOW CARP 3.90M 3,5LBS 2seg

d.11584.395
Livrare imediată!

270,13Lei(-11%) 239,99Lei

Lanseta, Spinning, Daiwa, Silver, Creek, L, Spin, 1.80m,, 5-21g,, 2seg, d.11441.181, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -23%

Lanseta, Spinning, Daiwa, Silver, Creek, L, Spin, 1.80m,, 5-21g,, 2seg, d.11441.181, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11441.181
Livrare imediată!

332,09Lei(-23%) 255,90Lei

Carlige Legate Daiwa Samurai Feeder Nr.6, 10buc/pac

Carlige Legate Daiwa Samurai Feeder Nr.6, 10buc/pac

a.14805.006
Livrare imediată!

14,54Lei

Lanseta, Spinning, Daiwa, SweepFire, 1.80m,, 5-10g,, 2seg, d.11445.180, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Lanseta Daiwa N Zon Super Slim Feeder 3.66m, 120g, 3+2seg

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

d.11163.360
Livrare imediată!

534,83Lei

LANSETA DAIWA BLACK WIDOW B CARP 3.60M 3.00LBS 3SEG

LANSETA DAIWA BLACK WIDOW B CARP 3.60M 3.00LBS 3SEG

11579-368
Stoc epuizat

239,00Lei

Mulineta Daiwa Legalis LT4000-C(U), 0.28mm/150m, 5.2:1, 5rul

Mulineta Daiwa Legalis LT4000-C(U), 0.28mm/150m, 5.2:1, 5rul

d.10435.400
Livrare 24-48 ore

517,50Lei

Prosop Daiwa 28x20cm

Prosop Daiwa 28x20cm

d.15803.060
Livrare 24-48 ore

35,39Lei

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

261,07Lei

Lanseta Spinning Daiwa Tele Ninja X-Compact Spin 2.25m, 5-30g, 8+1seg

Lanseta Spinning Daiwa Tele Ninja X-Compact Spin 2.25m, 5-30g, 8+1seg

d.11208.220
Livrare 24-48 ore

410,25Lei

Afişare 1 - 20 din 1485 (75 pagini)
Queries: 9, Total time: 94.138 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '71006d904c4139df25e47b1cdf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.147)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.127)
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
6 (37.180)
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:1650
7 (56.082)
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 = '2' 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:432
8 (0.119)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.115)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38