- Tyhjä ostoskori
Yht. 0,00 €
D-80-219703
COMET -kytkin, Yamaha Phazer GT 07-10
556,90 €
Comet kytkinpaketti.
Sopii Yamaha CS340 Ovation 98-99, EX 570 Exciter 90, EX 570 Exciter II 91-93, EX 570 Exciter II ST 93, EX 570 Exciter II SX 93, Mountain Max 600 98-02, Mountain Max 700 98-02, Phazer 08, Phazer FX 07, Phazer GT 07-10, Phazer Mountain Lite 07, PZ500 Phazer 99-01, RS Rage 05, RS Vector 05-08, RS Vector ER 05, RS Vector GT 08, RS Vector L-TX 08, RS Vector L-TX GT 08, RS Vector Mountain 05, RS Venture 05-10, RS Venture GT 08, RS Viking Professional 08-10, RX Apex 08-10, RX Apex GT 08-10,RX Apex L-TX 08-10, RX Apex L-TX GT 08-10, RX Apex M-TX 08, RX Apex M-TX SE 08, RX Apex R-TX 08, RX-1 03, RX-1 ER 03, RX-1 Mountain 03, SRX 600 98-99, SRX 700 98-02, SRX 700 Mountain 98, SX 600 Venom 04-06, SX 700 Viper 02-04, SX 700 Viper Mountain 03-06, SX 700R 00-01, VMAX 500 94-01, VMAX 500 SX 99, VMAX 500 XT 98, VMAX 500 XTC 98, VMAX 600 00-03, VMAX 600 SX 97-99, VMAX 700 99-02, VMAX 700 Mountain Max 97, VMAX 700 SX 97, VMAX 700 XT 98, VMAX 700 XTC 98, VT500 Venture 97-01, VT500 Venture XL 99-01, VT600 Venture 97-06 ja VT700 Venture 98-04.
Huom! Kuva viitteellinen.
Maahantuojan suositushinta 619,00e
Sopii Yamaha CS340 Ovation 98-99, EX 570 Exciter 90, EX 570 Exciter II 91-93, EX 570 Exciter II ST 93, EX 570 Exciter II SX 93, Mountain Max 600 98-02, Mountain Max 700 98-02, Phazer 08, Phazer FX 07, Phazer GT 07-10, Phazer Mountain Lite 07, PZ500 Phazer 99-01, RS Rage 05, RS Vector 05-08, RS Vector ER 05, RS Vector GT 08, RS Vector L-TX 08, RS Vector L-TX GT 08, RS Vector Mountain 05, RS Venture 05-10, RS Venture GT 08, RS Viking Professional 08-10, RX Apex 08-10, RX Apex GT 08-10,RX Apex L-TX 08-10, RX Apex L-TX GT 08-10, RX Apex M-TX 08, RX Apex M-TX SE 08, RX Apex R-TX 08, RX-1 03, RX-1 ER 03, RX-1 Mountain 03, SRX 600 98-99, SRX 700 98-02, SRX 700 Mountain 98, SX 600 Venom 04-06, SX 700 Viper 02-04, SX 700 Viper Mountain 03-06, SX 700R 00-01, VMAX 500 94-01, VMAX 500 SX 99, VMAX 500 XT 98, VMAX 500 XTC 98, VMAX 600 00-03, VMAX 600 SX 97-99, VMAX 700 99-02, VMAX 700 Mountain Max 97, VMAX 700 SX 97, VMAX 700 XT 98, VMAX 700 XTC 98, VT500 Venture 97-01, VT500 Venture XL 99-01, VT600 Venture 97-06 ja VT700 Venture 98-04.
Huom! Kuva viitteellinen.
Maahantuojan suositushinta 619,00e
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 = '99236' AND p2c.products_id != '99236' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]