Korda

Korda

Sortare după:

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

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

krr025

Livrare 7-14 zile

39,08Lei

Stabilizator KORDA Singlez Ball Stabiliser

Stabilizator KORDA Singlez Ball Stabiliser

ksing14

Livrare 7-14 zile

153,00Lei

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

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

ksz37

Livrare 7-14 zile

41,62Lei

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

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

ktdb20

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 Lanseta cu Mulineta KORDA Compac Padded Rod Sleeve, Dark Kamo,10ft/3.00m, 163x26x5cm

Husa Lanseta cu Mulineta KORDA Compac Padded Rod Sleeve, Dark Kamo,10ft/3.00m, 163x26x5cm

klug117

Livrare 7-14 zile

229,73Lei

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

klug15

Livrare 7-14 zile

41,12Lei

Tricou KORDA One Liner Tee Olive, Marime M

Tricou KORDA One Liner Tee Olive, Marime M

kc0116

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

Pantaloni KORDA Kore Original Kombats, Olive, Marime 3XL

Pantaloni KORDA Kore Original Kombats, Olive, Marime 3XL

kcl078

Livrare 7-14 zile

382,05Lei

Caciula KORDA Klassic Beanie, Rust

Caciula KORDA Klassic Beanie, Rust

kbh28

Livrare 7-14 zile

82,29Lei

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

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

kcl952

Livrare 7-14 zile

222,34Lei

Afişare 561 - 580 din 1641 (83 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: 94.641 ms [By time] [By id] [By file]

1 (0.137)

SELECT data
FROM `oc_session`
WHERE session_id = '13ab41ce3a03889f3d6ca3e460'

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

2 (0.088)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.106)

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

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

4 (0.102)

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.552)

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

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

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

7 (0.120)

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