- Tyhjä ostoskori
Yht. 0,00 €
D-395-03142
Tappokatkaisin, Kawasaki KX
12,90 €
Tappokatkaisin, yleismalli.
Sopii esim. Kawasaki KLX110, KLX450, KX60, KX65, KX85, KX125, KX250, KXF250, KXF450 ja KX500 sekä KTM 60 SX, 65 SX, 85 SX, 125 EXC, 125 SX, 144 SX, 200 EXC, 200 SX, 250 EXC, 250 EXC RACING 4T, 250 SX, 250 SXF, 300 EXC, 300 SX, 380 EXC, 380 SX, 400 EXC RACING, 400 SX RACING, 450 EXC RACING, 450 SX RACING, 450 SXF, 50 SX, 520 EXC RACING, 520 SX RACING, 525 EXC RACING, 525 SX RACING ja 530 EXC.
Sopii esim. Kawasaki KLX110, KLX450, KX60, KX65, KX85, KX125, KX250, KXF250, KXF450 ja KX500 sekä KTM 60 SX, 65 SX, 85 SX, 125 EXC, 125 SX, 144 SX, 200 EXC, 200 SX, 250 EXC, 250 EXC RACING 4T, 250 SX, 250 SXF, 300 EXC, 300 SX, 380 EXC, 380 SX, 400 EXC RACING, 400 SX RACING, 450 EXC RACING, 450 SX RACING, 450 SXF, 50 SX, 520 EXC RACING, 520 SX RACING, 525 EXC RACING, 525 SX RACING ja 530 EXC.
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 = '3256' AND p2c.products_id != '3256' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]