Daiwa


Lanseta Daiwa Ballistic X Jig 2.20m, 7-28g, 2seg -23%

Lanseta Daiwa Ballistic X Jig 2.20m, 7-28g, 2seg

d.11526.220
Livrare imediată!

549,43Lei(-23%) 422,90Lei

Pantaloni, Scurti, Daiwa, Camo,, Marime, L, d.18865.630, Pantaloni si Indispensabili, Pantaloni si Indispensabili Daiwa, Pantaloni Daiwa, Indispensabili Daiwa, Daiwa
Mulineta Daiwa Fuego LT 1000D, 0.20mm/150m, 5.2:1, 6rul

Mulineta Daiwa Fuego LT 1000D, 0.20mm/150m, 5.2:1, 6rul

d.10333.100
Livrare 24-48 ore

589,00Lei

Mulineta Daiwa Certate FC LT 2500D 0.28mm/150m, 5.2:1, 10rul

Mulineta Daiwa Certate FC LT 2500D 0.28mm/150m, 5.2:1, 10rul

d.10424.251
Livrare 24-48 ore

3.279,01Lei

Lanseta Daiwa Crosscast Carp Z 0312 3.05m, 3.5lbs, 2seg

Lanseta Daiwa Crosscast Carp Z 0312 3.05m, 3.5lbs, 2seg

d.cccz0312ax
Livrare 24-48 ore

740,37Lei

Jig Daiwa Micro Bladed, Muddy Orange, Nr.1/0, 8g

Jig Daiwa Micro Bladed, Muddy Orange, Nr.1/0, 8g

f.d15151.408
Livrare 24-48 ore

49,61Lei

Mulineta, DAIWA, 23, Revros, LT, 1000,, 0.14mm/150m,, 5.2:1,, 4rul, d.10221.102, Mulinete Rapitori, Mulinete Rapitori Daiwa, Mulinete Daiwa, Rapitori Daiwa, Daiwa
MULINETA DAIWA BLACK WIDOW BR LT 5000-C

MULINETA DAIWA BLACK WIDOW BR LT 5000-C

d.10149.500
Livrare imediată!

427,60Lei

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

VARF DAIWA PENTRU NINJA X FEEDER RED 50-150g

d.11606.001r
Livrare imediată!

29,33Lei

BLUZA DAIWA D-VEC BLUE MARIME L

BLUZA DAIWA D-VEC BLUE MARIME L

d.18299.330
Livrare 24-48 ore

240,26Lei

MULTIPLICATOR, DAIWA, TATULA, SV, TW, 103HL, 7RUL/90M/033/6,3:1, d.10714.100, Mulinete Casting, Mulinete Casting Daiwa, Daiwa
LINGURITA DAIWA ROTATIVA 6G SILVER GREEN

LINGURITA DAIWA ROTATIVA 6G SILVER GREEN

d.07410900
Livrare 24-48 ore

23,65Lei

BUFF DAIWA ASPHALT -20%

BUFF DAIWA ASPHALT

d.18206.104
Livrare 24-48 ore

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

TRICOU DAIWA CARP CAMO XL

TRICOU DAIWA CARP CAMO XL

d.18865.040
Livrare 24-48 ore

117,98Lei

Galeata Daiwa Advantage pentru Nada, 12l -20%

Galeata Daiwa Advantage pentru Nada, 12l

a.13305.305
Livrare imediată!

66,51Lei(-20%) 53,22Lei

Mulineta Daiwa Crossfire LT 2500 4BS A -17%

Mulineta Daiwa Crossfire LT 2500 4BS A

d.10186.250
Livrare imediată!

234,58Lei(-17%) 194,87Lei

MULINETA, DAIWA, CROSSCAST, 45SCW, 5000C, QD, d.10250.500, Mulinete Crap, Mulinete Crap Daiwa, Mulinete Daiwa, Crap Daiwa, Daiwa -15%

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

d.10250.500
Livrare imediată!

645,27Lei(-15%) 549,90Lei

Lanseta, Spinning, Daiwa, SweepFire, 2.70m,, 30-70g,, 2seg, d.11446.272, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Bluza UV Daiwa D-Vec LS Navy, Marime XL

Bluza UV Daiwa D-Vec LS Navy, Marime XL

d.18299.440
Livrare 24-48 ore

369,11Lei

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 180g, 3+2seg

Lanseta Daiwa N Zon Super Slim Power Carp Feeder 3.96m, 180g, 3+2seg

d.11164.390
Livrare imediată!

607,48Lei

Afişare 61 - 80 din 1475 (74 pagini)
Queries: 7, Total time: 94.739 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = '407fd6ee4ac3d2a7ffd2f5cbb3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.132)
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.710)
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 (54.397)
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.110)
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