Can I delete queued posts directly from the mysql table?

Question

It's very annoying to manually hide and delete posts that are marked as spam by akismet spam filter. akismet just put the posts into the moderation queue. So my question is, can I simply delete those entries from the qa_posts table or are there correlations to other tables, that would cause problems?

Comments

Would be great if someone could post the SQL for this ;-)

Answer 1

I think it is safe, but stats such as number of user's questions, user points, or number of category questions won't be updated. so you will have to visit "admin > stats" to recalculate them. *** backup your DB before doing this