Q&A about the site for Joomla! administrators, users, developers and designers
SELECT PostTypeId, COUNT(*) as NrOfPosts FROM posts GROUP BY PostTypeId;