Korda

Korda

Sortare după:

Tricou KORDA One Liner Tee Black, Marime S

Tricou KORDA One Liner Tee Black, Marime S

kc0108

Livrare 7-14 zile

134,95Lei

RIG SPOOLS KORDA

RIG SPOOLS KORDA

kbox17

Livrare imediată!

31,67Lei

Husa KORDA Compac Dark Kamo pentru Tableta(Laptop), Small, 22x16x2cm

Husa KORDA Compac Dark Kamo pentru Tableta(Laptop), Small, 22x16x2cm

klug125

Livrare 7-14 zile

92,46Lei

Vesta KORDA Kore Fleece, Olive, Marime M

Vesta KORDA Kore Fleece, Olive, Marime M

kcl595

Livrare 7-14 zile

213,63Lei

Pantaloni Lungi KORDA Lite Joggers, Olive, Marime M

Pantaloni Lungi KORDA Lite Joggers, Olive, Marime M

kcl431

Livrare imediată!

237,17Lei

Caciula Korda, Burgundy, Marime Universala

Caciula Korda, Burgundy, Marime Universala

kbh34

Livrare 7-14 zile

76,30Lei

Carlige Legate Korda Boom Spinner Hook 4, 25lb, 2buc/pac

Carlige Legate Korda Boom Spinner Hook 4, 25lb, 2buc/pac

krr021

Livrare imediată!

36,91Lei

Cantar KORDA Dial Scale 120lbs/54kg

Cantar KORDA Dial Scale 120lbs/54kg

ksc120g

Livrare 7-14 zile

458,31Lei

Pantaloni Scurti KORDA Kombat Shorts, Marime XL

Pantaloni Scurti KORDA Kombat Shorts, Marime XL

kcl160

Livrare 7-14 zile

305,79Lei

Jacheta KORDA Kore Thermolite, Olive, Marime 3XL

Jacheta KORDA Kore Thermolite, Olive, Marime 3XL

kcl465

Livrare 7-14 zile

656,84Lei

Sapca KORDA Logo Patch Cap, Dark Kamo

kbc28

Livrare imediată!

97,55Lei

Bluza UV KORDA Kool UPF Zip Jersey, Dark Olive, Marimea S

Bluza UV KORDA Kool UPF Zip Jersey, Dark Olive, Marimea S

kcl841

Livrare 7-14 zile

204,31Lei

Pantaloni Scurti KORDA Quick Dry Shorts, Burgundy, Marimea 2XL

Pantaloni Scurti KORDA Quick Dry Shorts, Burgundy, Marimea 2XL

kcl681

Livrare 7-14 zile

204,31Lei

Jacheta KORDA Drykore MK2, Dark Olive, Marimea XL

Jacheta KORDA Drykore MK2, Dark Olive, Marimea XL

kcl808

Livrare 7-14 zile

941,50Lei

Montura KORDA N Trap DF Rig Wide Gape, Barbless, Nr.2, 30lb, 1buc/pac

Montura KORDA N Trap DF Rig Wide Gape, Barbless, Nr.2, 30lb, 1buc/pac

kcr140

Livrare 7-14 zile

19,76Lei

Pluta KORDA Interceptor Controller Float, 5g

Pluta KORDA Interceptor Controller Float, 5g

ksf5

Livrare 7-14 zile

41,62Lei

Carlige KORDA Spinner Nr.5, Barbless, 10buc/pac

Carlige KORDA Spinner Nr.5, Barbless, 10buc/pac

ksprb5

Livrare imediată!

36,54Lei

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

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

klsbb2

Livrare 7-14 zile

36,54Lei

Rucsac KORDA Compac Rucksack 30 Dark Kamo, 36x44x30cm, 30ltr

Rucsac KORDA Compac Rucksack 30 Dark Kamo, 36x44x30cm, 30ltr

klug157

Livrare 7-14 zile

483,93Lei

KORDA GEANTA COMPAC MAR.M

KORDA GEANTA COMPAC MAR.M

klug30

Livrare 7-14 zile

424,63Lei

Afişare 281 - 300 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: 158.355 ms [By time] [By id] [By file]

1 (0.122)

SELECT data
FROM `oc_session`
WHERE session_id = '4bd1e17dc1e3c16bce83340d5e'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.173)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.120)

SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.119)

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.788)

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 (90.822)

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 280,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.211)

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