Korda

Korda

Sortare după:

CIORAPI KORDA KORE DIN LANA BLACK MAR.7-9UK

CIORAPI KORDA KORE DIN LANA BLACK MAR.7-9UK

kcl320

Livrare 7-14 zile

104,91Lei

Korda Vartej Nr.8

Korda Vartej Nr.8

ks20

Livrare imediată!

28,91Lei

Pantaloni KORDA Kore Original Kombats, Olive, Marime 2XL

Pantaloni KORDA Kore Original Kombats, Olive, Marime 2XL

kcl077

Livrare 7-14 zile

353,99Lei

Pantalon KORDA Kore Heavy, Dark Kamo, Marime XL

Pantalon KORDA Kore Heavy, Dark Kamo, Marime XL

kcl838

Livrare 7-14 zile

306,86Lei

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime M

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime M

kcl443

Livrare 7-14 zile

331,52Lei

Pantalon KORDA Kore, Olive, Marime XL

Pantalon KORDA Kore, Olive, Marime XL

kcl190

Livrare 7-14 zile

236,41Lei

Pantaloni KORDA Kore Polar Kombats, Olive, Marime XL

Pantaloni KORDA Kore Polar Kombats, Olive, Marime XL

kcl088

Livrare 7-14 zile

458,05Lei

CIORAPI KORDA KORE DIN LANA BLACK MARIME 10-12UK

CIORAPI KORDA KORE DIN LANA BLACK MARIME 10-12UK

kcl321

Livrare 7-14 zile

104,91Lei

Korda Big Eye Swivel

Korda Big Eye Swivel

kbes

Livrare imediată!

25,91Lei

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime S

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime S

kcl983

Livrare 7-14 zile

349,48Lei

Pantalon KORDA Kore Heavy, Dark Kamo, Marime 2XL

Pantalon KORDA Kore Heavy, Dark Kamo, Marime 2XL

kcl839

Livrare 7-14 zile

306,86Lei

Korda Croseta Fine Mov

Korda Croseta Fine Mov

kbnf

Livrare imediată!

24,03Lei

Carlige Korda Long Shank X Nr.6

Carlige Korda Long Shank X Nr.6

klsx6

Livrare 7-14 zile

33,90Lei

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime XL

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime XL

kcl445

Livrare 7-14 zile

331,52Lei

Pantalon KORDA Kore, Olive, Marime 2XL

Pantalon KORDA Kore, Olive, Marime 2XL

kcl191

Livrare 7-14 zile

236,41Lei

Pantaloni KORDA Kore Polar Kombats, Olive, Marime 2XL

Pantaloni KORDA Kore Polar Kombats, Olive, Marime 2XL

kcl089

Livrare 7-14 zile

458,05Lei

Pantalon KORDA Kore Heavy, Dark Kamo, Marime S

Pantalon KORDA Kore Heavy, Dark Kamo, Marime S

kcl835

Livrare 7-14 zile

331,21Lei

Korda Rubber Bead 4mm

Korda Rubber Bead 4mm

k4rbb

Livrare imediată!

19,80Lei

TRICOU KORDA LE DISTRESSED LOGO TEE OLIVE MARIME XL

kcl716

Livrare imediată!

133,26Lei

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime 3XL

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime 3XL

kcl988

Livrare 7-14 zile

377,17Lei

Afişare 1601 - 1620 din 1637 (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: 136.292 ms [By time] [By id] [By file]

1 (0.093)

SELECT data
FROM `oc_session`
WHERE session_id = '9599e1d5e2f01c5e03f96d0f81'

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

2 (0.102)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.116)

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

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

4 (0.121)

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

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

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 1600,20

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

7 (0.152)

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