Wikipedia:Database reports/Stale drafts

SQL

SELECT CONCAT('Draft:', page_title)                                                                 AS Page,
       page_len                                                                                     AS Length,
       (SELECT COUNT(*) FROM revision WHERE rev_page = page_id LIMIT 50)                            AS Revisions,
       DATE_FORMAT(rev_timestamp, '%Y-%m-%d')                                                       AS "Last edit",
       (SELECT COUNT(*) FROM pagelinks WHERE pl_namespace = 118 AND pl_title = page_title LIMIT 50) AS Links,
       IF(COUNT(IF(cl_to = 'Draft_articles', 1, NULL)) > 0, "Yes", "No")                            AS Tagged,
       IF(COUNT(IF(cl_to LIKE '%AfC_submissions%', 1, NULL)) > 0, "Yes", "No")                      AS "AfC?",
       page_title                                                                                   AS Mainspace
FROM page
         JOIN revision ON rev_page = page_id AND rev_id = page_latest
         LEFT JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 118
  AND page_is_redirect = 0
  AND rev_timestamp < DATE_FORMAT(NOW() - INTERVAL 6 MONTH, '%Y%m%d%H%i%S')
GROUP BY page_id
SQL

Checking query status...
