Declined AfC Title Submissions (all time)

Fork of Declined AfC Title Submissions (past 30 days) by Dwmc

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

This query lists 5 declined AfC submissions declined by the AfC Helper script. It works by reading the edit comment associated with each declined submission.

SQL

SELECT * FROM revision r join page p on r.rev_page = p.page_id WHERE
    p.page_title LIKE "%contraception%" AND
    p.page_namespace in (2, 118) AND
    (r.rev_comment LIKE "Declining submission:%" OR
     r.rev_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 p.page_title,r.rev_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...