Korda


Geanta Buzz Bar KORDA Compac, Large, Dark Kamo, 40x17x8cm

Geanta Buzz Bar KORDA Compac, Large, Dark Kamo, 40x17x8cm

klug108
Livrare 7-14 zile

168,72Lei

Geanta Termoizolanta KORDA Compac Cooler Kamo, 14ltr

Geanta Termoizolanta KORDA Compac Cooler Kamo, 14ltr

klug74
Livrare 7-14 zile

737,93Lei

Jaketa KORDA Kore Drykore, Olive, Marime M

Jaketa KORDA Kore Drykore, Olive, Marime M

kcl401
Livrare imediată!

895,42Lei

Plumb Tungsten Korda Dark Matter Balancing 0.35g

Plumb Tungsten Korda Dark Matter Balancing 0.35g

kdmw03
Livrare imediată!

33,84Lei

Tricou KORDA One Liner Tee Black, Marime 2XL

Tricou KORDA One Liner Tee Black, Marime 2XL

kc0112
Livrare 7-14 zile

134,95Lei

Hanorac KORDA Kore Zip Pro, Olive, Marime M

Hanorac KORDA Kore Zip Pro, Olive, Marime M

kcl750
Livrare imediată!

307,70Lei

Vesta KORDA Kore Fleece, Black, Marime L

Vesta KORDA Kore Fleece, Black, Marime L

kcl602
Livrare 7-14 zile

229,78Lei

ATRACTANT KORDA GOO DRAGON S BREATH SUPREME 115ML

ATRACTANT KORDA GOO DRAGON S BREATH SUPREME 115ML

kgoo46
Livrare imediată!

95,15Lei

Husa Lanseta cu Mulineta Korda Compac 5 Camo, 3.90m

Husa Lanseta cu Mulineta Korda Compac 5 Camo, 3.90m

klug116
Livrare 7-14 zile

801,41Lei

Atractant Lichid KORDA Goo, Tropical Supreme, 115ml

Atractant Lichid KORDA Goo, Tropical Supreme, 115ml

kgoo53
Livrare imediată!

95,15Lei

Carlige KORDA Spinner Nr.7, 10buc/pac

Carlige KORDA Spinner Nr.7, 10buc/pac

kspr7
Livrare imediată!

33,90Lei

Pantaloni KORDA Kore Original Kombats, Olive, Marime S

Pantaloni KORDA Kore Original Kombats, Olive, Marime S

kcl073
Livrare 7-14 zile

382,05Lei

Hanorac KORDA Lightweight Hoodie, Black, Marime 3XL

Hanorac KORDA Lightweight Hoodie, Black, Marime 3XL

kcl204
Livrare 7-14 zile

237,17Lei

Tricou KORDA Tie Dye Tee, Dark Olive, Marime L

Tricou KORDA Tie Dye Tee, Dark Olive, Marime L

kcl492
Livrare 7-14 zile

153,46Lei

Caciula KORDA Fishermen Beanie, Burgundy

Caciula KORDA Fishermen Beanie, Burgundy

kbh19
Livrare 7-14 zile

87,37Lei

Bluza UV KORDA Kool UPF Zip Jersey, Dark Olive, Marimea 4XL

Bluza UV KORDA Kool UPF Zip Jersey, Dark Olive, Marimea 4XL

kcl618
Livrare 7-14 zile

204,31Lei

Pantaloni Scurti KORDA Chino, Olive, Marime 3XL

Pantaloni Scurti KORDA Chino, Olive, Marime 3XL

kcl670
Livrare 7-14 zile

255,15Lei

Jacheta KORDA Drykore MK2, Dark Kamo, Marimea L

Jacheta KORDA Drykore MK2, Dark Kamo, Marimea L

kcl814
Livrare 7-14 zile

1.017,76Lei

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

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

krd003
Livrare 7-14 zile

2.639,62Lei

Buzz Bar KORDA Singlez, 3 Posturi, 11.5inch/29cm

Buzz Bar KORDA Singlez, 3 Posturi, 11.5inch/29cm

ksing04
Livrare 7-14 zile

234,36Lei

Afişare 221 - 240 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: 143.225 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '2e06c20bc5a71231712b033847'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.182)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.155)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.123)
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.126)
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 (76.391)
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 220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.137)
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