My QA has met a large number of spam answers to some question. After reviewing the site anti-spam policies, I decide to bulk delete spam contents using the following SQL querry:
delete from qa_posts where parentid=spam-post-id and userid is NULL;
But I forgot changing the type of spam content to hidden. This affects on QA stats, the total answer of question still includes spam content numbers.
How should I do to fix this issue ?