Declined AfC Title Submissions (past 30 days)

Fork of Declined AfC Submissions (based on jtmorgan query) by Dwmc

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

This query lists all declined AfC submissions declined during the past 30 days by the AfC Helper script. It works by  reading the edit comment associated with each declined submission. 

It should capture almost everything, and exclude submissions that were initially declined, but subsequently accepted, during the past 30 days.

SQL

SELECT * FROM recentchanges WHERE
    rc_title LIKE "%contraception%" AND
    rc_namespace in (2, 118) AND
    (rc_comment LIKE "Declining submission:%" OR
     rc_comment LIKE "%Publishing accepted [[Wikipedia:Articles for creation|%")
#    rc_comment LIKE "Declining submission:%" AND
#    rc_title NOT IN (SELECT rc_title FROM recentchanges WHERE 
#                     rc_comment LIKE "%Publishing accepted [[Wikipedia:Articles for creation|%")
ORDER BY rc_title,rc_timestamp;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...