User:SDZeroBot/Pending AfC submissions

SQL

        SELECT page_title, page_latest, cl_sortkey_prefix, actor_name, rev_timestamp, user_editcount,
               (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 prior_afd
        FROM page p
		JOIN categorylinks ON page_id = cl_from
		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
        WHERE cl_to = 'Pending_AfC_submissions'
        AND page_namespace = 118;
SQL

Checking query status...
