Patrollers who didn't sign 2022 WMF letter

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;

SQL

Checking query status...