- Tyhjä ostoskori
Yht. 0,00 €
1-44-30-20 / BT13111
101_Octane -kytkin, Minarelli (107mm)
21,90 €
101_Octane -kytkin. Ulkohalkaisija 107mm.
Sopii Aprilia Area51, DiTech, Rally, Mojito, Scarabeo, Sonic, SR50, SR50 Racing, SR50 Factory, ja SR50 WWW, Benelli K2 ja 491RR, Beta, Fude 4T, Derbi Atlantis, Boulevard ja GP1, Gilera DNA, Ice, Runner, Stalker ja Typhoon, Honda SFX, SH50 ja X8R, Kymco Agility, Cobra, DJ50, Heroism, Like, People, People S, ZX50 Super Fever, Super 8, Super 9 ja Vitality, Malaguti F10, F12, F15 ja Yesterday, MBK Booster, Flipper, Mach, Nitro, Ovetto ja Stunt, Peugeot Buxy, Elyseo, JetForce, Looxor, Ludix, Speedake, Speedfight 1 ja 2, Speedfight 3, Squab, SV50, Trekker, Vivacity, V-Clic ja Zenith, Piaggio Diesis, Fly, Free, NRG, NRG MC2 -98, NTT, Quartz, Sfera, ZIP ja Zip SP, SYM Orbit, Jet Basic-X ja Jet Euro-X sekä Yamaha Aerox, BW'S, Jog R, Neo's ja Slider.
Sopii Aprilia Area51, DiTech, Rally, Mojito, Scarabeo, Sonic, SR50, SR50 Racing, SR50 Factory, ja SR50 WWW, Benelli K2 ja 491RR, Beta, Fude 4T, Derbi Atlantis, Boulevard ja GP1, Gilera DNA, Ice, Runner, Stalker ja Typhoon, Honda SFX, SH50 ja X8R, Kymco Agility, Cobra, DJ50, Heroism, Like, People, People S, ZX50 Super Fever, Super 8, Super 9 ja Vitality, Malaguti F10, F12, F15 ja Yesterday, MBK Booster, Flipper, Mach, Nitro, Ovetto ja Stunt, Peugeot Buxy, Elyseo, JetForce, Looxor, Ludix, Speedake, Speedfight 1 ja 2, Speedfight 3, Squab, SV50, Trekker, Vivacity, V-Clic ja Zenith, Piaggio Diesis, Fly, Free, NRG, NRG MC2 -98, NTT, Quartz, Sfera, ZIP ja Zip SP, SYM Orbit, Jet Basic-X ja Jet Euro-X sekä Yamaha Aerox, BW'S, Jog R, Neo's ja Slider.
SELECT p.products_ordered * p.products_price AS sales_value, p2c.products_id, pd.products_url, pd.products_name, p.products_price, p.products_image, p.products_tax_class_id, pd.products_description, p.tukkuhinta, IF(s.status, s.specials_new_products_price, null) AS specials_new_products_price FROM products_to_categories p2c INNER JOIN products_to_categories p2c2 ON p2c2.categories_id = p2c.categories_id LEFT JOIN products p ON p.products_id = p2c.products_id LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials s ON s.products_id = p.products_id WHERE p.products_status = '1' AND p2c2.products_id = '8359' AND p2c.products_id != '8359' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]