Anfrage fehlgeschlagen: SELECT  
CONCAT(LS_TeamGroups.TeamGroups_Tag,' gegen ',LS_Organisation_1.TeamGroups_Tag,' <small>',Leagues_ShortTag,'<small>') as orgs,concat('',concat(LS_TeamGroups.TeamGroups_Tag , concat(' gegen ',LS_Organisation_1.TeamGroups_Tag))) as orgs2, LS_Games.Games_ID, concat(LS_Games_Description.Games_Description_Date,' ',LS_Games_Description.Games_Description_Time) as Games_Description_Date,LS_Games_Description.Games_Description_DeadlineTimestamp, LS_Games_Description.Games_Description_Time, LS_Games.Games_StatusID, LS_Games.Games_Accepted, LS_Leagues.Leagues_ShortTag
FROM (((LS_Games LEFT JOIN LS_TeamGroups ON LS_Games.Games_HomeTeamID = LS_TeamGroups.TeamGroups_ID) LEFT JOIN LS_TeamGroups AS LS_Organisation_1 ON LS_Games.Games_GuestTeamID = LS_Organisation_1.TeamGroups_ID) LEFT JOIN LS_Games_Description ON LS_Games.Games_ID = LS_Games_Description.Games_Description_GameID) LEFT JOIN LS_Leagues ON LS_Games.Games_LeaguesID =Leagues_ID
where Games_Description_Date >='20241121000000' and Games_StatusID=50  and Leagues_GroupID=1
        
        
        
        
        
        
        
        
        
        
        
        
        
        
            GROUP BY Games_ID order by ergebnis asc,Games_Description_Date  asc,Games_Description_Time  Unknown column 'ergebnis' in 'order clause'