Korda


Varf Suport KORDA Singlez Spike

Varf Suport KORDA Singlez Spike

ksing12
Livrare 7-14 zile

112,34Lei

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

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

ksz35
Livrare 7-14 zile

38,74Lei

Fir Monofilament KORDA Touchdown, Green, 12lbs/0.35mm, 1000m

Fir Monofilament KORDA Touchdown, Green, 12lbs/0.35mm, 1000m

ktdg12
Livrare 7-14 zile

143,30Lei

Husa KORDA Compac Gas Canister Jacket, Dark Kamo, 11x11x15cm

Husa KORDA Compac Gas Canister Jacket, Dark Kamo, 11x11x15cm

klug112
Livrare 7-14 zile

97,55Lei

PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

PORUMB ARTIFICIAL SLOW SINKING KORDA MAIZE CITRUS ZING LIME 10BUC/PLIC

kpb41
Livrare imediată!

22,16Lei

Plumb Tungsten Korda Dark Matter Balancing 0.45g

Plumb Tungsten Korda Dark Matter Balancing 0.45g

kdmw05
Livrare imediată!

33,54Lei

Tricou KORDA One Liner Tee Olive, Marime S

Tricou KORDA One Liner Tee Olive, Marime S

kc0115
Livrare 7-14 zile

134,95Lei

SALTEA PRIMIRE KORDA BASIX

SALTEA PRIMIRE KORDA BASIX

kbx028
Livrare 7-14 zile

442,40Lei

Hanorac KORDA Kore Zip Pro, Olive, Marime XL

Hanorac KORDA Kore Zip Pro, Olive, Marime XL

kcl752
Livrare imediată!

307,70Lei

Protectie Vant Wind Shield Korda Large

Protectie Vant Wind Shield Korda Large

kda007
Livrare imediată!

163,64Lei

Tricou Korda Kore Dark Kamo, Marime M

Tricou Korda Kore Dark Kamo, Marime M

kcl726
Livrare 7-14 zile

151,66Lei

Husa Picheti Korda Compac Dark Camo

Husa Picheti Korda Compac Dark Camo

klug120
Livrare imediată!

104,56Lei

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.4, 10buc/pac

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.4, 10buc/pac

klsb4
Livrare imediată!

33,92Lei

Pantaloni KORDA Insulated Jogger, Dark Olive, Marime L

Pantaloni KORDA Insulated Jogger, Dark Olive, Marime L

kcl783
Livrare imediată!

307,11Lei

Pantaloni KORDA Kore Original Kombats, Olive, Marime M

Pantaloni KORDA Kore Original Kombats, Olive, Marime M

kcl074
Livrare 7-14 zile

382,05Lei

Tricou KORDA Tie Dye Tee, Dark Olive, Marime XL

Tricou KORDA Tie Dye Tee, Dark Olive, Marime XL

kcl493
Livrare 7-14 zile

153,46Lei

Palarie KORDA Fleece Waterproof Boonie, Olive

Palarie KORDA Fleece Waterproof Boonie, Olive

kbh21
Livrare 7-14 zile

128,05Lei

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

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

kcl949
Livrare 7-14 zile

222,34Lei

Tricou Korda Kore Dark Kamo, Marime 3XL

Tricou Korda Kore Dark Kamo, Marime 3XL

kcl730
Livrare 7-14 zile

163,64Lei

Jacheta KORDA Drykore MK2, Dark Kamo, Marimea XL

Jacheta KORDA Drykore MK2, Dark Kamo, Marimea XL

kcl815
Livrare 7-14 zile

1.017,76Lei

Afişare 421 - 440 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: 113.404 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = '958e48d18441b5536fc423bddc'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.156)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.147)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.130)
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 (51.329)
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 (61.379)
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 420,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.128)
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