Non-redirects in redirect only category (wide)

Fork of Non-redirects in redirect only category (narrow) by Novem Linguae

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

TODO:
- exclude soft redirects / Wiktionary redirects (for example, https://en.wikipedia.org/wiki/%F0%9F%94%9E )
- having one bad category such as RFD or soft redirect should disqualify the page completely. right now I suspect the query looks at page + cat combos, not page only

Once working, can post this at WP:AWBREQ

SQL

SELECT page_title, cl_to
FROM categorylinks
JOIN page ON page_namespace = 0 AND page_is_redirect = 0 AND page_id = cl_from
-- mainly trying to find pages that aren't a redirect but have the categories placed by {{R from X}} / {{R to X}} type templates
WHERE cl_to LIKE "Redirects_%"
-- exclude pages at RFD right now, which will not be redirects due to the RFD notice, but which are OK to have redirect categories
AND cl_to NOT LIKE "Redirects_for_discussion%"

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...