- Tyhjä ostoskori
Yht. 0,00 €
1-32-19-20 / 246140030
Jarruvalokatkaisin, Derbi Senda, etu (muovinen)
3,90 €
Jarruvalokatkaisin, kahvarunkoon.
Sopii Aprilia Amico, Area 51, Habana, Mojito, Rally, RX50, Sonic, SR50, SR50 R, SR50 Factory, SR50 Street, SR50 Stealth, SR50 WWW ja SX50, Beta RR, Bultaco Lobito, Derbi Atlantis, Boulevard, GP1, DRD Black Devil, DRD Extreme 10-17, DRD Racing, DRD Pro, Senda R/SM, Senda Racer, Senda Black Edition, Senda X-Race ja Senda X-Treme, Drac RR, Gilera DNA, H@k -02, Ice, RCR, Runner, Runner Purejet, SMT, Stalker, Storm ja Typhoon, Malaguti XSM ja XTM, MBK Booster, Flipper, Mach, Nitro, Ovetto, Stunt ja X-Limit, Motorhispania RX50, RYZ ja Furia, Peugeot Buxy, Citystar, Django, Elyseo, Elystar, Gipsy, JetForce, Kisbee, Ludix, Ludix 2, Limbo, Looxor, Rapido, Reggea, Speedake, Speedfight 1, Speedfight 2, Speedfight 3, Speedfight 4, Splinter, Squab, SV50, TKR, Trekker, Tweet, Vivacity, V-Clic, XPS, XR6 ja Zenith, Rieju MRX, RS2, SMX, Spike ja Tango, Piaggio Diesis, Fly, Free, Liberty, NRG, NRG MC2, MC3, NRG Power DD ja Pure Jet, Sfera, Zip, Zip FR ja SP, Vespa ET2, ET4, LX50, LXV50, Primavera ja S50 sekä Yamaha Aerox, BW'S, DT50 98-, Jog R, Neo's, Slider ja TZR50.
Sopii Aprilia Amico, Area 51, Habana, Mojito, Rally, RX50, Sonic, SR50, SR50 R, SR50 Factory, SR50 Street, SR50 Stealth, SR50 WWW ja SX50, Beta RR, Bultaco Lobito, Derbi Atlantis, Boulevard, GP1, DRD Black Devil, DRD Extreme 10-17, DRD Racing, DRD Pro, Senda R/SM, Senda Racer, Senda Black Edition, Senda X-Race ja Senda X-Treme, Drac RR, Gilera DNA, H@k -02, Ice, RCR, Runner, Runner Purejet, SMT, Stalker, Storm ja Typhoon, Malaguti XSM ja XTM, MBK Booster, Flipper, Mach, Nitro, Ovetto, Stunt ja X-Limit, Motorhispania RX50, RYZ ja Furia, Peugeot Buxy, Citystar, Django, Elyseo, Elystar, Gipsy, JetForce, Kisbee, Ludix, Ludix 2, Limbo, Looxor, Rapido, Reggea, Speedake, Speedfight 1, Speedfight 2, Speedfight 3, Speedfight 4, Splinter, Squab, SV50, TKR, Trekker, Tweet, Vivacity, V-Clic, XPS, XR6 ja Zenith, Rieju MRX, RS2, SMX, Spike ja Tango, Piaggio Diesis, Fly, Free, Liberty, NRG, NRG MC2, MC3, NRG Power DD ja Pure Jet, Sfera, Zip, Zip FR ja SP, Vespa ET2, ET4, LX50, LXV50, Primavera ja S50 sekä Yamaha Aerox, BW'S, DT50 98-, Jog R, Neo's, Slider ja TZR50.
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 = '8608' AND p2c.products_id != '8608' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]