- Tyhjä ostoskori
Yht. 0,00 €
1-12-38-4000 / 37370
101_Octane -mäntäsarja 40.00mm, CPI SX/SM
44,90 €
Mäntäsarja 12mm tapilla. Halkaisija 40.00mm. Sisältää männän, tapin, sokat sekä männänrenkaat.
Sopii CPI SX ja SM sekä Generic Trigger SM ja Trigger X-Enduro.
Sopii myös Honda Bali, Dio, SFX50, SH50 Scoopy, SXR50 Shadow, SGX50 Sky ja X8R, Kymco GR1, SA10, SF10, KF10, Agility RS 2T, Curio, Dink, DJ50, Grand Dink, Like 2T, MXU50, MX-ER50, People 2T, Super 8 2T, Super 9, Top Boy, Vitality, Yup, Yager, ZX50 Fever ja ZX50 Super Fever sekä SYM DD50, Fancy, Fiddle 2T, Flash, Jet 50, Jet BasiX, Jet EuroX, Jet Evo, Jet SportX, Jet 4R, Jungle, Mask, Pure, Red Devil, Shark RS ja Super Fancy.
Sopii CPI SX ja SM sekä Generic Trigger SM ja Trigger X-Enduro.
Sopii myös Honda Bali, Dio, SFX50, SH50 Scoopy, SXR50 Shadow, SGX50 Sky ja X8R, Kymco GR1, SA10, SF10, KF10, Agility RS 2T, Curio, Dink, DJ50, Grand Dink, Like 2T, MXU50, MX-ER50, People 2T, Super 8 2T, Super 9, Top Boy, Vitality, Yup, Yager, ZX50 Fever ja ZX50 Super Fever sekä SYM DD50, Fancy, Fiddle 2T, Flash, Jet 50, Jet BasiX, Jet EuroX, Jet Evo, Jet SportX, Jet 4R, Jungle, Mask, Pure, Red Devil, Shark RS ja Super Fancy.
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 = '103172' AND p2c.products_id != '103172' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]