WP:NPPSORT - Quarry

SQL

SELECT page_title,
       DATE_FORMAT(rev_timestamp, '%Y-%m-%d') AS creation_date,
       page_latest,
       page_len                               AS bytecount,
       actor_name                             AS creator,
       user_editcount                         AS creatorEdits,
       (SELECT 1 from page afds
        WHERE page_namespace = 4
        AND afds.page_title = CONCAT('Articles_for_deletion/', p.page_title)
        AND afds.page_id NOT IN  (
            SELECT cl_from FROM categorylinks
            WHERE cl_to = 'AfD_debates'
        )
       ) AS has_prior_afd
FROM pagetriage_page
JOIN page p on page_id = ptrp_page_id
JOIN revision ON page_id = rev_page AND rev_parent_id = 0
JOIN actor_revision ON rev_actor = actor_id
LEFT JOIN user ON user_id = actor_user
LEFT JOIN categorylinks ON cl_from = page_id AND cl_to = 'All_redirects_for_discussion'
WHERE page_namespace = 0
AND page_is_redirect = 0
AND ptrp_reviewed = 0
AND cl_to IS NULL
SQL

Checking query status...
