Korda


Hanorac KORDA Kore Zip Pro, Olive, Marime L

Hanorac KORDA Kore Zip Pro, Olive, Marime L

kcl751
Livrare imediată!

307,70Lei

Vesta KORDA Kore Fleece, Black, Marime 2XL

Vesta KORDA Kore Fleece, Black, Marime 2XL

kcl604
Livrare 7-14 zile

229,78Lei

Caciula Korda Negru, Marime Universala

Caciula Korda Negru, Marime Universala

kbh33
Livrare imediată!

76,30Lei

Tricou Korda Tie Dye Slate Grey, Marime XL

Tricou Korda Tie Dye Slate Grey, Marime XL

kcl499
Livrare 7-14 zile

142,22Lei

Salopeta KORDA Polar, Olive, Marime S

Salopeta KORDA Polar, Olive, Marime S

kcl484
Livrare 7-14 zile

565,92Lei

Jacheta KORDA Hybrid, Olive, Marime L

Jacheta KORDA Hybrid, Olive, Marime L

kcl789
Livrare imediată!

471,73Lei

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

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

krd017
Livrare 7-14 zile

799,37Lei

Pantaloni KORDA Kore Original Kombats, Olive, Marime M

Pantaloni KORDA Kore Original Kombats, Olive, Marime M

kcl074
Livrare 7-14 zile

382,05Lei

Tricou KORDA Tie Dye Tee, Dark Olive, Marime XL

Tricou KORDA Tie Dye Tee, Dark Olive, Marime XL

kcl493
Livrare 7-14 zile

153,46Lei

Palarie KORDA Fleece Waterproof Boonie, Olive

Palarie KORDA Fleece Waterproof Boonie, Olive

kbh21
Livrare 7-14 zile

128,05Lei

Bluza UV KORDA Kool UPF Zip Jersey, Dark Kamo, Marimea S

Bluza UV KORDA Kool UPF Zip Jersey, Dark Kamo, Marimea S

kcl949
Livrare 7-14 zile

222,34Lei

Tricou Korda Kore Dark Kamo, Marime 3XL

Tricou Korda Kore Dark Kamo, Marime 3XL

kcl730
Livrare 7-14 zile

163,64Lei

Jacheta KORDA Drykore MK2, Dark Kamo, Marimea XL

Jacheta KORDA Drykore MK2, Dark Kamo, Marimea XL

kcl815
Livrare 7-14 zile

1.017,76Lei

Lanseta KORDA Kaizen Platinum 12.6ft/3.66m, 4.00lbs, 2seg

Lanseta KORDA Kaizen Platinum 12.6ft/3.66m, 4.00lbs, 2seg

krd005
Livrare 7-14 zile

2.842,97Lei

Buzz Bar KORDA Singlez, 3 Posturi, 10.5inch/26cm

Buzz Bar KORDA Singlez, 3 Posturi, 10.5inch/26cm

ksing05
Livrare 7-14 zile

234,36Lei

Plumb Culisant KORDA Solidz Inline Pva, 168g, 1buc/pac

Plumb Culisant KORDA Solidz Inline Pva, 168g, 1buc/pac

sol6
Livrare 7-14 zile

18,74Lei

Saltea Receptie KORDA Compac Hybrid Mat, Dark Kamo, 125x85x14cm

Saltea Receptie KORDA Compac Hybrid Mat, Dark Kamo, 125x85x14cm

klug46
Livrare 7-14 zile

865,23Lei

Tricou KORDA Mandala Tee Black, Marime XL

Tricou KORDA Mandala Tee Black, Marime XL

a8.kc0069
Livrare 24-48 ore

144,90Lei

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

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

kbx026
Livrare imediată!

16,56Lei

Jacheta KORDA Kore Thermolite, Black, Marime S

Jacheta KORDA Kore Thermolite, Black, Marime S

kcl466
Livrare 7-14 zile

721,70Lei

Afişare 201 - 220 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.558 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '793fa4307c9bdd8e9b60a15bde'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.091)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
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 (48.427)
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 (69.617)
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 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.129)
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