Korda


Caciula Korda Olive, Marime Universala

Caciula Korda Olive, Marime Universala

kbh32
Livrare imediată!

76,30Lei

Pantaloni Scurti KORDA Chino, Olive, Marime M

Pantaloni Scurti KORDA Chino, Olive, Marime M

kcl666
Livrare 7-14 zile

236,41Lei

Salopeta Korda Polar, Olive, Marime M

Salopeta Korda Polar, Olive, Marime M

kcl485
Livrare 7-14 zile

565,92Lei

Jacheta KORDA Hybrid, Olive, Marime XL

Jacheta KORDA Hybrid, Olive, Marime XL

kcl790
Livrare 7-14 zile

471,73Lei

Lanseta KORDA Kaizen Green Spod 3.60m/12ft, 5.00lbs, 2seg

Lanseta KORDA Kaizen Green Spod 3.60m/12ft, 5.00lbs, 2seg

krd018
Livrare 7-14 zile

799,37Lei

Hanorac KORDA Kore TK Hoodie, Dark Olive, Marime S

Hanorac KORDA Kore TK Hoodie, Dark Olive, Marime S

kcl097
Livrare 7-14 zile

305,79Lei

Bluza KORDA Thermal LS Shirt, Olive, Marime XL

Bluza KORDA Thermal LS Shirt, Olive, Marime XL

kcl309
Livrare 7-14 zile

204,31Lei

Atractant KORDA Supreme Goo, Passionfruit, Galben, 115ml

Atractant KORDA Supreme Goo, Passionfruit, Galben, 115ml

kgoo50
Livrare imediată!

95,15Lei

Salopeta KORDA Polar, Dark Kamo, Marimea XL

Salopeta KORDA Polar, Dark Kamo, Marimea XL

kcl850
Livrare 7-14 zile

641,45Lei

Hanorac KORDA Kore TK Hoodie, Dark Kamo, Marime 2XL

Hanorac KORDA Kore TK Hoodie, Dark Kamo, Marime 2XL

kcl779
Livrare 7-14 zile

356,64Lei

Pantaloni KORDA Drykore Over Trouser MK2, Dark Olive, Marimea 4XL

Pantaloni KORDA Drykore Over Trouser MK2, Dark Olive, Marimea 4XL

kcl825
Livrare 7-14 zile

712,71Lei

Montura KORDA Hinge Rig Choddy, Barbless, Nr.8, 25lb, 1buc/pac

Montura KORDA Hinge Rig Choddy, Barbless, Nr.8, 25lb, 1buc/pac

kcr093
Livrare imediată!

21,30Lei

Varf Suport KORDA Singlez Spike

Varf Suport KORDA Singlez Spike

ksing12
Livrare 7-14 zile

112,34Lei

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Weedy Green, 30lbs, 1m

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Weedy Green, 30lbs, 1m

ksz35
Livrare 7-14 zile

38,74Lei

Fir Monofilament KORDA Touchdown, Green, 12lbs/0.35mm, 1000m

Fir Monofilament KORDA Touchdown, Green, 12lbs/0.35mm, 1000m

ktdg12
Livrare 7-14 zile

143,30Lei

Husa KORDA Compac Gas Canister Jacket, Dark Kamo, 11x11x15cm

Husa KORDA Compac Gas Canister Jacket, Dark Kamo, 11x11x15cm

klug112
Livrare 7-14 zile

97,55Lei

PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

kpb41
Livrare imediată!

22,16Lei

Scaun KORDA Compac Low, Olive,60x72x72cm

Scaun KORDA Compac Low, Olive,60x72x72cm

klug82
Livrare 7-14 zile

382,05Lei

Tricou KORDA Mandala Tee Black, Marime 2XL

Tricou KORDA Mandala Tee Black, Marime 2XL

a8.kc0070
Livrare 24-48 ore

144,90Lei

CARLIG KORDA BASIX WIDE GAPE NR.6 10BUC/PL

CARLIG KORDA BASIX WIDE GAPE NR.6 10BUC/PL

kbx003
Livrare imediată!

18,86Lei

Afişare 241 - 260 din 1627 (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: 118.987 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = '793fa4307c9bdd8e9b60a15bde'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.124)
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 (46.647)
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 (71.687)
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 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.125)
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