Korda


JACHETA KORDA KORE THERMOLITE Negru MAR.XL

JACHETA KORDA KORE THERMOLITE Negru MAR.XL

a8.kcl469
Livrare 24-48 ore

708,79Lei

PANTALONI LUNGI KORDA LITE JOGGERS LIGHT KAMO MARIME XL -23%

PANTALONI LUNGI KORDA LITE JOGGERS LIGHT KAMO MARIME XL

a8.kcl397
Livrare imediată!

278,63Lei(-23%) 214,90Lei

GEANTA, KORDA, COMPAC, COOKWARE, a8.klug68, Genti Universale, Genti Universale Korda, Genti Korda, Universale Korda, Korda
Protectie Vant Wind Shield Korda Large

Protectie Vant Wind Shield Korda Large

a.kda007
Livrare 24-48 ore

148,16Lei

Pantaloni Scurti Korda Kore Quick Dry Olive, Marime M

Pantaloni Scurti Korda Kore Quick Dry Olive, Marime M

a8.kcl654
Livrare 24-48 ore

185,25Lei

Caciula Korda, Burgundy, Marime Universala

Caciula Korda, Burgundy, Marime Universala

a8.kbh34
Livrare imediată!

74,07Lei

Carlige, Legate, Korda, Boom, Spinner, Hook, 4,, 25lb,, 2buc/pac, a.krr021, Monturi Crap, Monturi Crap Korda, Monturi Korda, Crap Korda, Korda
PORUMB ARTIFICIAL KORDA POP UP MAIZE CITRUS ZING LIME 10BUC/PLIC

PORUMB ARTIFICIAL KORDA POP UP MAIZE CITRUS ZING LIME 10BUC/PLIC

a.kpb42
Livrare imediată!

19,87Lei

Cana Korda Logo Black

Cana Korda Logo Black

a.klug15
Livrare imediată!

39,45Lei

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.M

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.M

a8.kcl425
Livrare 24-48 ore

632,16Lei

KIT ANTISEPTIC KORDA CARP CARE 30ML

KIT ANTISEPTIC KORDA CARP CARE 30ML

a.kcc4
Livrare 24-48 ore

106,65Lei

PANTALONI LUNGI KORDA LITE JOGGERS LIGHT KAMO MARIME S

PANTALONI LUNGI KORDA LITE JOGGERS LIGHT KAMO MARIME S

a8.kcl394
Livrare imediată!

278,63Lei

Tricou, Korda, Kore, Dark, Kamo,, Marime, S, a8.kcl725, Tricouri, Tricouri Korda, Korda

Tricou, Korda, Kore, Dark, Kamo,, Marime, S, a8.kcl725, Tricouri, Tricouri Korda, Korda

a8.kcl725
Livrare 24-48 ore

148,17Lei

Tricou Korda Birdnest Tee, Dark Olive, Marime S

Tricou Korda Birdnest Tee, Dark Olive, Marime S

a8.kcl931
Livrare 24-48 ore

138,88Lei

TRICOU KORDA LIGHT KAMO, MAR.S -23%

TRICOU KORDA LIGHT KAMO, MAR.S

a8.kcl352
Livrare imediată!

148,65Lei(-23%) 114,89Lei

JACHETA KORDA KORE DRYKORE BLACK MARIME S

JACHETA KORDA KORE DRYKORE BLACK MARIME S

a8.kcl406
Livrare 24-48 ore

879,64Lei

Atractant, Lichid, KORDA, Goo,, Honey, Supreme,, 115ml, a0.goo47, Aditivi Lichizi / Arome / Dip-uri, Aditivi Lichizi / Arome / Dip-uri Korda, Aditivi Korda, Lichizi Korda, Arome Korda, Dip-uri Korda, Korda
Ochelari Korda Ronnie Brown

Ochelari Korda Ronnie Brown

a8.k4d20
Livrare 24-48 ore

185,22Lei

Husa Korda Distance Compac, Camo

Husa Korda Distance Compac, Camo

a8.klug63
Livrare 24-48 ore

81,62Lei

KORDA GEANTA COMPAC MAR.M

KORDA GEANTA COMPAC MAR.M

a8.klug30
Livrare imediată!

416,62Lei

Afişare 121 - 140 din 704 (36 pagini)
Queries: 7, Total time: 69.207 ms [By time] [By id] [By file]
1 (0.379)
SELECT data
FROM `oc_session`
WHERE session_id = '6b9661013ac81b037b9858bb35'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.109)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.152)
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 (29.430)
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:1667
6 (38.953)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.098)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38