- Tyhjä ostoskori
Yht. 0,00 €
1-41-7-32-2 / 28728
Variaattorin rajoitinprikka, Piaggio/Gilera (2mm)
3,90 €
Variaattorin rajoitinprikka. Koko 20x25x2.0mm.
Sopii Aprilia Mojito Custom, Habana, Scabareo 4T, SR50 DiTech (Piaggio), SR50 Fun Master, SR50 Motard 12-, SR50R 05-, SR50 Racing, SR50 Factory, SR50 Sport, SR50 Street, Scabareo 2T ja SportCity One, Derbi Atlantis 02-, Boulevard ja GP1, Fude 4T, Generic Cracker 4T, Onyx 4T, Pandora 4T, Race 2 GT 4T, Sirion 4T ja Vertigo 4T, Gilera Easy Moving, DNA, Ice, Runner, Stalker, Storm ja Typhoon, Italjet Jet Set ja Torpedo, Jincheng QT-20 Sudoku, Kymco GR1, SA10, SF10, KF10, Agility, Agility RS, DJ50, Filly, Grand Dink, Heroism, Like, Sento 4T, Like 2T, Like 4T, MXU50, MX-ER50, People, People S, People 4T, Super 8, Super 8, Super 9, Top Boy, Vitality, Yup, Yager, ZX50 Fever ja ZX50 Super Fever, Malaguti Centro 4T 09- ja Ciak 4T, Peugeot Buxy, Citystar, Django, Elyseo, Elystar, Gipsy, Jetforce C-Tech, Kisbee, Limbo, Looxor, Ludix, Ludix 2, Metropolis, Rapido, Reggea, Speedake, Speedfight, Speedfight 2, Speedfight 3, Speedfight 4, Splinter, Squab, SV50, TKR, Trekker, Tweet, V-Clic, Vivacity ja Zenith, Piaggio Diesis, Fly, Free, Liberty, NRG, NRG Power, NRG MC2, NRG MC2 Extreme, NRG MC3, NRG Purejet, NTT, Quartz, Sfera, Storm, TPH, TPH-X, Zip, Zip 2, Zip FR, Zip RST ja Zip SP, SYM Allo 4T, Fiddle, Fiddle 2, Flash, Jet 4 4T, Jet 50, Jet BasiX, Jet EuroX, Jet SportX, Jet 4R, Mask, Mio, Orbit, Orbit 2, Pure, Red Devil, Shark RS, Super Fancy, Symphony 4T, Symply 4T, Tonik 4T ja X-Pro 4T, Titan 4T sekä Vespa ET2, ET4, LX50, LXV50, Primavera ja S50.
Sopii Aprilia Mojito Custom, Habana, Scabareo 4T, SR50 DiTech (Piaggio), SR50 Fun Master, SR50 Motard 12-, SR50R 05-, SR50 Racing, SR50 Factory, SR50 Sport, SR50 Street, Scabareo 2T ja SportCity One, Derbi Atlantis 02-, Boulevard ja GP1, Fude 4T, Generic Cracker 4T, Onyx 4T, Pandora 4T, Race 2 GT 4T, Sirion 4T ja Vertigo 4T, Gilera Easy Moving, DNA, Ice, Runner, Stalker, Storm ja Typhoon, Italjet Jet Set ja Torpedo, Jincheng QT-20 Sudoku, Kymco GR1, SA10, SF10, KF10, Agility, Agility RS, DJ50, Filly, Grand Dink, Heroism, Like, Sento 4T, Like 2T, Like 4T, MXU50, MX-ER50, People, People S, People 4T, Super 8, Super 8, Super 9, Top Boy, Vitality, Yup, Yager, ZX50 Fever ja ZX50 Super Fever, Malaguti Centro 4T 09- ja Ciak 4T, Peugeot Buxy, Citystar, Django, Elyseo, Elystar, Gipsy, Jetforce C-Tech, Kisbee, Limbo, Looxor, Ludix, Ludix 2, Metropolis, Rapido, Reggea, Speedake, Speedfight, Speedfight 2, Speedfight 3, Speedfight 4, Splinter, Squab, SV50, TKR, Trekker, Tweet, V-Clic, Vivacity ja Zenith, Piaggio Diesis, Fly, Free, Liberty, NRG, NRG Power, NRG MC2, NRG MC2 Extreme, NRG MC3, NRG Purejet, NTT, Quartz, Sfera, Storm, TPH, TPH-X, Zip, Zip 2, Zip FR, Zip RST ja Zip SP, SYM Allo 4T, Fiddle, Fiddle 2, Flash, Jet 4 4T, Jet 50, Jet BasiX, Jet EuroX, Jet SportX, Jet 4R, Mask, Mio, Orbit, Orbit 2, Pure, Red Devil, Shark RS, Super Fancy, Symphony 4T, Symply 4T, Tonik 4T ja X-Pro 4T, Titan 4T 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 = '32211' AND p2c.products_id != '32211' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]