Anfrage: SELECT DISTINCT task.*, firma.Firma FROM (task LEFT JOIN firma ON task.Nummer = firma.Nummer) WHERE date_format(task.Datum, '%Y')='1959' ASC Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ASC' at line 1