Korda


Geanta Korda Compac Cool L

Geanta Korda Compac Cool L

a8.klug38
Livrare 24-48 ore

416,62Lei

DISTANCE STICKS KORDA BASIX

DISTANCE STICKS KORDA BASIX

a.kbx001
Livrare imediată!

120,77Lei

FIR, KORDA, , MONOLINE, LONGCHUCK, 22Kg/0,27MM/1000M, a.kdcm01, Fire Monofilament Crap, Fire Monofilament Crap Korda, Korda -17%

FIR, KORDA, , MONOLINE, LONGCHUCK, 22Kg/0,27MM/1000M, a.kdcm01, Fire Monofilament Crap, Fire Monofilament Crap Korda, Korda

a.kdcm01
Livrare imediată!

114,98Lei(-17%) 95,90Lei

HANORAC, , KORDA, KORE, ZIP, PRO, OLIVE, MAR.S, a8.kcl749, Hanorace, Hanorace Korda, Korda -23%

HANORAC, , KORDA, KORE, ZIP, PRO, OLIVE, MAR.S, a8.kcl749, Hanorace, Hanorace Korda, Korda

a8.kcl749
Livrare imediată!

301,63Lei(-23%) 232,01Lei

Vesta Korda Fleece Kore Black XXL

Vesta Korda Fleece Kore Black XXL

a8.kcl604
Livrare 24-48 ore

209,11Lei

JACHETA FLEECE KORDA KORE POLAR, MARIME XL

JACHETA FLEECE KORDA KORE POLAR, MARIME XL

a8.kcl325
Livrare 24-48 ore

348,48Lei

Line Aligner Korda Kicker Bloodworm Red, Marime L, 10buc/pac

Line Aligner Korda Kicker Bloodworm Red, Marime L, 10buc/pac

a.kick24
Livrare 24-48 ore

26,91Lei

Tricou Korda Le Tackle Black, Marime XL

Tricou Korda Le Tackle Black, Marime XL

a8.kcl710
Livrare imediată!

137,97Lei

Jacheta, Korda, Hybrid,, Olive,, Marime, S, a8.kcl787, Geci si Jachete, Geci si Jachete Korda, Geci Korda, Jachete Korda, Korda
SAPCA KORDA SNAPBACK KAMO

SAPCA KORDA SNAPBACK KAMO

a8.kbc22
Livrare imediată!

88,24Lei

JACHETA KORDA KORE THERMOLITE Negru MAR.M

JACHETA KORDA KORE THERMOLITE Negru MAR.M

a8.kcl467
Livrare 24-48 ore

708,79Lei

PANTALONI LUNGI KORDA LITE JOGGERS LIGHT KAMO MARIME L

PANTALONI LUNGI KORDA LITE JOGGERS LIGHT KAMO MARIME L

a8.kcl396
Livrare imediată!

278,63Lei

Cana Korda Logo Olive Green

Cana Korda Logo Olive Green

a.klug14
Livrare imediată!

39,45Lei

Tricou Korda Cut Tee, Negru, Marime L

Tricou Korda Cut Tee, Negru, Marime L

a8.kcl909
Livrare 24-48 ore

138,88Lei

Tricou Korda Birdsnest Tee Black, Marimea XL

Tricou Korda Birdsnest Tee Black, Marimea XL

a8.kcl940
Livrare 24-48 ore

138,88Lei

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.6, 10buc/pac

Carlige KORDA Long Shank Beaked, Micro Barbed, Nr.6, 10buc/pac

k.klsb6
Livrare 24-48 ore

32,38Lei

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

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

a.kcr045
Livrare 24-48 ore

15,29Lei

HUSA KORDA COMPAC GAS JACKET

HUSA KORDA COMPAC GAS JACKET

a8.klug49
Livrare 24-48 ore

78,96Lei

Plumb Tungsten Korda Dark Matter Balancing 0.50g

Plumb Tungsten Korda Dark Matter Balancing 0.50g

a.kdmw06
Livrare 24-48 ore

32,30Lei

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.S

SUPRAPANTALON KORDA DRYKORE OLIVE MAR.S

a8.kcl424
Livrare 24-48 ore

632,16Lei

Afişare 1 - 20 din 706 (36 pagini)
Queries: 7, Total time: 70.142 ms [By time] [By id] [By file]
1 (0.073)
SELECT data
FROM `oc_session`
WHERE session_id = '49559db89ed6400ba46085c8bf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
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.129)
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 (31.004)
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:1667
6 (38.588)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.125)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38