- Tyhjä ostoskori
Yht. 0,00 €
1-40-39-1T1 / 286880
TNT Racing -variaattori, CPI/Keeway
59,90 €
TNT Racing -variaattorisarja, sisältää rullakupin, liukuholkin, Ø16x13mm rullasarjat (4.0g, 5.0g ja 6.0g), rullapitimen sekä liukupalasarjan.
Sopii Benelli 49x Quattronovex, CPI Aragon, Formula, GTR, Hussar Euro2, Oliver Euro2 ja Popcorn Euro2, 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, Malaguti F12 07- sekä Titan T2.
Sopii Benelli 49x Quattronovex, CPI Aragon, Formula, GTR, Hussar Euro2, Oliver Euro2 ja Popcorn Euro2, 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, Malaguti F12 07- sekä Titan T2.
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 = '35348' AND p2c.products_id != '35348' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]