Fork of
tpmp9 page redirects, talk exists
by Saeidpourbabak
This query is marked as a draft
This query has been published
by Saeidpourbabak.
SQL
AخA
use fawiki_p;
select t.page_title, t.page_len
from page as t
where t.page_namespace = 1
and t.page_is_redirect = 0
and exists (
select null
from page as p
where p.page_namespace = 0
and p.page_title = t.page_title
and p.page_is_redirect = 1
)
and page_title like "قنات_%"
ORDER BY t.page_len DESC;
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.