Patrollers who didn't sign 2022 WMF letter

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

All users with the patroller userright (and not the bot userright), who have neither their user page nor user talk page directly linked from [[Wikipedia:New pages patrol/Coordination/2022 WMF letter]].

Beware alternate accounts - for example, DGGnyc is listed, even though DGG signed the petition. Users whose sig contains only a redirect to their user or user talk page instead of linking one directly will also be listed here.

For [[Wikipedia talk:New pages patrol/Coordination#Too many inactive Reviewers]] circa 12 September 2022.

SQL

SELECT user_name
FROM user_groups
JOIN user ON user_id = ug_user
LEFT JOIN pagelinks
  ON pl_namespace IN (2, 3)
 AND pl_title = REPLACE(user_name, ' ', '_')
 AND pl_from = (SELECT page_id
                FROM page
                WHERE page_namespace = 4
                  AND page_title = 'New_pages_patrol/Coordination/2022_WMF_letter')
WHERE ug_group = 'patroller'
  AND pl_from IS NULL
  AND NOT EXISTS (SELECT 1
                  FROM user_groups
                  WHERE ug_user = user_id
                    AND ug_group = 'bot')
ORDER BY user_name ASC;

AخA
 
SELECT user_nameFROM user_groupsJOIN user ON user_id = ug_userLEFT JOIN pagelinks  ON pl_namespace IN (2, 3) AND pl_title = REPLACE(user_name, ' ', '_') AND pl_from = (SELECT page_id                FROM page                WHERE page_namespace = 4                  AND page_title = 'New_pages_patrol/Coordination/2022_WMF_letter')WHERE ug_group = 'patroller'  AND pl_from IS NULL  AND NOT EXISTS (SELECT 1                  FROM user_groups                  WHERE ug_user = user_id                    AND ug_group = 'bot')ORDER BY user_name ASC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...