keine Veranstaltungen für diese Kriterien gefunden: (year(e.edate) = '2021'
SELECT distinct e.id , year(e.edate) as eyyyy, month(e.edate) as emm, dayofweek(e.edate) as edayofweek, e.edate , year(e.edate2) as eyyyy2, month(e.edate2) as emm2, dayofweek(e.edate2) as edayofweek2, e.edate2 , e.* FROM oea_events e LEFT JOIN oea_competitions c ON c.event_id = e.id LEFT JOIN oea_winners wc ON wc.row_id = c.id and wc.table_id = '2' LEFT JOIN oea_persons pc ON pc.id = wc.person_id LEFT JOIN oea_runs r ON r.competition_id = c.id LEFT JOIN oea_winners wr ON wr.row_id = r.id and wr.table_id = '3' LEFT JOIN oea_persons pr ON pr.id = wr.person_id LEFT JOIN oea_runmaps rm ON rm.run_id = r.id LEFT JOIN oea_maps m ON rm.map_id = m.id Where year(e.edate) = '2021' ORDER BY eyyyy desc, emm desc, e.edate desc, name desc)