Answered: How to bulk delete/reject questions awaiting moderation?

Post date: 2021-05-03 00:23:38
Views: 93

I don't think the Web UI provides a simple way of doing this, but you can easily remove those posts directly from the database. All posts under moderation have a type ending with the suffix "_QUEUED," so you can use that as the filter for a DELETE query.

DELETE FROM qa_posts WHERE type LIKE "%_QUEUED";

If you want only a particular type of post removed (e.g. only questions), change the filter to that type (e.g. type="Q_QUEUED").

Note that removing posts under moderation directly from the database will not automatically reset the counter for those posts, so you'll have to do that yourself as well.

UPDATE qa_options SET content=0 WHERE title="cache_queuedcount";

Please click Here to read the full story.
 
Other Top and Latest Questions:
Buy this little-known pharma stock with more than 80% upside ahead, RBC says
What will it take to get tech stocks rising again? An unemployment rate above 4%
The highest-paying in-demand jobs that don't require a degree, according to new research
Any good articles about homelessness and "authority" in the US?
The cost of living... with a canine companion
Saturday Night Live: Ryan Gosling / Chris Stapleton
Fallout: The Trap
Express files for bankruptcy, plans to close nearly 100 stores as investor group looks to save the brand
Stocks making the biggest moves midday: Tesla, Verizon, Paramount, Coinbase and more
Russia warns the world is on the brink of a 'direct military clash' between nuclear powers