- Tyhjä ostoskori
Yht. 0,00 €
1-71-03-64 / NK101.98
Naraku -sylinterin pinnapultti, 6x110mm
2,90 €
Sylinterin pinnapultti, Naraku. Kierre M6, pituus 110mm.
Sopii Aprilia Mojito Custom, SR50 DiTech (Piaggio), SR50 Fun Master, SR50 Motard 12-, SR50 R, SR50 Racing, SR50 Sport, SR50 Street, SR50R Factory, Scabareo ja SportCity One, Derbi Atlantis 02- (Piaggio), Boulevard, Bullet ja GP1, Gilera DNA, Ice, Runner, Runner Purejet, Runner SP, Stalker ja Storm, Italjet Jet Set ja Torpedo, MBK Booster ja Stunt, Peugeot Buxy, Citystar, Django 2T, Elyseo, Elystar, Gipsy, JetForce, Kisbee 2T, Ludix, Ludix 2, Limbo, Looxor, Rapido, Reggea, Speedake, Speedfight 1, Speedfight 2, Speedfight 3 2T, Speedfight 4 2T, Splinter, Squab, SV50, TKR, Trekker, Tweet, Vivacity 2T ja Zenith, Piaggio Diesis, Fly, Free, Liberty, NRG, NRG Power, NRG MC2, NRG MC2 Extreme, NRG MC3 Pure Jet, NTT, Quartz, Sfera, Sfera RST, Storm, TPH, TPH-X, Zip, Zip 2, Zip 4T, Zip FR, Zip SP, Zip RST, Yamaha BW'S ja Slider sekä Vespa ET2, ET4, LX50, LXV50, Primavera ja S50.
Sopii Aprilia Mojito Custom, SR50 DiTech (Piaggio), SR50 Fun Master, SR50 Motard 12-, SR50 R, SR50 Racing, SR50 Sport, SR50 Street, SR50R Factory, Scabareo ja SportCity One, Derbi Atlantis 02- (Piaggio), Boulevard, Bullet ja GP1, Gilera DNA, Ice, Runner, Runner Purejet, Runner SP, Stalker ja Storm, Italjet Jet Set ja Torpedo, MBK Booster ja Stunt, Peugeot Buxy, Citystar, Django 2T, Elyseo, Elystar, Gipsy, JetForce, Kisbee 2T, Ludix, Ludix 2, Limbo, Looxor, Rapido, Reggea, Speedake, Speedfight 1, Speedfight 2, Speedfight 3 2T, Speedfight 4 2T, Splinter, Squab, SV50, TKR, Trekker, Tweet, Vivacity 2T ja Zenith, Piaggio Diesis, Fly, Free, Liberty, NRG, NRG Power, NRG MC2, NRG MC2 Extreme, NRG MC3 Pure Jet, NTT, Quartz, Sfera, Sfera RST, Storm, TPH, TPH-X, Zip, Zip 2, Zip 4T, Zip FR, Zip SP, Zip RST, Yamaha BW'S ja Slider sekä Vespa ET2, ET4, LX50, LXV50, Primavera ja S50.
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 = '15886' AND p2c.products_id != '15886' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]