Korda


Montura Leadcore cu Vartej Rapid KORDA Kable QC Swivel, Gravel, 50cm, 3buc/pac

Montura Leadcore cu Vartej Rapid KORDA Kable QC Swivel, Gravel, 50cm, 3buc/pac

kll009
Livrare 7-14 zile

38,62Lei

Jacheta KORDA Insulated Hooded, Darke Olive, Marime XL

Jacheta KORDA Insulated Hooded, Darke Olive, Marime XL

kcl772
Livrare 7-14 zile

438,00Lei

Atractant KORDA Almond Smoke Goo, 115ml

Atractant KORDA Almond Smoke Goo, 115ml

kgoo11
Livrare imediată!

95,15Lei

Hanorac KORDA Lightweight Hoodie, Olive, Marime 2XL

Hanorac KORDA Lightweight Hoodie, Olive, Marime 2XL

kcl197
Livrare 7-14 zile

255,15Lei

Salopeta KORDA Polar, Olive, Marime 3XL

Salopeta KORDA Polar, Olive, Marime 3XL

kcl489
Livrare 7-14 zile

610,83Lei

Fir KORDA Unwaxed Bait Floss, 30m

Fir KORDA Unwaxed Bait Floss, 30m

kbfu
Livrare imediată!

34,00Lei

Bluza UV KORDA Kool UPF Zip Jersey, Dark Olive, Marimea XL

Bluza UV KORDA Kool UPF Zip Jersey, Dark Olive, Marimea XL

kcl844
Livrare 7-14 zile

204,31Lei

Pantaloni Scurti KORDA Chino, Olive, Marime L

Pantaloni Scurti KORDA Chino, Olive, Marime L

kcl667
Livrare 7-14 zile

255,15Lei

Jacheta KORDA Drykore MK2, Dark Olive, Marimea 4XL

Jacheta KORDA Drykore MK2, Dark Olive, Marimea 4XL

kcl811
Livrare 7-14 zile

941,50Lei

Montura KORDA N Trap KD Rig Kurv, Barbless, Nr.8, 15lb, 1buc/pac

Montura KORDA N Trap KD Rig Kurv, Barbless, Nr.8, 15lb, 1buc/pac

kcr048
Livrare 7-14 zile

19,76Lei

Montura KORDA N Trap KD Rig Kurv, Barbless, Nr.2, 20lb, 1buc/pac

Montura KORDA N Trap KD Rig Kurv, Barbless, Nr.2, 20lb, 1buc/pac

kcr144
Livrare 7-14 zile

19,76Lei

Lanseta KORDA Kaizen Platinum 12ft/3.60m, 3.00lbs, 2seg

Lanseta KORDA Kaizen Platinum 12ft/3.60m, 3.00lbs, 2seg

krd001
Livrare 7-14 zile

2.537,93Lei

Carlige KORDA Spinner Nr.8, Barbless, 10buc/pac

Carlige KORDA Spinner Nr.8, Barbless, 10buc/pac

ksprb8
Livrare 7-14 zile

36,54Lei

Fir Monofilament KORDA Subline, Green, 15b/0.40mm, 1000m

Fir Monofilament KORDA Subline, Green, 15b/0.40mm, 1000m

sub15g
Livrare imediată!

143,30Lei

Carlige KORDA Long Shank Beaked, Barbless, Nr.8, 10buc/pac

Carlige KORDA Long Shank Beaked, Barbless, Nr.8, 10buc/pac

klsbb8
Livrare 7-14 zile

36,54Lei

Geanta Termoizolanta KORDA Compac Cooler, 20ltr

Geanta Termoizolanta KORDA Compac Cooler, 20ltr

klug28
Livrare 7-14 zile

661,66Lei

SAPCA KORDA SNAPBACK KAMO

SAPCA KORDA SNAPBACK KAMO

kbc22
Livrare imediată!

90,73Lei

Carlige KORDA Straight Point Hook Micro Barbed Nr.6, 10buc/pac

Carlige KORDA Straight Point Hook Micro Barbed Nr.6, 10buc/pac

k.ksph6
Livrare 24-48 ore

45,52Lei

Tricou KORDA Mandala Tee Black, Marime M

Tricou KORDA Mandala Tee Black, Marime M

a8.kc0067
Livrare 24-48 ore

144,90Lei

Montura KORDA BASIX WIDE GAPE 8/18LB 2BUC/PL

Montura KORDA BASIX WIDE GAPE 8/18LB 2BUC/PL

kbx016
Livrare 7-14 zile

19,84Lei

Afişare 501 - 520 din 1636 (82 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: 97.840 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = 'ed9309149294b008d497a47aca'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.172)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.093)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (41.509)
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 = '73'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (55.651)
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 = '0' AND p.manufacturer_id = '73' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.203)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37