Korda


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

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

kcr141
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

Minciog KORDA Spring Bow Deep Version Net, 50inch/127cm

Minciog KORDA Spring Bow Deep Version Net, 50inch/127cm

kln003
Livrare 7-14 zile

1.521,13Lei

CREMA ANTICOROZIVA KORDA KAMAKOTE POINT COMPOUND

CREMA ANTICOROZIVA KORDA KAMAKOTE POINT COMPOUND

kam27
Livrare imediată!

24,39Lei

Husa Tableta / Laptop KORDA Compac, Large, 34x26x2cm

Husa Tableta / Laptop KORDA Compac, Large, 34x26x2cm

klug67
Livrare 7-14 zile

97,55Lei

GEANTA KORDA COMPAC COOL MARIME S

GEANTA KORDA COMPAC COOL MARIME S

klug36
Livrare imediată!

156,89Lei

Geanta KORDA Compac Utility Bag, Olive, 24x24x20cm

Geanta KORDA Compac Utility Bag, Olive, 24x24x20cm

klug92
Livrare 7-14 zile

128,05Lei

PORUMB ARTIFICIAL KORDA SLOW SINKING CORN CITRUS ZING LIME 12BUC/PLIC

PORUMB ARTIFICIAL KORDA SLOW SINKING CORN CITRUS ZING LIME 12BUC/PLIC

kpb43
Livrare imediată!

22,16Lei

Tricou KORDA One Liner Tee Olive, Marime 4XL

Tricou KORDA One Liner Tee Olive, Marime 4XL

kc0121
Livrare 7-14 zile

134,95Lei

TRICOU KORDA LIGHT KAMO MAR.XL

TRICOU KORDA LIGHT KAMO MAR.XL

kcl355
Livrare imediată!

152,16Lei

Jacheta Fleece KORDA Kore Polar, Olive, Marime S

Jacheta Fleece KORDA Kore Polar, Olive, Marime S

kcl454
Livrare imediată!

354,15Lei

HUSA LANSETA KORDA COMPAC 2 PT LANSETA 3.65M

HUSA LANSETA KORDA COMPAC 2 PT LANSETA 3.65M

klug33
Livrare 7-14 zile

559,41Lei

Pantaloni Lungi KORDA Lite Joggers, Light Kamo, Marime S

Pantaloni Lungi KORDA Lite Joggers, Light Kamo, Marime S

kcl394
Livrare imediată!

284,31Lei

Fir Textil Korda Loop Braid Camo, 10lb, 20m

Fir Textil Korda Loop Braid Camo, 10lb, 20m

klb20
Livrare 7-14 zile

61,99Lei

Geanta Korda Compac Camo, Marime L, 53x35x33cm

Geanta Korda Compac Camo, Marime L, 53x35x33cm

klug98
Livrare imediată!

471,73Lei

Pantaloni KORDA Ultralite Jogger, Olive, Marime XL

Pantaloni KORDA Ultralite Jogger, Olive, Marime XL

kcl958
Livrare 7-14 zile

259,81Lei

Palarie Korda Digi Camo

Palarie Korda Digi Camo

kbh17
Livrare imediată!

85,73Lei

Montura Korda Spinner Hook Sections, Nr.6, 3buc/pac

Montura Korda Spinner Hook Sections, Nr.6, 3buc/pac

krr032
Livrare 7-14 zile

31,57Lei

Fir Monofilament Monturi KORDA Mouthtrap Chod Filament, 0.53mm, 25lbs, 20m

Fir Monofilament Monturi KORDA Mouthtrap Chod Filament, 0.53mm, 25lbs, 20m

kmt25
Livrare imediată!

46,94Lei

Afişare 461 - 480 din 1627 (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: 105.313 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '15426ef83a4767ef3eb24febce'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.122)
SELECT *
FROM oc_url_alias
WHERE keyword = 'korda.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.123)
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 (41.738)
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 (62.999)
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 460,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.134)
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