Daiwa

Daiwa

Sortare după:

Shad Daiwa Prorex Slim Shady, Color Mix 1, 10.5cm, 8.0g, 4buc/pac

Shad Daiwa Prorex Slim Shady, Color Mix 1, 10.5cm, 8.0g, 4buc/pac

d.15100.700

Livrare 24-48 ore

27,19Lei

FIR MONOFILAMENT DAIWA SAMURAI TROUT 020MM 3.1KG 500M

FIR MONOFILAMENT DAIWA SAMURAI TROUT 020MM 3.1KG 500M

d.12812.020

Livrare 24-48 ore

24,81Lei(-25%) 18,65Lei

FIR TEXTIL DAIWA J-BRAID X4 0.07MM 2.6KG 135MT GALBEN

FIR TEXTIL DAIWA J-BRAID X4 0.07MM 2.6KG 135MT GALBEN

d.12740.007

Livrare imediată!

40,40Lei

Mulineta Daiwa Procaster EVO 4010

Mulineta Daiwa Procaster EVO 4010

d.prevo4010

Livrare 24-48 ore

364,02Lei

MONOFILAMENT DAIWA PROREX FC LEADER 0,26MM/4,8KG/50M

MONOFILAMENT DAIWA PROREX FC LEADER 0,26MM/4,8KG/50M

d.12995.026

Livrare imediată!

25,75Lei

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 145cm

Husa DAIWA D-Vec pentru 1 Lanseta cu Mulineta, Grey, 145cm

a8.15843.145

Livrare 24-48 ore

161,27Lei

SHAD DAIWA D.FIN 12.5CM/GREEN PEARL/5BUC/PL

SHAD DAIWA D.FIN 12.5CM/GREEN PEARL/5BUC/PL

d.16500.112

Livrare 24-48 ore

40,03Lei

Lansete Daiwa Legalis UL Spin 2.10m 3-15g

Lansete Daiwa Legalis UL Spin 2.10m 3-15g

d.11768.210

Livrare 24-48 ore

247,97Lei

Agrafa cu Vartej Daiwa Nr.4, 16kg, 10buc/pac

Agrafa cu Vartej Daiwa Nr.4, 16kg, 10buc/pac

a7.14905.204

Livrare 24-48 ore

8,99Lei

HUSA DAIWA BLACK WIDOW HOLDALL 3 LANSETE PLUS 3 MULINETE 200X40CM

HUSA DAIWA BLACK WIDOW HOLDALL 3 LANSETE PLUS 3 MULINETE 200X40CM

d.18705.012

Livrare 24-48 ore

389,08Lei

MULINETA DAIWA CALDIA LT 6RUL 1000S-P 0.12mm/100m

MULINETA DAIWA CALDIA LT 6RUL 1000S-P 0.12mm/100m

d.10412.105

Livrare 24-48 ore

1.222,75Lei(-39%) 746,99Lei

Lanseta Daiwa Tatula Baitcast 701MRBAF 2.13M 7-21g 1SEG

Lanseta Daiwa Tatula Baitcast 701MRBAF 2.13M 7-21g 1SEG

d.tat701mrbaf

Livrare 24-48 ore

726,96Lei(-19%) 592,42Lei

Muste DAIWA Fly Pack Buzzers, 10buc/pac

Muste DAIWA Fly Pack Buzzers, 10buc/pac

f3.dfc9

Livrare 24-48 ore

71,54Lei

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Scopex Natural (Maro) 30g/borcan

Dumbell Daiwa Critic Echilibrat Advantage Semi Buoyant 6/8mm Scopex Natural (Maro) 30g/borcan

a0.13300.102

Livrare 24-48 ore

31,07Lei

Lanseta Pastrav DAIWA Presso LTD AGS 510UL, 1.78m, 0.4-3g, 2seg

Lanseta Pastrav DAIWA Presso LTD AGS 510UL, 1.78m, 0.4-3g, 2seg

d.prsltdags510ul

Livrare 24-48 ore

2.099,12Lei

AGRAFA+VARTEJ DUBLU DAIWA N ZON NR.10

AGRAFA+VARTEJ DUBLU DAIWA N ZON NR.10

a7.13315.010

Livrare 24-48 ore

19,46Lei

MULINETA DAIWA AIRITY LT 3000D-C 8RUL 150MX023

MULINETA DAIWA AIRITY LT 3000D-C 8RUL 150MX023

d.10115.300

Livrare 24-48 ore

2.635,85Lei(-29%) 1.877,11Lei

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

Lanseta Daiwa Procyon Spin 2.05m 3-12g 2seg

d.11211.205

Livrare imediată!

505,09Lei

SAPCA DAIWA CLASSIQUE MESH BLACK

SAPCA DAIWA CLASSIQUE MESH BLACK

d.ca402446

Livrare 24-48 ore

46,69Lei

Fir Elastic Daiwa N Zon Power Gum 1.0mm 8kg 10m

Fir Elastic Daiwa N Zon Power Gum 1.0mm 8kg 10m

d.13306.001

Livrare 24-48 ore

20,64Lei

Afişare 1241 - 1260 din 1663 (84 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

Queries: 7, Total time: 130.419 ms [By time] [By id] [By file]

1 (0.129)

SELECT data
FROM `oc_session`
WHERE session_id = '5a4008a65d3d4c0bffc240b0a8'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.086)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.109)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Daiwa'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.104)

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 (53.875)

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:1699

6 (76.009)

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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 1240,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.107)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37