Unneeded confirmed rights

SQL

SELECT pg.page_title, pg.page_is_redirect, cl_to
FROM categorylinks cl
JOIN page AS pg ON cl_from = page_id
WHERE cl_to IN (
  SELECT page_title
  FROM page pg2
  JOIN categorylinks cl2 ON pg2.page_id = cl2.cl_from
  WHERE cl_to = 'All_redirect_categories'
)
AND page_is_redirect = 0
AND page_namespace = 0
AND cl_from NOT IN (
  SELECT cl_from
  FROM categorylinks cl3
  WHERE cl_to IN (
    'All_redirects_for_discussion',
    'Wikidata_redirects',
    'Wikipedia_interwiki_soft_redirects',
    'Wikipedia_soft_redirects'
  )
)
SQL

Checking query status...
