Statement couldn't be produced with sql: SELECT date_format(album.data,'%Y') AS `d` FROM `album` GROUP BY `d` ORDER BY `d` DESC