Korda


CIORAPI KORDA CAMO MARIME 44-46

CIORAPI KORDA CAMO MARIME 44-46

kcl242
Livrare 7-14 zile

180,50Lei

FIR INAINTAS KORDA MONOFILAMENT KORDA XT SNAG LEADER SUBLINE BROWN 0.65mm 27.21kg 100M

FIR INAINTAS KORDA MONOFILAMENT KORDA XT SNAG LEADER SUBLINE BROWN 0.65mm 27.21kg 100M

snag60
Livrare 7-14 zile

77,21Lei

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

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

kcl389
Livrare imediată!

237,21Lei

Montura Korda Kable Hybrid Leas Clip, Gravel, 50cm, 3buc/pac

Montura Korda Kable Hybrid Leas Clip, Gravel, 50cm, 3buc/pac

kll001
Livrare imediată!

48,06Lei

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

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

krr024
Livrare 7-14 zile

39,08Lei

Extensie Suport KORDA Singlez Spike

Extensie Suport KORDA Singlez Spike

ksing13
Livrare 7-14 zile

92,00Lei

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

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

ksz36
Livrare 7-14 zile

41,62Lei

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

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

ktdg20
Livrare 7-14 zile

143,30Lei

ATRACTANT KORDA GOO TIGER NUT SMOKE 115ML

ATRACTANT KORDA GOO TIGER NUT SMOKE 115ML

goo21
Livrare imediată!

98,33Lei

Husa Cantar KORDA Compac Scales Pouch Dark Kamo

Husa Cantar KORDA Compac Scales Pouch Dark Kamo

klug113
Livrare 7-14 zile

102,63Lei

PORUMB ARTIFICIAL KORDA POP UP MAIZE CITRUS ZING LIME 10BUC/PLIC

PORUMB ARTIFICIAL KORDA POP UP MAIZE CITRUS ZING LIME 10BUC/PLIC

kpb42
Livrare imediată!

22,16Lei

Afişare 321 - 340 din 1628 (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: 87.683 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '0d9e836bcea2b4d249a4e7d88f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.091)
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 (35.265)
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 (51.904)
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 320,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.096)
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