Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Add Comment
Please, Sign In to add comment