- Tyhjä ostoskori
Yht. 0,00 €
TIT-VA020010106
Jarrupalat, sinter offroad, 020010106
16,90 €
Vastaa ProX 37.103202 sekä SBS 694RSI ja 694SI -jarrupaloja.
Titan VA020010106
Sopii eteen: Apollo Orion RX50, Aprilia MXV450 09-, RXV450 06- ja RXV550 06-, Beta RR250 Enduro 05-, RR350 Enduro 12-, RR400 Enduro 05-, RR450 Cross Country 12-, RR450 Enduro 05-, RR498 Enduro 12- ja RR525 Enduro 05-, GasGas 125 Enducross 93-, EC125 00-, MC125 03-, EC200 00-, EC200 Hobby 07-, EC250 00-11, EC250 12-, EC250 FSE 02-, MC250 00-, EC300 00-11, EC300 12-, 400 Pampera 06-, EC400 FSE 02, EC450 FSE 03-, EC450 FSR 07- ja EC 515 FSR 08-, Honda CR125 95-,CRF125 F 14-23, CRF150F 03-, CRF230 04-09, CRF230L 08-, CRF230M 09-, CR250 95-, CRF250R 04-, CRF250X 04-, CRF450R 02-, CRF450X 05- ja CR500 95-, Kawasaki KX125 94-, KDX200 94-99, KDX220R 97-, KLX250 98-07, KLX250 93-96, KX250 94-, KXF250 04-, KLX300R 97-, KLX400R 03-, KLX450R 07-, KXF450 06-, KX500 94-, KLX650 93-96 ja KLX650R 93-96, Suzuki RM125 96-, DRZ250 01-, RM250 96-, RMX250 96-, RMZ250 04-, DR350 97-, DRZ400 00-, RMX450Z 10-, RMZ450 05- ja DR650SE 96-, Titan F18 sekä Yamaha WR125 98-02, YZ125 98-, WR250 98-02, WRF250 01-, WR250R 08-, YZ250 98-, YZF250 01-06, WRF400 98-00, YZF400 98-99, WRF426 01-02, YZF426 00-02, WRF450 03- sekä YZF450 03-07.
Titan VA020010106
Sopii eteen: Apollo Orion RX50, Aprilia MXV450 09-, RXV450 06- ja RXV550 06-, Beta RR250 Enduro 05-, RR350 Enduro 12-, RR400 Enduro 05-, RR450 Cross Country 12-, RR450 Enduro 05-, RR498 Enduro 12- ja RR525 Enduro 05-, GasGas 125 Enducross 93-, EC125 00-, MC125 03-, EC200 00-, EC200 Hobby 07-, EC250 00-11, EC250 12-, EC250 FSE 02-, MC250 00-, EC300 00-11, EC300 12-, 400 Pampera 06-, EC400 FSE 02, EC450 FSE 03-, EC450 FSR 07- ja EC 515 FSR 08-, Honda CR125 95-,CRF125 F 14-23, CRF150F 03-, CRF230 04-09, CRF230L 08-, CRF230M 09-, CR250 95-, CRF250R 04-, CRF250X 04-, CRF450R 02-, CRF450X 05- ja CR500 95-, Kawasaki KX125 94-, KDX200 94-99, KDX220R 97-, KLX250 98-07, KLX250 93-96, KX250 94-, KXF250 04-, KLX300R 97-, KLX400R 03-, KLX450R 07-, KXF450 06-, KX500 94-, KLX650 93-96 ja KLX650R 93-96, Suzuki RM125 96-, DRZ250 01-, RM250 96-, RMX250 96-, RMZ250 04-, DR350 97-, DRZ400 00-, RMX450Z 10-, RMZ450 05- ja DR650SE 96-, Titan F18 sekä Yamaha WR125 98-02, YZ125 98-, WR250 98-02, WRF250 01-, WR250R 08-, YZ250 98-, YZF250 01-06, WRF400 98-00, YZF400 98-99, WRF426 01-02, YZF426 00-02, WRF450 03- sekä YZF450 03-07.
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 = '27586' AND p2c.products_id != '27586' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]