Articles tagged "No Citations" in Special:NewPagesFeed (good candidates for draftification)

SQL

SELECT page_title, rev_timestamp
FROM pagetriage_page
JOIN page ON page_id = ptrp_page_id
JOIN revision ON rev_page = page_id
JOIN pagetriage_page_tags ON ptrpt_page_id = page_id AND ptrpt_tag_id = (
  SELECT ptrt_tag_id
  FROM pagetriage_tags
  WHERE ptrt_tag_name = 'reference' -- "No Citations" tag in PageTriage
)
WHERE rev_parent_id = 0 -- makes rev_timestamp be the article creation date
  AND rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -3 MONTH), "%Y%m%d%H%i%s") -- don't draftify articles older than 90 days, per rules
  AND ptrp_reviewed = 0 -- unreviewed articles
  AND ptrpt_value = 1 -- article has a "No Citations" tag in PageTriage
  AND page_namespace = 0 -- mainspace (no drafts)

SQL

Checking query status...