Zubehör nach Marken

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 = 'Nav1' AND Shop_Rubrik.Nav = 53 ORDER BY Shop_Rubrik.Sort desc