Korda


Pantaloni KORDA Drykore Over Trouser MK2, Dark Olive, Marimea L

Pantaloni KORDA Drykore Over Trouser MK2, Dark Olive, Marimea L

kcl821
Livrare 7-14 zile

712,71Lei

Montura KORDA Basix Hair Rigs Wide Gape, Barbless, Nr.8, 18lb

Montura KORDA Basix Hair Rigs Wide Gape, Barbless, Nr.8, 18lb

kbx019
Livrare imediată!

21,30Lei

Lanseta KORDA Kaizen Green 3.00m/10ft, 3.00lbs, 2seg

Lanseta KORDA Kaizen Green 3.00m/10ft, 3.00lbs, 2seg

krd059
Livrare 7-14 zile

661,66Lei

Buzz Bar KORDA Singlez, 2 Posturi, 4.5inch/11cm

Buzz Bar KORDA Singlez, 2 Posturi, 4.5inch/11cm

ksing11
Livrare 7-14 zile

214,02Lei

Carlige KORDA Long Shank Beaked, Barbless, Nr.8, 10buc/pac

Carlige KORDA Long Shank Beaked, Barbless, Nr.8, 10buc/pac

klsbb8
Livrare 7-14 zile

36,54Lei

Geanta Termoizolanta KORDA Compac Cooler, 20ltr

Geanta Termoizolanta KORDA Compac Cooler, 20ltr

klug28
Livrare 7-14 zile

661,66Lei

SAPCA KORDA SNAPBACK KAMO

SAPCA KORDA SNAPBACK KAMO

kbc22
Livrare imediată!

90,73Lei

Carlige KORDA Straight Point Hook Micro Barbed Nr.5, 10buc/pac

Carlige KORDA Straight Point Hook Micro Barbed Nr.5, 10buc/pac

k.ksph5
Livrare 24-48 ore

45,52Lei

Combo KORDA 3 Lansete Kaizen Green 3.90m, 4.0lbs, 2seg + Husa Compac 3 Rod Divide Holdall

Combo KORDA 3 Lansete Kaizen Green 3.90m, 4.0lbs, 2seg + Husa Compac 3 Rod Divide Holdall

krd020-combo
Livrare imediată!

2.715,54Lei

Montura KORDA BASIX WIDE GAPE 8/18LB 2BUC/PL

Montura KORDA BASIX WIDE GAPE 8/18LB 2BUC/PL

kbx016
Livrare 7-14 zile

19,84Lei

Jacheta KORDA Kore Thermolite, Olive, Marime XL

Jacheta KORDA Kore Thermolite, Olive, Marime XL

kcl463
Livrare 7-14 zile

610,55Lei

Pantaloni Scurti KORDA Le Jersey Short , Light Kamo, Marime XL

Pantaloni Scurti KORDA Le Jersey Short , Light Kamo, Marime XL

kcl391
Livrare imediată!

237,21Lei

Short KORDA Le Quick Dry, Burgundy, Marime XL

Short KORDA Le Quick Dry, Burgundy, Marime XL

kcl680
Livrare 7-14 zile

189,37Lei

Husa Lanseta cu Mulineta Korda Compac 3 Camo, 3.90m

Husa Lanseta cu Mulineta Korda Compac 3 Camo, 3.90m

klug115
Livrare 7-14 zile

660,09Lei

Atractant Lichid KORDA Goo, Pango Supreme, 115ml

Atractant Lichid KORDA Goo, Pango Supreme, 115ml

goo52
Livrare imediată!

98,01Lei

Carlige KORDA Spinner Nr.6, 10buc/pac

Carlige KORDA Spinner Nr.6, 10buc/pac

kspr6
Livrare imediată!

33,90Lei

Atractant KORDA Almond Supreme, 115ml

Atractant KORDA Almond Supreme, 115ml

kgoo09
Livrare 7-14 zile

95,15Lei

Hanorac KORDA Lightweight Hoodie, Olive, Marime 3XL

Hanorac KORDA Lightweight Hoodie, Olive, Marime 3XL

kcl198
Livrare 7-14 zile

255,15Lei

Tricou KORDA Tie Dye Tee, Dark Olive, Marime S

Tricou KORDA Tie Dye Tee, Dark Olive, Marime S

kcl490
Livrare 7-14 zile

153,46Lei

Caciula KORDA Kore Snood Beanie Hat, Olive

Caciula KORDA Kore Snood Beanie Hat, Olive

kbh05
Livrare 7-14 zile

82,29Lei

Afişare 621 - 640 din 1641 (83 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: 123.469 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = '13ab41ce3a03889f3d6ca3e460'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.129)
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 (37.116)
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 (85.659)
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 620,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.186)
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