- Tyhjä ostoskori
Yht. 0,00 €
1-57-30-9
Käynnistinpolkimen akselin sokka, Minarelli/CPI
1,90 €
Käynnistinpolkimen akselin lukkosokka. Sopii 13.8mm uraan.
Sopii Aprilia Amico, Area 51, Rally, Sonic, SR50 -97, SR50 Netscaper, SR50 Racing -00, SR50 Stealth ja SR50 WWW, Benelli 491GT -03, 491RR -03, 491 ST -03, 491 Sport -03, K2 -03, Naked -03 ja Pepe -03, Beta Ark, Chrono, Eikon, Quadra ja Tempo, CPI Hussar, Oliver, Popcorn, Aragon ja Formula, Italjet Dragster, Pista, Scoop ja Yankee, Fude 4T, Generic Candy, Classic, Commodo, Cracker, Epico, Evolution, Hi, Ideo, Iron, Jump, Kallio, Onyx, Pandora, Race GT, Race 2 GT, Roc, Sirion, Speed, Spin, Toxic, Vendetta, Vertigo, XOR ja XOR 2, Keeway Arn, Easy, F-Act, Flash, Focus, Goccia, Hacker, Hurricane, Matrix, Pixel, RY6, RY8, Swan ja Venus, Kymco Agility, Agility RS 2T, Cobra, Dink, Like 2T, People 2T, Spacer, Super 8 2T, Super 9 AC ja Vitality, Malaguti Centro 2T, Ciak, F10, F12 Phantom AC -07, F12 Phantom LC, F12 Phantom R, F15 Firefox AC 04-, F15 Firefox LC ja Yesterday, MBK Booster, Booster NG, Naked, Rocket, Spirit, Track, Evolis, Fizz, Flipper, Mach G, Nitro, Ovetto 2T ja Stunt, Peugeot Buxy, Elyseo, Looxor, Speedake, Speedfight 1, Speedfight 2, Squab, SV50, Trekker, Vivacity ja Zenith, Titan 2T sekä Yamaha Aerox, Axis, BW'S, Jog, Jog R AC, Jog RR LC, Neo's 2T, Slider AC, Why ja YE Zest.
Sopii Aprilia Amico, Area 51, Rally, Sonic, SR50 -97, SR50 Netscaper, SR50 Racing -00, SR50 Stealth ja SR50 WWW, Benelli 491GT -03, 491RR -03, 491 ST -03, 491 Sport -03, K2 -03, Naked -03 ja Pepe -03, Beta Ark, Chrono, Eikon, Quadra ja Tempo, CPI Hussar, Oliver, Popcorn, Aragon ja Formula, Italjet Dragster, Pista, Scoop ja Yankee, Fude 4T, Generic Candy, Classic, Commodo, Cracker, Epico, Evolution, Hi, Ideo, Iron, Jump, Kallio, Onyx, Pandora, Race GT, Race 2 GT, Roc, Sirion, Speed, Spin, Toxic, Vendetta, Vertigo, XOR ja XOR 2, Keeway Arn, Easy, F-Act, Flash, Focus, Goccia, Hacker, Hurricane, Matrix, Pixel, RY6, RY8, Swan ja Venus, Kymco Agility, Agility RS 2T, Cobra, Dink, Like 2T, People 2T, Spacer, Super 8 2T, Super 9 AC ja Vitality, Malaguti Centro 2T, Ciak, F10, F12 Phantom AC -07, F12 Phantom LC, F12 Phantom R, F15 Firefox AC 04-, F15 Firefox LC ja Yesterday, MBK Booster, Booster NG, Naked, Rocket, Spirit, Track, Evolis, Fizz, Flipper, Mach G, Nitro, Ovetto 2T ja Stunt, Peugeot Buxy, Elyseo, Looxor, Speedake, Speedfight 1, Speedfight 2, Squab, SV50, Trekker, Vivacity ja Zenith, Titan 2T sekä Yamaha Aerox, Axis, BW'S, Jog, Jog R AC, Jog RR LC, Neo's 2T, Slider AC, Why ja YE Zest.
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 = '33011' AND p2c.products_id != '33011' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]