Korda

Korda

Sortare după:

Pantaloni KORDA Kore Polar Kombats, Olive, Marime 3XL

Pantaloni KORDA Kore Polar Kombats, Olive, Marime 3XL

kcl090

Livrare 7-14 zile

458,05Lei

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME XL

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME XL

kcl734

Livrare 7-14 zile

152,21Lei

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime 3XL

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime 3XL

kcl447

Livrare 7-14 zile

356,64Lei

TRICOU KORDA LE DISTRESSED LOGO TEE OLIVE MARIME S

a8.kcl713

Livrare imediată!

128,80Lei(-20%) 102,58Lei

Pantalon KORDA Kore, Olive, Marime L

Pantalon KORDA Kore, Olive, Marime L

kcl189

Livrare 7-14 zile

236,41Lei

Carlige Korda Long Shank X Nr.6

Carlige Korda Long Shank X Nr.6

klsx6

Livrare 7-14 zile

33,90Lei

CIORAPI KORDA KORE DIN LANA OLIVE, MARIME 10-12UK / 45-47EU

CIORAPI KORDA KORE DIN LANA OLIVE, MARIME 10-12UK / 45-47EU

a8.kcl319

Livrare imediată!

102,20Lei(-21%) 80,92Lei

Pantaloni KORDA Kore Polar Kombats, Olive, Marime M

Pantaloni KORDA Kore Polar Kombats, Olive, Marime M

kcl086

Livrare 7-14 zile

458,31Lei

PANTALON KORDA JOGGER LIGHT KAMO MARIME S

PANTALON KORDA JOGGER LIGHT KAMO MARIME S

kcl472

Livrare 7-14 zile

307,88Lei

Korda Big Eye Swivel

Korda Big Eye Swivel

kbes

Livrare imediată!

25,91Lei

Pantalon KORDA Kore Heavy, Dark Kamo, Marime XL

Pantalon KORDA Kore Heavy, Dark Kamo, Marime XL

kcl838

Livrare 7-14 zile

306,86Lei

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME XXL

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME XXL

kcl735

Livrare 7-14 zile

152,16Lei

Korda Croseta Fine Mov

Korda Croseta Fine Mov

kbnf

Livrare imediată!

24,03Lei

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime S

Hanorac KORDA Kore TK Hoodie, Light Kamo, Marime S

kcl442

Livrare 7-14 zile

331,52Lei

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME S

TRICOU KORDA LE KAMO PRO TEE OLIVE MARIME S

kcl731

Livrare 7-14 zile

152,21Lei

Pantalon KORDA Kore, Olive, Marime XL

Pantalon KORDA Kore, Olive, Marime XL

kcl190

Livrare 7-14 zile

236,41Lei

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

Pantaloni KORDA Kore Polar Kombats, Olive, Marime L

Pantaloni KORDA Kore Polar Kombats, Olive, Marime L

kcl087

Livrare 7-14 zile

458,05Lei

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime S

Hanorac KORDA Zip Hoodie, Dark Kamo, Marime S

kcl983

Livrare 7-14 zile

349,48Lei

Korda Rubber Bead 4mm

Korda Rubber Bead 4mm

k4rbb

Livrare imediată!

19,80Lei

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

1 (0.134)

SELECT data
FROM `oc_session`
WHERE session_id = '1b509b99c8a03b2aa43cb00ee5'

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

2 (0.066)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.095)

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

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

4 (0.104)

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

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

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

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

7 (0.128)

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