Q&A for administrators, end users, developers and designers for Craft CMS
select count(distinct posts.Id) from posthistory inner join posts on posts.id = posthistory.postid where posthistorytypeid= 16 and posts.posttypeid=1 and tags like '%<api>%'