wikiproject_redirects.ns1.5.hql

select page_title, rd_title, rd_namespace from mediawiki_page inner join mediawiki_redirect on (mediawiki_page.page_id = mediawiki_redirect.rd_from and mediawiki_page.wiki_db = 'enwiki' and mediawiki_page.snapshot = '2019-11' and mediawiki_page.page_namespace = 10 and mediawiki_redirect.rd_title rlike '(?i)^wikiproject_' and mediawiki_redirect.rd_title not rlike '(?i)(\/doc|\/sandbox|\/class|\/test|\/assessment|\/testcases|\/to_do|\/todo|\/navbox|\/nav|\/category_list)$' and mediawiki_redirect.rd_title not rlike '(?i)\/userbox' and mediawiki_redirect.wiki_db = 'enwiki' and mediawiki_redirect.snapshot = '2019-11');