Reasons why Userspace AfC submissions were declined

Fork of Reasons why Userspace AfC submissions were declined by Jtmorgan

This query is marked as a draft This query has been published by Kn3006.

Last run October 16, 2016

This query counts the number of AfC submissions declined for each reason during the past 30 days by reading the edit comment associated with each declined submission. Includes drafts in "User" namespace.

You can re-run this query and get new data at any time by following these steps:
1. log into quarry.wmflabs.org using your MediaWiki credentials
2. click "fork" on this page. This will create a copy of the query associated with your own account.
3. go to the new version of the query that you just created and click "Submit Query"

SQL

use enwiki_p;

select count(rc_id) as declines, rc_comment 
from recentchanges 
where rc_namespace  = 2 and rc_comment like "Declining submission:%" 
group by rc_comment order by declines desc;

SQL

Checking query status...