SQL
AخA
SELECT page_title
FROM page AS p1
WHERE p1.page_namespace = 0
AND p1.page_title RLIKE '(?i)(2020_(Summer_)?(O|Para)lympics|Tokyo_2020)'
AND p1.page_is_redirect = 0
AND NOT EXISTS (SELECT 1 FROM redirect
JOIN page AS p2 ON p2.page_id = rd_from
WHERE rd_namespace = 0
AND rd_title = p1.page_title
AND p2.page_namespace = 0
AND p2.page_title = REPLACE(p1.page_title, '2020', '2021'));
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.