Q&A about the site for Ubuntu users and developers
select count(*) as 'spam posts' from posts where posttypeID = 1 and closeddate is not null;