Toimituskulut alk. 4,90eIlmainen toimitus yli 90 € tilauksiinToimitus seuraavana arkipäivänä (2kpl)Perillä 1-2 arkipäivässä toimituksesta
101_Octane -kytkinkello. Sisähalkaisija 107mm.
Sopii Aprilia Area 51, Sonic, SR50 ja SR50 WWW, Benelli K2, Beta, Italjet Dragster ja Scoop, Malaguti F12 ja F15, MBK, Flipper, Mach, Nitro ja Ovetto sekä Yamaha BW'S, Aerox, 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 = '35475' AND p2c.products_id != '35475' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10