Sport-Luftfilter

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 = 67 ORDER BY Shop_Rubrik.Sort desc