Kategorien

SELECT cat.id, cat.parentid, cat.cat, cat.cat_img, COUNT(1) as total_products_in_category FROM products pk INNER JOIN categories cat ON cat.id = pk.category WHERE cat.parentid = '128701' GROUP by cat.id ORDER BY `cat`.`cat` ASC;SELECT cat.id, cat.parentid, cat.cat, cat.cat_img, COUNT(1) as total_products_in_category FROM products pk INNER JOIN categories cat ON cat.id = pk.category WHERE cat.parentid = '100353523' GROUP by cat.id ORDER BY `cat`.`cat` ASC;SELECT cat.id, cat.parentid, cat.cat, cat.cat_img, COUNT(1) as total_products_in_category FROM products pk INNER JOIN categories cat ON cat.id = pk.category WHERE cat.parentid = '100565313' GROUP by cat.id ORDER BY `cat`.`cat` ASC;

Food & Grocery

Home > Cars & Other Vehicles > Car Parts & Accessories > Car Parts, Accessories and Styling

Brembo Bremsscheibe Vorne Rechts Links Gelocht/innenbel. 370mm Für Audi 8s0615301l 8s0615301c 8s0615301e 09.D174.43

283,35 EUR

Beschreibung

BREMBO Bremsscheibe Bremsscheibenart:Bremsscheibe zweiteilig Bremsscheibenart:Gelocht/innenbel. Bearbeitung:hochgekohlt Bremsscheibendicke [mm]:34 mm Lochanzahl:5 Oberfläche:beschichtet Zentrierungsdurchmesser [mm]:65 mm Höhe [mm]:50 mm Außendurchmesser [mm]:370 mm Mindestdicke [mm]:32,4 mm , u.a. für Audi TT (FV3, FVP), 2480 cm³, 400 PS (294 kW), ab 10/2016, KBA-Nr: 1860AADAudi TT (FV9, FVR), 2480 cm³, 400 PS (294 kW), ab 10/2016, KBA-Nr: 1860AAE , OE-Nummer:BRECO:BZ 9554AP:20284 ZZIMMERMANN:100338370

Produkte, die Ihnen gefallen könnten.