Q&A about the site for administrators, end users, developers and designers for Craft CMS
select top 100 posttypeid, count(*) from posts group by posttypeid order by count(*) desc