Korda

Korda

Sortare după:

Husa 5 Lansete cu Mulineta KORDA Compac 5 Rod Divide Holdall, 13ft/3.90m

Husa 5 Lansete cu Mulineta KORDA Compac 5 Rod Divide Holdall, 13ft/3.90m

klug89

Livrare 7-14 zile

1.017,76Lei

Cana Korda Logo Burgundy

klug16

Livrare 7-14 zile

41,12Lei

Tricou KORDA One Liner Tee Olive, Marime XL

Tricou KORDA One Liner Tee Olive, Marime XL

kc0118

Livrare 7-14 zile

134,95Lei

MONOFILAMENT KORDA LONGCHUCK 0.27-0.47MM, 300M, 4.5-13.6KG

MONOFILAMENT KORDA LONGCHUCK 0.27-0.47MM, 300M, 4.5-13.6KG

kdcm08

Livrare imediată!

67,09Lei

Jacheta Fleece KORDA Kore Polar, Olive, Marime S

Jacheta Fleece KORDA Kore Polar, Olive, Marime S

kcl322

Livrare imediată!

374,95Lei(-5%) 355,34Lei

Ochelari Korda Ronnie Brown

Ochelari Korda Ronnie Brown

k4d20

Livrare 7-14 zile

189,33Lei

Geanta Korda Compac Cube Camo, 40x40x30cm

Geanta Korda Compac Cube Camo, 40x40x30cm

klug122

Livrare imediată!

559,99Lei

Salopeta KORDA Polar, Olive, Marime XL

Salopeta KORDA Polar, Olive, Marime XL

kcl487

Livrare 7-14 zile

565,92Lei

Husa Lansete cu Mulineta KORDA Compac, 5 Lansete, Dark Camo, 12ft/3.60m

Husa Lansete cu Mulineta KORDA Compac, 5 Lansete, Dark Camo, 12ft/3.60m

klug102

Livrare 7-14 zile

730,71Lei

Lanseta KORDA Kaizen Green Spod 3.90m/13ft, 5.00lbs, 2seg

Lanseta KORDA Kaizen Green Spod 3.90m/13ft, 5.00lbs, 2seg

krd053

Livrare 7-14 zile

865,03Lei

Hanorac KORDA Kore TK Hoodie, Dark Olive, Marime L

Hanorac KORDA Kore TK Hoodie, Dark Olive, Marime L

kcl099

Livrare 7-14 zile

305,79Lei

Bluza KORDA Thermal LS Shirt, Olive, Marime 3XL

Bluza KORDA Thermal LS Shirt, Olive, Marime 3XL

kcl311

Livrare 7-14 zile

204,31Lei

Tricou Korda Minimal Tee Burgundy, Marimea S

Tricou Korda Minimal Tee Burgundy, Marimea S

kcl522

Livrare 7-14 zile

153,46Lei

Saltea Receptie KORDA Basix Carp Cradle XL

Saltea Receptie KORDA Basix Carp Cradle XL

kbx041

Livrare 7-14 zile

560,19Lei

Salopeta KORDA Polar, Dark Kamo, Marimea 3XL

Salopeta KORDA Polar, Dark Kamo, Marimea 3XL

kcl852

Livrare 7-14 zile

692,37Lei

Pantaloni KORDA Insulated Jogger, Dark Olive, Marime S

Pantaloni KORDA Insulated Jogger, Dark Olive, Marime S

kcl781

Livrare 7-14 zile

331,41Lei

Pantaloni KORDA Ultralite Jogger, Olive, Marime 3XL

Pantaloni KORDA Ultralite Jogger, Olive, Marime 3XL

kcl960

Livrare 7-14 zile

280,57Lei

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

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

krr026

Livrare imediată!

39,08Lei

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

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

ksz38

Livrare 7-14 zile

41,62Lei

Porumb Artificial KORDA Slow Sinking Maize, IB, Yellow, 10buc/pac

Porumb Artificial KORDA Slow Sinking Maize, IB, Yellow, 10buc/pac

kpb31

Livrare imediată!

24,90Lei

Afişare 381 - 400 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: 103.334 ms [By time] [By id] [By file]

1 (0.181)

SELECT data
FROM `oc_session`
WHERE session_id = 'd39075075c0bf9fd0046bb7890'

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

2 (0.083)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.095)

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

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

4 (0.092)

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

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

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

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

7 (0.146)

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