Korda


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

Porumb Artificial Korda Slow Sinking Maize IB, Pink, 10buc/pac

Porumb Artificial Korda Slow Sinking Maize IB, Pink, 10buc/pac

kpb45
Livrare imediată!

23,82Lei

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

MONTURA KORDA N-TRAP KD KURV NR.8/15LB

MONTURA KORDA N-TRAP KD KURV NR.8/15LB

kcr045
Livrare imediată!

18,39Lei

Husa Cantar KORDA Compac Scales Pouch Dark Kamo

Husa Cantar KORDA Compac Scales Pouch Dark Kamo

klug113
Livrare 7-14 zile

102,63Lei

FIR MONOFILAMENT KORDA TOUCHDOWN 0.30MM/10LB 1000M

FIR MONOFILAMENT KORDA TOUCHDOWN 0.30MM/10LB 1000M

ktdg10
Livrare 7-14 zile

114,19Lei

Cana Korda Logo Black

Cana Korda Logo Black

klug15
Livrare 7-14 zile

41,12Lei

Tricou KORDA One Liner Tee Olive, Marime S

Tricou KORDA One Liner Tee Olive, Marime S

kc0115
Livrare 7-14 zile

134,95Lei

Fir KORDA BASIX COATED HOOKLINK 25LB/10M

Fir KORDA BASIX COATED HOOKLINK 25LB/10M

kbx011
Livrare imediată!

31,67Lei

Afişare 81 - 100 din 1638 (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.502 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = 'ab04b894856ca4128b00ca1064'
/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.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.145)
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 (36.215)
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 (50.705)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.101)
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