Pastoid

SELECT imprint_year, count(*) AS ct FROM ( 
SELECT pi_year.value AS imprint_year, pi_season.value AS imprint_season
FROM habari__posts p 
INNER JOIN habari__posttype pt ON p.content_type = pt.id AND pt.name = 'page'
INNER JOIN habari__postinfo pi_year ON p.id = pi_year.`post_id` AND pi_year.name = 'year'
INNER JOIN habari__postinfo pi_season ON p.id = pi_season.`post_id` AND pi_season.name = 'season'
INNER JOIN habari__poststatus ps ON p.STATUS = ps.id AND ps.name = 'published'
ORDER BY pi_year.value DESC, pi_season.value ASC
LIMIT 1, 15
) imprint_data
GROUP BY imprint_year
ORDER BY imprint_year DESC
LIMIT 3