Untitled query #37679

SQL

use arwiki_p;
select p.page_title from categorylinks
inner join page p
on p.page_id = cl_from
where p.page_namespace = 0
and cl_to = "Redirects_from_Unicode_characters"
and p.page_is_redirect = 1
and p.page_title in (select arwiki_p.page.page_title from arwiki_p.page where arwiki_p.page.page_namespace = 0
                  and arwiki_p.page.page_is_redirect = 1)
and (select arwiki_p.page.page_id from arwiki_p.page where arwiki_p.page.page_title = p.page_title
    and arwiki_p.page.page_is_redirect = 1
    and arwiki_p.page.page_namespace = 0 limit 1) 
not in
(select arwiki_p.categorylinks.cl_from from arwiki_p.categorylinks where arwiki_p.categorylinks.cl_to = "تحويلات_من_رموز_اليونيكود")
limit 100;
SQL

Checking query status...
