- Tyhjä ostoskori
Yht. 0,00 €
1-09-32-1T / 090804A
TNT -kampiakseli, Piaggio/Gilera
69,90 €
TNT -kampiakseli, täydellinen.
Sopii Aprilia Mojito Custom, Habana, SR50 Fun Master, SR50 Motard 12-, SR50R 05-, SR50 Racing, SR50 Factory, SR50 Sport, SR50 Street, Scabareo 2T ja SportCity One, Derbi Atlantis 02- ja GP1, Gilera Easy Moving, DNA, Ice, Runner, Stalker, Storm ja Typhoon, Italjet Jet Set ja Torpedo, Piaggio Diesis, Fly 2T, Free, Liberty 2T, NRG, NRG Power, NRG MC2, NRG MC2 Extreme, NRG MC3, NTT, Quartz, Sfera, Storm, TPH, TPH-X, Zip, Zip 2, Zip FR, Zip RST ja Zip SP sekä Vespa ET2, LX50 2T, LXV50 2T, Primavera 2T ja S50 2T.
Sopii Aprilia Mojito Custom, Habana, SR50 Fun Master, SR50 Motard 12-, SR50R 05-, SR50 Racing, SR50 Factory, SR50 Sport, SR50 Street, Scabareo 2T ja SportCity One, Derbi Atlantis 02- ja GP1, Gilera Easy Moving, DNA, Ice, Runner, Stalker, Storm ja Typhoon, Italjet Jet Set ja Torpedo, Piaggio Diesis, Fly 2T, Free, Liberty 2T, NRG, NRG Power, NRG MC2, NRG MC2 Extreme, NRG MC3, NTT, Quartz, Sfera, Storm, TPH, TPH-X, Zip, Zip 2, Zip FR, Zip RST ja Zip SP sekä Vespa ET2, LX50 2T, LXV50 2T, Primavera 2T ja S50 2T.
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 = '34849' AND p2c.products_id != '34849' AND pd.language_id = '3' ORDER BY sales_value DESC LIMIT 10
[TEP STOP]