Korda

Korda

Sortare după:

Plumb KORDA Heli Lead, 2oz/56g, 1buc/pac

Plumb KORDA Heli Lead, 2oz/56g, 1buc/pac

khl2

Livrare 7-14 zile

13,66Lei

PLUMB KORDA BIG GRIPPA CU VARTEJ 84G

PLUMB KORDA BIG GRIPPA CU VARTEJ 84G

kbgb3

Livrare imediată!

20,13Lei

Plumb Inline KORDA Flatliner Pear Inline, 3.5oz/98g, 1buc/pac

Plumb Inline KORDA Flatliner Pear Inline, 3.5oz/98g, 1buc/pac

fpi35

Livrare 7-14 zile

15,19Lei

Montura KORDA Spinner Rig Krank Boom, Barbed, Nr.6, 25lb, 1buc/pac

Montura KORDA Spinner Rig Krank Boom, Barbed, Nr.6, 25lb, 1buc/pac

kcr147

Livrare imediată!

18,39Lei

Cutie Multifunctionala Accesorii Korda Basix

Cutie Multifunctionala Accesorii Korda Basix

kbx024

Livrare imediată!

138,99Lei

Vartej cu Anou Korda PTFE, Nr.8, 8buc/plic

Vartej cu Anou Korda PTFE, Nr.8, 8buc/plic

kmw002

Livrare imediată!

33,92Lei

Pelete Korda Pop Up Dumbell 12mm Fish 8buc/plic

Pelete Korda Pop Up Dumbell 12mm Fish 8buc/plic

kpb09

Livrare 7-14 zile

22,16Lei

Baton Pluta KORDA Cork Stick 4mm, 10buc/pac

Baton Pluta KORDA Cork Stick 4mm, 10buc/pac

krt005

Livrare 7-14 zile

36,40Lei

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.65mm, 15.90kg

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.65mm, 15.90kg

kboom65

Livrare imediată!

71,60Lei

Line Aligner KORDA D-Rig Kicker, Brown, Marime XL, pentru Carlige Nr. 1-2, 10buc/pac

Line Aligner KORDA D-Rig Kicker, Brown, Marime XL, pentru Carlige Nr. 1-2, 10buc/pac

kick28

Livrare 7-14 zile

34,00Lei

Sac Uscare Boilies KORDA Compac Air Dry Bag, Marime S

Sac Uscare Boilies KORDA Compac Air Dry Bag, Marime S

klug09

Livrare 7-14 zile

87,37Lei

Plumb KORDA COG Flat Distance, 4oz/112g

Plumb KORDA COG Flat Distance, 4oz/112g

cogd4

Livrare imediată!

16,20Lei

FIR KORDA TOUCHDOWN 0,35MM/12LB/1000M

FIR KORDA TOUCHDOWN 0,35MM/12LB/1000M

ktdb12

Livrare 7-14 zile

129,78Lei

Montura KORDA Krank Ready Rig, Barbless, Nr.10, 30lbs, 1buc/pac

Montura KORDA Krank Ready Rig, Barbless, Nr.10, 30lbs, 1buc/pac

kcr081

Livrare 7-14 zile

19,76Lei

RECIPIENT KORDA MIC PT DIPUIRE BOILIES INFUZA

RECIPIENT KORDA MIC PT DIPUIRE BOILIES INFUZA

kinzs

Livrare imediată!

36,43Lei

Fir Fluorocarbon KORDA Kontour, Trasparent, 0.37mm, 200m

Fir Fluorocarbon KORDA Kontour, Trasparent, 0.37mm, 200m

kflu03

Livrare 7-14 zile

153,46Lei

BANDA PVA SOLUBIL KORDA 3MM/5M/ROLA

BANDA PVA SOLUBIL KORDA 3MM/5M/ROLA

kpt

Livrare imediată!

31,57Lei

Carlige KORDA MIXA NR.10 10BUC/PLIC

Carlige KORDA MIXA NR.10 10BUC/PLIC

kmh10

Livrare imediată!

33,90Lei

CARLIG KORDA KRANK X NR.2 10BUC/PL

CARLIG KORDA KRANK X NR.2 10BUC/PL

kkrx2

Livrare imediată!

33,90Lei

Montura cu Vartej Rapid KORDA Dark Matter Leader QC Swivel, Weed, 30lbs, 50cm

Montura cu Vartej Rapid KORDA Dark Matter Leader QC Swivel, Weed, 30lbs, 50cm

ksz71

Livrare 7-14 zile

36,54Lei

Afişare 1321 - 1340 din 1641 (83 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: 142.626 ms [By time] [By id] [By file]

1 (0.090)

SELECT data
FROM `oc_session`
WHERE session_id = '34c295153fd0582cd427ca7447'

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

2 (0.093)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.107)

SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'

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

4 (0.103)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '73' AND m2s.store_id = '2'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (68.956)

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 = '73'

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

6 (73.154)

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 = '73' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1320,20

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

7 (0.123)

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