Daiwa


Mulineta Daiwa Exceler LT3000-CXH, 0.23mm/150m, 6.2:1, 5rul -17%

Mulineta Daiwa Exceler LT3000-CXH, 0.23mm/150m, 6.2:1, 5rul

d.10336.301
Livrare 24-48 ore

601,12Lei(-17%) 499,40Lei

Lanseta, Spinning, Daiwa, Ninja, EXT, Spin, 2.45m,, 15-50g,, 3seg, d.11206.246, Lansete Rapitori, Lansete Rapitori Daiwa, Lansete Daiwa, Rapitori Daiwa, Daiwa
LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 10-30G -12%

LANSETA SPINNING DAIWA 2SEG NINJA X SPIN 2.10M 10-30G

d.11205.212
Livrare imediată!

205,75Lei(-12%) 180,32Lei

Tambur de rezerva Daiwa Ninja Match & Feeder LT 4000C

Tambur de rezerva Daiwa Ninja Match & Feeder LT 4000C

d.19217.400
Livrare 24-48 ore

203,22Lei

LANSETA, DAIWA, BLACK, WIDOW, CARP, 3.60M, 3.00LBS, G40, 2SEG, d.11584.364, Lansete Crap, Lansete Crap Daiwa, Daiwa
METHOD FEEDER DAIWA NZON METHOD 35G MAR. L

METHOD FEEDER DAIWA NZON METHOD 35G MAR. L

a3.13345.235
Livrare imediată!

20,43Lei

Lanseta Spinning Daiwa Crossfire Spin 2.10m, 10-40g, 2seg

Lanseta Spinning Daiwa Crossfire Spin 2.10m, 10-40g, 2seg

d.11438.211
Livrare imediată!

196,02Lei

Lanseta Spinning Daiwa MF Travel Spin 2.40m, 30-70g, 4seg

Lanseta Spinning Daiwa MF Travel Spin 2.40m, 30-70g, 4seg

d.11253.241
Livrare 24-48 ore

340,36Lei

Mulineta Daiwa Crosscast 45SCW 5000LD QD OT -23%

Mulineta Daiwa Crosscast 45SCW 5000LD QD OT

d.10250.605
Livrare imediată!

906,33Lei(-23%) 697,90Lei

Multiplicator, Daiwa, Tatula, Elite, P/F, 103HSL, 7.1:1,, 0.37mm-65m,, 7rul, d.10721.100, Mulinete Casting, Mulinete Casting Daiwa, Mulinete Daiwa, Casting Daiwa, Daiwa
Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.70mm, 60lbs, 30m

Fir Fluorocarbon Daiwa Saltiga FC Leader X Link 0.70mm, 60lbs, 30m

d.12956.570
Livrare imediată!

119,65Lei

Mulineta, Daiwa, Fuego, LT2000S,, 0.14mm/150m,, 6.2:1,, 6rul, d.10333.201, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Mulineta, Daiwa, Certate, FC, LT, 2500D, 0.28mm/150m,, 5.7:1,, 10rul, d.10424.252, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
Lanseta Daiwa Crosscast Carp Z 2334 3.66m, 3.5lbs, 2seg

Lanseta Daiwa Crosscast Carp Z 2334 3.66m, 3.5lbs, 2seg

d.cccz2334ax
Livrare imediată!

503,39Lei

Lanseta Spinning Daiwa Prorex XR Spin 2.25m, 10-30g, 2seg

Lanseta Spinning Daiwa Prorex XR Spin 2.25m, 10-30g, 2seg

d.11332.225
Livrare 24-48 ore

901,35Lei

MULINETA, DAIWA, EMBLEM, SPOD, 35SCW, QD, d.10158.606, Mulinete Crap, Mulinete Crap Daiwa, Daiwa

MULINETA, DAIWA, EMBLEM, SPOD, 35SCW, QD, d.10158.606, Mulinete Crap, Mulinete Crap Daiwa, Daiwa

d.10158.606
Livrare imediată!

832,73Lei

Lanseta Daiwa N Zon S Feeder 3.60m 120g

Lanseta Daiwa N Zon S Feeder 3.60m 120g

d.11136.360
Livrare 24-48 ore

654,79Lei

MULINETA, DAIWA, CROSSCAST, SURF, 45SCW, 5000C, QD, , d.10251.500, Mulinete Crap, Mulinete Crap Daiwa, Daiwa -20%

MULINETA, DAIWA, CROSSCAST, SURF, 45SCW, 5000C, QD, , d.10251.500, Mulinete Crap, Mulinete Crap Daiwa, Daiwa

d.10251.500
Livrare imediată!

768,95Lei(-20%) 615,16Lei

VARF DAIWA PENTRU NINJA X METHOD FEEDER GREEN 80g

VARF DAIWA PENTRU NINJA X METHOD FEEDER GREEN 80g

d.11603.000g
Livrare imediată!

40,86Lei

BLUZA DAIWA D-VEC BLUE MARIME XL -30%

BLUZA DAIWA D-VEC BLUE MARIME XL

d.18299.340
Livrare 24-48 ore

300,33Lei(-30%) 210,23Lei

Afişare 1 - 20 din 1475 (74 pagini)
Queries: 7, Total time: 102.613 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = 'fa06ff940c91000c896d26ff12'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.128)
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
5 (42.466)
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:1667
6 (59.468)
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:438
7 (0.177)
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