Korda


Bluza KORDA Thermal LS Shirt, Olive, Marime XL

Bluza KORDA Thermal LS Shirt, Olive, Marime XL

kcl309
Livrare 7-14 zile

204,31Lei

Atractant KORDA Supreme Goo, Passionfruit, Galben, 115ml

Atractant KORDA Supreme Goo, Passionfruit, Galben, 115ml

kgoo50
Livrare imediată!

95,15Lei

Salopeta KORDA Polar, Dark Kamo, Marimea XL

Salopeta KORDA Polar, Dark Kamo, Marimea XL

kcl850
Livrare 7-14 zile

641,45Lei

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

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

kcl779
Livrare 7-14 zile

356,64Lei

Pantaloni KORDA Drykore Over Trouser MK2, Dark Olive, Marimea 4XL

Pantaloni KORDA Drykore Over Trouser MK2, Dark Olive, Marimea 4XL

kcl825
Livrare 7-14 zile

712,71Lei

Montura KORDA Hinge Rig Choddy, Barbless, Nr.8, 25lb, 1buc/pac

Montura KORDA Hinge Rig Choddy, Barbless, Nr.8, 25lb, 1buc/pac

kcr093
Livrare imediată!

21,30Lei

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

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

krd007
Livrare 7-14 zile

3.198,86Lei

Buzz Bar KORDA Singlez, 3 Posturi, 8.5inch/21cm

Buzz Bar KORDA Singlez, 3 Posturi, 8.5inch/21cm

ksing07
Livrare 7-14 zile

234,36Lei

Porumb Artificial KORDA Slow Sinking Maize, Fruity Pink, 10buc/pac

Porumb Artificial KORDA Slow Sinking Maize, Fruity Pink, 10buc/pac

kpb11
Livrare imediată!

23,82Lei

Husa Lansete cu Mulineta KORDA Compac, 3 Lansete, Dark Camo, 12ft/3.60m

Husa Lansete cu Mulineta KORDA Compac, 3 Lansete, Dark Camo, 12ft/3.60m

klug101
Livrare 7-14 zile

687,09Lei

Geanta Accesorii KORDA Compac Carry Cube, Olive, 40x40x30cm, 30ltr

Geanta Accesorii KORDA Compac Carry Cube, Olive, 40x40x30cm, 30ltr

klug62
Livrare 7-14 zile

534,57Lei

Minciog KORDA Spring Bow 5ft + 5ft Net, 42inch/106cm

Minciog KORDA Spring Bow 5ft + 5ft Net, 42inch/106cm

kln015
Livrare 7-14 zile

1.869,95Lei

CARLIG KORDA BASIX WIDE GAPE NR.8 10BUC/PL

CARLIG KORDA BASIX WIDE GAPE NR.8 10BUC/PL

kbx004
Livrare imediată!

18,86Lei

HUSA KORDA COMPAC PENTRU BANKSTICK

HUSA KORDA COMPAC PENTRU BANKSTICK

klug60
Livrare 7-14 zile

106,65Lei

Vesta KORDA Kore Fleece, Olive, Marime S

Vesta KORDA Kore Fleece, Olive, Marime S

kcl594
Livrare 7-14 zile

229,78Lei

Pantaloni Lungi KORDA Lite Joggers, Light Kamo, Marime XL -27%

Pantaloni Lungi KORDA Lite Joggers, Light Kamo, Marime XL

kcl397
Livrare imediată!

299,75Lei(-27%) 219,51Lei

SET CANA KORDA COMPAC TEA 2PCS

SET CANA KORDA COMPAC TEA 2PCS

klug12
Livrare imediată!

178,89Lei

Tricou Korda Kore Dark Kamo, Marime L

Tricou Korda Kore Dark Kamo, Marime L

kcl727
Livrare 7-14 zile

151,66Lei

Husa Picheti Masurare Distanta Korda Compac Camo

Husa Picheti Masurare Distanta Korda Compac Camo

klug123
Livrare 7-14 zile

76,33Lei

Husa Korda Distance Compac, Camo

Husa Korda Distance Compac, Camo

klug63
Livrare 7-14 zile

83,99Lei

Afişare 361 - 380 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: 89.932 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = 'd39075075c0bf9fd0046bb7890'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.105)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.157)
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 (36.839)
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.428)
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 360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.182)
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