Korda


Tricou KORDA One Liner Tee Olive, Marime S

Tricou KORDA One Liner Tee Olive, Marime S

kc0115
Livrare 7-14 zile

134,95Lei

Fir KORDA BASIX COATED HOOKLINK 18LB/10M

Fir KORDA BASIX COATED HOOKLINK 18LB/10M

kbx010
Livrare imediată!

31,67Lei

Montura KORDA CHOD RIG SCURT NR.10/20LB 3BUC/PL

Montura KORDA CHOD RIG SCURT NR.10/20LB 3BUC/PL

kcr019
Livrare imediată!

34,44Lei

Guler KORDA FLEECE Negru

Guler KORDA FLEECE Negru

kcl762
Livrare imediată!

90,73Lei

Jacheta Fleece KORDA Kore Polar, Olive, Marime XL

Jacheta Fleece KORDA Kore Polar, Olive, Marime XL

kcl325
Livrare 7-14 zile

354,15Lei

Ochelari Korda Ronnie Black

Ochelari Korda Ronnie Black

k4d19
Livrare 7-14 zile

189,33Lei

Geanta KORDA Compac Cooler Bag Medium Dark Camo, 27x25x18cm, 12litri

Geanta KORDA Compac Cooler Bag Medium Dark Camo, 27x25x18cm, 12litri

klug104
Livrare 7-14 zile

259,81Lei

Salopeta Korda Polar, Olive, Marime L

Salopeta Korda Polar, Olive, Marime L

kcl486
Livrare 7-14 zile

565,92Lei

Jacheta KORDA Hybrid, Olive, Marime 2XL

Jacheta KORDA Hybrid, Olive, Marime 2XL

kcl791
Livrare 7-14 zile

471,73Lei

Lanseta KORDA Kaizen Green 3.90m/13ft, 4.00lbs, 2seg

Lanseta KORDA Kaizen Green 3.90m/13ft, 4.00lbs, 2seg

krd020
Livrare imediată!

905,85Lei

Hanorac KORDA Kore TK Hoodie, Dark Olive, Marime M

Hanorac KORDA Kore TK Hoodie, Dark Olive, Marime M

kcl098
Livrare 7-14 zile

305,79Lei

Bluza KORDA Thermal LS Shirt, Olive, Marime 2XL

Bluza KORDA Thermal LS Shirt, Olive, Marime 2XL

kcl310
Livrare 7-14 zile

204,31Lei

Tricou Korda Minimal Tee Black, Marimea 2XL

Tricou Korda Minimal Tee Black, Marimea 2XL

kcl520
Livrare 7-14 zile

153,46Lei

Atractant KORDA Supreme Goo, Frutti Di Mare, Rosu, 115ml

Atractant KORDA Supreme Goo, Frutti Di Mare, Rosu, 115ml

kgoo51
Livrare imediată!

95,15Lei

Salopeta KORDA Polar, Dark Kamo, Marimea 2XL

Salopeta KORDA Polar, Dark Kamo, Marimea 2XL

kcl851
Livrare 7-14 zile

641,45Lei

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

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

kcl780
Livrare 7-14 zile

356,64Lei

Tricou Korda Cut Tee, Negru, Marime S

Tricou Korda Cut Tee, Negru, Marime S

kcl907
Livrare 7-14 zile

153,46Lei

Carlige Legate KORDA Boom Spinner Hook, Barbless, Nr.4, 25lb, 2buc/pac

Carlige Legate KORDA Boom Spinner Hook, Barbless, Nr.4, 25lb, 2buc/pac

krr024
Livrare 7-14 zile

39,08Lei

Extensie Suport KORDA Singlez Spike

Extensie Suport KORDA Singlez Spike

ksing13
Livrare 7-14 zile

92,00Lei

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Gravel, 30lbs, 1m

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Gravel, 30lbs, 1m

ksz36
Livrare 7-14 zile

41,62Lei

Afişare 421 - 440 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: 95.793 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = '15426ef83a4767ef3eb24febce'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.138)
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 (36.370)
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 (58.695)
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 420,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.172)
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