SELECT Persons.id, Persons.name, MIN(Results.average), concat(Competitions.YEAR,'-',LPAD(Competitions.endmonth,2,'00'),'-',LPAD(Competitions.endday,2,'00')) AS cdate, datediff(DATE(now()), concat(Competitions.YEAR,'-',LPAD(Competitions.endmonth,2,'00'),'-',LPAD(Competitions.endday,2,'00'))) AS age FROM Results JOIN Persons ON Persons.id = personId JOIN Competitions ON Competitions.id = competitionId WHERE eventId = '333' AND average > 0 AND datediff(DATE(now()), concat(Competitions.YEAR,'-',LPAD(Competitions.endmonth,2,'00'),'-',LPAD(Competitions.endday,2,'00'))) < 365 GROUP BY personId ORDER BY average