Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Vexations
.
Toggle Highlighting
SQL
SELECT DISTINCT cl_to FROM `pagetriage_page` JOIN `page` ON ptrp_page_id = page_id LEFT JOIN `categorylinks` ON ptrp_page_id = cl_from WHERE page_namespace = 0 AND page_is_redirect = 1 AND ptrp_reviewed = 0 AND cl_to LIKE '%Redirects_to%' AND cl_to NOT IN ('Redirects_from_moves', 'Redirects_to_sections', 'Redirects_from_other_capitalisations', 'Redirects_from_synonyms', 'Redirects_from_subtopics', 'Redirects_with_possibilities', 'Redirects_from_short_names', 'Redirects_to_English-language_terms', 'Redirects_to_disambiguation_pages', 'Redirects_from_titles_without_diacritics', 'Redirects_from_modifications', 'Redirects_from_alternative_spellings', 'Redirects_from_French-language_terms') LIMIT 100;
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
.
Checking query status...