Pages in cat not edited by specific users

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

WITH ns(ns_n, ns_s) AS (VALUES (-2, 'Media:'), (-1, 'Special:'), (0, ''), (1, 'Talk:'), (2, 'User:'), (3, 'User talk:'), (4,
  'Wikipedia:'), (5, 'Wikipedia talk:'), (6, ':File:'), (7, 'File talk:'), (8, 'MediaWiki:'), (9, 'MediaWiki talk:'), (10, 'Template:'),
  (11,  'Template talk:'), (12, 'Help:'), (13, 'Help talk:'), (14, ':Category:'), (15, 'Category talk:'), (100, 'Portal:'), (101,
  'Portal talk:'), (118, 'Draft:'), (119, 'Draft talk:'), (710, 'TimedText:'), (711, 'TimedText talk:'), (828, 'Module:'), (829,
  'Module talk:'), (2300, 'Gadget:'), (2301, 'Gadget talk:'), (2302, 'Gadget definition:'), (2303, 'Gadget definition talk:'))
SELECT CONCAT(COALESCE(ns_s, '?:'), page_title)
FROM categorylinks
JOIN page ON page_id = cl_from
LEFT JOIN ns ON ns_n = page_namespace
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)
LIMIT 10000;

SQL

Checking query status...