Pages in cat not edited by specific users

Fork of Pages in cat not edited by specific users by Cryptic

This query is marked as a draft This query has been published by Qwerfjkl.

10000 pages (of 1 913 871) in [[Category:Pages using WikiProject banner shell without a project-independent quality rating]] that have never been edited by either [[User:Qwerfjkl (bot)]] nor [[User:Cewbot]].

For [[WP:RAQ#Pages in category that haven't been edited by specific users]] circa 5 February 2024.

SQL

SELECT page_namespace, page_title
FROM categorylinks
JOIN page ON page_id = cl_from AND page_namespace = 1 AND page_is_redirect = 0
LEFT JOIN page_props ON pp_page=page_id AND pp_propname="disambiguation"
WHERE cl_to = 'Pages_using_WikiProject_banner_shell_without_a_project-independent_quality_rating'
  AND NOT EXISTS
  (SELECT 1
   FROM revision_userindex
   JOIN actor_revision ON actor_id = rev_actor
   WHERE rev_page = page_id
     AND actor_name IN ('Qwerfjkl (bot)', 'Cewbot')
   LIMIT 1)
ORDER BY RAND()
LIMIT 1000;

SQL

Checking query status...