Fork of
Pagelinks to redirected categories
by Belteshassar
This query is marked as a draft
This query has been published
by Belteshassar.
SQL
AخA
select distinct page.page_title as category
from page
join pagelinks
on pagelinks.pl_title=page.page_title
and pagelinks.pl_namespace=page.page_namespace
where pl_namespace = 14
and pl_from_namespace = 100
and page.page_is_redirect;
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.