Q&A about the site for administrators, end users, developers and designers for Craft CMS
-- 5: How many posts are voted as spam? SELECT COUNT(Posts.Id) FROM Votes RIGHT JOIN Posts on Posts.Id = Votes.PostId WHERE VoteTypeId = 12