[enwiki] WikiProject takeover candidates

SQL

SELECT p.page_title
FROM page AS p
LEFT JOIN (
    SELECT r1.rev_page
    FROM revision AS r1
    INNER JOIN actor AS a1 ON r1.rev_actor = a1.actor_id
    INNER JOIN user AS u ON a1.actor_user = u.user_id
    LEFT JOIN user_groups AS ug ON u.user_id = ug.ug_user AND ug.ug_group = 'bot'
    WHERE r1.rev_timestamp >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 3 YEAR), '%Y%m%d%H%i%s')
    AND ug.ug_user IS NULL
) AS recent_edits
ON p.page_id = recent_edits.rev_page
WHERE p.page_namespace = 4
AND p.page_title LIKE 'WikiProject%'
AND recent_edits.rev_page IS NULL
AND NOT EXISTS (
    SELECT *
    FROM page AS sub_p
    LEFT JOIN (
        SELECT r2.rev_page
        FROM revision AS r2
        INNER JOIN actor AS a2 ON r2.rev_actor = a2.actor_id
        INNER JOIN user AS u2 ON a2.actor_user = u2.user_id
        LEFT JOIN user_groups AS ug2 ON u2.user_id = ug2.ug_user AND ug2.ug_group = 'bot'
        WHERE r2.rev_timestamp >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 3 YEAR), '%Y%m%d%H%i%s')
        AND ug2.ug_user IS NULL
    ) AS sub_recent_edits
    ON sub_p.page_id = sub_recent_edits.rev_page
    WHERE sub_p.page_namespace = 4
    AND sub_p.page_title LIKE CONCAT(p.page_title, '/%')
    AND sub_recent_edits.rev_page IS NOT NULL
)
ORDER BY p.page_title;
SQL

Checking query status...
