Pages linked from given page, not in given cat or linked from another given page

Bluelinks on [[Green Bay Packers All-Time Roster]] going to pages that aren't in [[:Category:Green Bay Packers players]] and that aren't linked from {{Green Bay Packers}}.

Redirects will show up on this list (unless the redirect itself is categorized).  Redlinks will not.

For [[WP:RAQ#Cross Reference Request]] circa 19 September 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:'), (126, 'MOS:'), (127, 'MOS talk:'), (710, 'TimedText:'), (711, 'TimedText talk:'),
  (828, 'Module:'), (829, 'Module talk:'))
SELECT CONCAT(COALESCE(ns_s, '?:'), REPLACE(tgt.page_title, '_', ' ')) AS title
FROM pagelinks AS pl1
JOIN page AS src ON src.page_id = pl1.pl_from AND src.page_namespace = 0 AND src.page_title = 'Green_Bay_Packers_All-Time_Roster'
JOIN linktarget ON lt_id = pl1.pl_target_id
JOIN page AS tgt ON tgt.page_namespace = lt_namespace AND tgt.page_title = lt_title
LEFT JOIN categorylinks ON cl_from = tgt.page_id AND cl_to = 'Green_Bay_Packers_players'
LEFT JOIN ns ON ns_n = tgt.page_namespace
WHERE cl_from IS NULL
  AND NOT EXISTS (SELECT 1
                  FROM pagelinks AS pl2
                  JOIN page AS tm ON tm.page_id = pl2.pl_from AND tm.page_namespace = 10 AND tm.page_title = 'Green_Bay_Packers'
                  WHERE pl2.pl_target_id = pl1.pl_target_id)
ORDER BY ns_n ASC, tgt.page_title ASC;

SQL

Checking query status...