Korda


Anou KORDA PT RIG Marime L 20BUC/PL

Anou KORDA PT RIG Marime L 20BUC/PL

krrl
Livrare imediată!

26,93Lei

GEANTA KORDA COMPAC GOO MAR.S

GEANTA KORDA COMPAC GOO MAR.S

klug42
Livrare 7-14 zile

113,98Lei

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.5, 25lb, 2buc/pac

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

krr025
Livrare 7-14 zile

39,08Lei

Stabilizator KORDA Singlez Ball Stabiliser

Stabilizator KORDA Singlez Ball Stabiliser

ksing14
Livrare 7-14 zile

153,00Lei

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

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

ksz37
Livrare 7-14 zile

41,62Lei

Fir Monofilament KORDA Touchdown, Brown, 20lbs/0.43mm, 1000m

Fir Monofilament KORDA Touchdown, Brown, 20lbs/0.43mm, 1000m

ktdb20
Livrare 7-14 zile

143,30Lei

MONTURA KORDA N-TRAP KD KURV NR.8/15LB

MONTURA KORDA N-TRAP KD KURV NR.8/15LB

kcr045
Livrare imediată!

18,39Lei

Afişare 521 - 540 din 1636 (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: 90.806 ms [By time] [By id] [By file]
1 (0.098)
SELECT data
FROM `oc_session`
WHERE session_id = 'ed9309149294b008d497a47aca'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.131)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.145)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
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 (37.186)
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 (52.932)
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 520,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.179)
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