Endrohre zum Anschrauben

» Auspuffanlagen / Endrohre

SELECT Shop.*, Shop_Rubrik.Sort FROM (Shop INNER JOIN Shop_Rubrik ON Shop.ID = Shop_Rubrik.Shop) WHERE Shop.Active = 1 AND Shop.Status = 1 AND Shop_Rubrik.Typ = 'Nav2' AND Shop_Rubrik.Nav = 120 ORDER BY Shop_Rubrik.Sort desc