Untitled query #9220

SQL

use arwiki_p;
select concat("تصنيف:",p.page_title), concat("Category:",ll_title)
from page p
inner join page p3
on p3.page_title = p.page_title
inner join langlinks
on ll_from = p3.page_id
where p.page_namespace = 14
and p.page_is_redirect = 0
and p.page_title not like "%/%"
and p.page_id not in (select ll_from from langlinks where ll_from = p.page_id and ll_lang = "en")
and p.page_title in (select p2.page_title from page p2 where p2.page_namespace = 0 and p2.page_is_redirect = 0 and p2.page_title = p.page_title)
and (select count(p2.page_id) from page p2
     inner join langlinks
     on ll_from = p2.page_id
     where p2.page_namespace = 0 
     and p2.page_is_redirect = 0
     and p2.page_title = p.page_title
     and ll_lang = "en"
     and replace(ll_title," ","_") in (select enwiki_p.page.page_title from enwiki_p.page
                                       where enwiki_p.page.page_namespace = 14
                                       and enwiki_p.page.page_is_redirect = 0
                                       and enwiki_p.page.page_title = replace(ll_title," ","_"))
     > 0)
and p.page_id not in (select cl_from from categorylinks  where cl_to = 'تحويلات_تصنيفات_ويكيبيديا')
and p3.page_namespace = 0
and p3.page_is_redirect = 0
and ll_lang = "en";
SQL

Checking query status...
