- Tyhjä ostoskori
Yht. 0,00 €
1-71-03-65 / NK101.97
Naraku -sylinterin pinnapultti, 7x110mm
2,90 €
Sylinterin pinnapultti, Naraku. Kierre M7, pituus 110mm.
Sopii Aprilia Amico, Area 51, Rally, RS50, RX50, MX50, Sonic, SR50 -97, SR50 Netscaper, SR50 Racing -00, SR50 Stealth, SR50 WWW, SX50 ja Scabareo 2T -04, Benelli 491GT -03, 491RR -03, 491ST -03, 491 Sport -03, 49x Quattronovex, K2 -03, Naked -03 ja Pepe -03, Beta Ark, Chrono, Eikon, RK6, RR50, Quadra ja Tempo, Bultaco Lobito, CH WSM Racing ja WXE Racing, CPI Aragon, Formula, Hussar, Oliver, Popcorn, SX ja SM, Derbi GPR, DRD Extreme 10-, DRD Black Devil, DRD Racing, DRD Pro, Senda R/SM, Senda Racer, Senda Black Edition, Senda X-Race ja Senda X-Treme, Generic Candy, Classic, Commodo, Cracker, Epico, Evolution, Hi, Ideo, Iron, Jump, Kallio, Onyx, Pandora, Race GT, Race 2 GT, Roc, Sirion, Speed, Spin, Toxic, Trigger SM, Trigger X-Enduro, Vendetta, Vertigo ja XOR, Gilera H@k 02-, RCR ja SMT, Italjet Dragster, Pista, Scoop ja Yankee, Keeway Arn, Easy, F-Act, Flash, Focus, Goccia, Hacker, Hurricane, Matrix, Pixel, RY6, RY8, Swan ja Venus, Kymco Agility RS, B&W, Grand Dink, Like 2T, People 2T, Super 8 2T, Super 9, Top Boy, Vitality, YUP ja Yager, Malaguti Centro 2T, Ciak, F10, F12 Phantom AC -07, F12 Phantom LC, F12 Phantom R, F15 Firefox AC 04-, F15 Firefox LC, XTM, XSM ja Yesterday, MBK Booster, Booster NG, Naked, Rocket, Spirit, Track, Evolis, Fizz, Flipper, Mach G, Nitro, Ovetto 2T, Stunt ja X-Limit, Motorhispania Furia, RX50 ja RYZ, Peugeot XP6, XPS ja XR6, Rieju Drac RR, MRT, MRX, RR, RS1, RS2, SMX ja Spike, Sherco HRD50, Titan 2T, Yamaha Aerox, Axis, BW'S, DT50R, Jog, Jog R AC, Jog RR LC, Neo's 2T, Slider AC, TZR50, Why ja YE Zest.
Sopii Aprilia Amico, Area 51, Rally, RS50, RX50, MX50, Sonic, SR50 -97, SR50 Netscaper, SR50 Racing -00, SR50 Stealth, SR50 WWW, SX50 ja Scabareo 2T -04, Benelli 491GT -03, 491RR -03, 491ST -03, 491 Sport -03, 49x Quattronovex, K2 -03, Naked -03 ja Pepe -03, Beta Ark, Chrono, Eikon, RK6, RR50, Quadra ja Tempo, Bultaco Lobito, CH WSM Racing ja WXE Racing, CPI Aragon, Formula, Hussar, Oliver, Popcorn, SX ja SM, Derbi GPR, DRD Extreme 10-, DRD Black Devil, DRD Racing, DRD Pro, Senda R/SM, Senda Racer, Senda Black Edition, Senda X-Race ja Senda X-Treme, Generic Candy, Classic, Commodo, Cracker, Epico, Evolution, Hi, Ideo, Iron, Jump, Kallio, Onyx, Pandora, Race GT, Race 2 GT, Roc, Sirion, Speed, Spin, Toxic, Trigger SM, Trigger X-Enduro, Vendetta, Vertigo ja XOR, Gilera H@k 02-, RCR ja SMT, Italjet Dragster, Pista, Scoop ja Yankee, Keeway Arn, Easy, F-Act, Flash, Focus, Goccia, Hacker, Hurricane, Matrix, Pixel, RY6, RY8, Swan ja Venus, Kymco Agility RS, B&W, Grand Dink, Like 2T, People 2T, Super 8 2T, Super 9, Top Boy, Vitality, YUP ja Yager, Malaguti Centro 2T, Ciak, F10, F12 Phantom AC -07, F12 Phantom LC, F12 Phantom R, F15 Firefox AC 04-, F15 Firefox LC, XTM, XSM ja Yesterday, MBK Booster, Booster NG, Naked, Rocket, Spirit, Track, Evolis, Fizz, Flipper, Mach G, Nitro, Ovetto 2T, Stunt ja X-Limit, Motorhispania Furia, RX50 ja RYZ, Peugeot XP6, XPS ja XR6, Rieju Drac RR, MRT, MRX, RR, RS1, RS2, SMX ja Spike, Sherco HRD50, Titan 2T, Yamaha Aerox, Axis, BW'S, DT50R, Jog, Jog R AC, Jog RR LC, Neo's 2T, Slider AC, TZR50, 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 = '15887' AND p2c.products_id != '15887' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]