Korda


CROSETA KORDA PENTRU MONTURA FIR TEXTIL 7 CM ALBASTRA

CROSETA KORDA PENTRU MONTURA FIR TEXTIL 7 CM ALBASTRA

kbnbf
Livrare imediată!

22,65Lei

Cutie Accesorii Korda Mini Compartment Boxes 9 Compartimente

Cutie Accesorii Korda Mini Compartment Boxes 9 Compartimente

kbox7
Livrare imediată!

53,22Lei

Ochelari Korda Polarizati Aviator, Tortois/Grey

Ochelari Korda Polarizati Aviator, Tortois/Grey

k4d04
Livrare 7-14 zile

231,90Lei

FIR KORDA DARK MATTER TUNGSTEN COATED VERDE 25LBS/10M

FIR KORDA DARK MATTER TUNGSTEN COATED VERDE 25LBS/10M

kdmcw25
Livrare 7-14 zile

83,60Lei

CUTIE KORDA COMPAC 125 CAMO

CUTIE KORDA COMPAC 125 CAMO

klug19
Livrare imediată!

111,11Lei

TRICOU KORDA ROUND NECK OLIVE MARIME XXL

TRICOU KORDA ROUND NECK OLIVE MARIME XXL

kcl344
Livrare imediată!

92,89Lei

FIR TEXTIL KORDA DARK MATTER SUPER-HEAVY TUNGSTEN COATED GRAVEL BROWN 25lbs 11.30kg 10M

FIR TEXTIL KORDA DARK MATTER SUPER-HEAVY TUNGSTEN COATED GRAVEL BROWN 25lbs 11.30kg 10M

kdmcg25
Livrare 7-14 zile

83,61Lei

STICK KORDA MAGNETIC HOCKEY

STICK KORDA MAGNETIC HOCKEY

keb14
Livrare imediată!

49,94Lei

Con Plumb Pierdut Korda NanoTail Rubber 10buc/pac, Silt

Con Plumb Pierdut Korda NanoTail Rubber 10buc/pac, Silt

krns
Livrare 7-14 zile

25,43Lei

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.50mm, 9.10kg

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.50mm, 9.10kg

kboom50
Livrare 7-14 zile

69,42Lei

Fir Textil KORDA Basix Spod / Marker Braid, Green, 13.60kg, 200m

Fir Textil KORDA Basix Spod / Marker Braid, Green, 13.60kg, 200m

kbx043
Livrare 7-14 zile

115,74Lei

Plumb KORDA Big Grippa, 3oz/84g, 2buc/pac

Plumb KORDA Big Grippa, 3oz/84g, 2buc/pac

bgb3
Livrare 7-14 zile

24,95Lei

Plumb cu Vartej KORDA Distance Casting Swivel, 4oz/112g, 1buc/pac

Plumb cu Vartej KORDA Distance Casting Swivel, 4oz/112g, 1buc/pac

dcs4
Livrare imediată!

13,95Lei

Montura KORDA Carp Rig Dark Matter Wide Gape + Free Extenda Stops, Barbless, 1buc/blister Nr.2/30lbs
Lant Rezerva cu Adaptor Hanger KORDA Stow , Short

Lant Rezerva cu Adaptor Hanger KORDA Stow , Short

keb17
Livrare 7-14 zile

44,95Lei

Burghiu KORDA Bait Drill, 4mm

Burghiu KORDA Bait Drill, 4mm

krt002
Livrare 7-14 zile

42,45Lei

CLIPS PLUMB PIERDUT KORDA 10 BUC CLAY

CLIPS PLUMB PIERDUT KORDA 10 BUC CLAY

kqrcg
Livrare imediată!

25,51Lei

COBRA EAZI STICK D=20MM KORDA -17%

COBRA EAZI STICK D=20MM KORDA

ts20
Livrare imediată!

84,50Lei(-17%) 70,00Lei

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

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

ksz90
Livrare 7-14 zile

39,95Lei

TUB SILICONIC PROTECTIE KORDA D=3MM 20BUC/PL

TUB SILICONIC PROTECTIE KORDA D=3MM 20BUC/PL

ks3
Livrare imediată!

18,36Lei

Afişare 1361 - 1380 din 1428 (72 pagini)
Queries: 7, Total time: 94.497 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '9b017d3da3c8b22a3988154cb3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.109)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (37.444)
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 = '3' AND p.manufacturer_id = '73'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (56.533)
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 = '3' AND p.manufacturer_id = '73' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.148)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37