gistfile1.sql

SELECT habari__postinfo.value, count(habari__posts.id) from habari__posts 
INNER join habari__posttype on habari__posts.content_type = habari__posttype.id and habari__posttype.name = 'page'
inner join habari__postinfo on habari__posts.id = habari__postinfo.`post_id` and `habari__postinfo`.name = 'year'
INNER JOIN habari__poststatus on habari__posts.status = habari__poststatus.id and habari__poststatus.name = 'published'
group by habari__postinfo.value
ORDER BY habari__postinfo.value DESC