Daiwa


TRICOU, DAIWA, POLO, GREY, CAMO, MARIME, XL, d.18293.740, Tricouri, Tricouri Daiwa, Daiwa -30%

TRICOU, DAIWA, POLO, GREY, CAMO, MARIME, XL, d.18293.740, Tricouri, Tricouri Daiwa, Daiwa

d.18293.740
Livrare 24-48 ore

312,59Lei(-30%) 218,81Lei

VARF, DAIWA, PENTRU, NINJA, X, FEEDER, GALBEN, d.11607.365y, Varfuri Feeder, Varfuri Feeder Daiwa, Daiwa

VARF, DAIWA, PENTRU, NINJA, X, FEEDER, GALBEN, d.11607.365y, Varfuri Feeder, Varfuri Feeder Daiwa, Daiwa

d.11607.365y
Livrare imediată!

43,17Lei

LINGURITA DAIWA ROTATIVA 4G GOLD RED BLACK -20%

LINGURITA DAIWA ROTATIVA 4G GOLD RED BLACK

d.07410889
Livrare 24-48 ore

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

JIG MUSTAD MOONRISER GREEN MACKEREL 120G 20MM

JIG MUSTAD MOONRISER GREEN MACKEREL 120G 20MM

f.m.jig03.gmk.120
Livrare 24-48 ore

45,96Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS 3SEG -10%

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.00LBS 3SEG

d.11584.369
Livrare imediată!

271,39Lei(-10%) 244,25Lei

Lanseta, Spinning, Daiwa, Sweepfire, Spin, 2.40m,, 15-50g,, 2seg, d.11446.241, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -23%

Lanseta, Spinning, Daiwa, Sweepfire, Spin, 2.40m,, 15-50g,, 2seg, d.11446.241, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11446.241
Livrare imediată!

203,31Lei(-23%) 156,90Lei

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 20-60g, 2seg

Lanseta Universala Daiwa Black Widow XT Bait 3.00m, 20-60g, 2seg

d.11554.300
Livrare 24-48 ore

248,42Lei

Hanorac, Daiwa, Carp, 3XL, d.18865.160, Hanorace, Hanorace Daiwa, Daiwa

Hanorac, Daiwa, Carp, 3XL, d.18865.160, Hanorace, Hanorace Daiwa, Daiwa

d.18865.160
Livrare imediată!

276,75Lei

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

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

d.11162.390
Livrare imediată!

542,35Lei

Mulineta Daiwa Legalis LT3000-C(U), 0.25mm/150m, 5.3:1, 5rul

Mulineta Daiwa Legalis LT3000-C(U), 0.25mm/150m, 5.3:1, 5rul

d.10435.300
Livrare 24-48 ore

503,58Lei

Lanseta Daiwa Megaforce Boat 21MH ST 2.10m, 50-150g, 2seg

Lanseta Daiwa Megaforce Boat 21MH ST 2.10m, 50-150g, 2seg

d.mfb21mhstcf
Livrare 24-48 ore

252,32Lei

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

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

d.12410.110
Livrare 24-48 ore

72,23Lei

Geanta Accesorii Daiwa Prorex Lure XL 46x35x33cm -30%

Geanta Accesorii Daiwa Prorex Lure XL 46x35x33cm

d.15809.425
Livrare 24-48 ore

619,54Lei(-30%) 433,67Lei

Cosulet Daiwa Feeder N Zon Distance Large 30g

Cosulet Daiwa Feeder N Zon Distance Large 30g

a.13332.030
Livrare 24-48 ore

14,40Lei

Husa Daiwa Prorez Rod Bag 154x8cm

Husa Daiwa Prorez Rod Bag 154x8cm

d.15810.270
Livrare 24-48 ore

103,13Lei

Momitor, Feeder, Daiwa, Feeder, N, Zon, M, 30g, a.13321.030, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

Momitor, Feeder, Daiwa, Feeder, N, Zon, M, 30g, a.13321.030, Cosulete Feeder, Cosulete Feeder Daiwa, Daiwa

a.13321.030
Livrare imediată!

14,14Lei

Cosulet Daiwa N Zon Feeder Distance M 40g

Cosulet Daiwa N Zon Feeder Distance M 40g

a.13331.040
Livrare 24-48 ore

14,80Lei

LANSETA DAIWA TOURNAMENT AGS BAITCAST 2.10M 14-42G 2SEG

LANSETA DAIWA TOURNAMENT AGS BAITCAST 2.10M 14-42G 2SEG

d.11118.215
Livrare imediată!

1.985,30Lei

TAMBUR DAIWA UNIVERSAL MULINETA LT 5000D

TAMBUR DAIWA UNIVERSAL MULINETA LT 5000D

d.19115.500
Livrare imediată!

127,19Lei

Lanseta Spinning Daiwa Silver Creek L Spin 2.35m, 5-21g, 2seg -23%

Lanseta Spinning Daiwa Silver Creek L Spin 2.35m, 5-21g, 2seg

d.11441.236
Livrare imediată!

385,64Lei(-23%) 296,91Lei

Afişare 61 - 80 din 1480 (74 pagini)
Queries: 7, Total time: 96.740 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '07856832ff203e1b767e8d8487'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.100)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.091)
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 (38.922)
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 (57.242)
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 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.120)
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