SELECT Name, Strasse, Stadt, Bundesland, Telefon, IF(Priority = 1, Name, Stadt) AS sortFlag FROM kunden ORDER BY Priority, Sortflag;