Untitled query #37323

SQL

use arwiki_p;
select concat("تصنيف:",p1.page_title), (select concat("Category:",ll_title) from langlinks where ll_from = p2.page_id and ll_lang = "en")
from page p1
inner join page p2
on p2.page_title = p1.page_title
where p1.page_namespace = 14
and p1.page_is_redirect = 0
and p2.page_namespace = 0
and p2.page_is_redirect = 0
and (select replace(replace(ll_title,"Category:",""), " ", "_") from langlinks where ll_from = p2.page_id and ll_lang = "en")
	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 (select count(ll_from) from langlinks where ll_from = p1.page_id) = 0
and p2.page_id in (select ll_from from langlinks where ll_from = p2.page_id and ll_lang = "en")
and p1.page_id not in (select cl_from from categorylinks where p1.page_id = cl_from and cl_to = "تحويلات_تصنيفات_ويكيبيديا")
and p1.page_id not in (select cl_from from categorylinks where p1.page_id = cl_from and cl_to = "تصنيفات_مخفية")
and p1.page_id not in (select cl_from from categorylinks where p1.page_id = cl_from and cl_to = "تصنيفات_التوضيح")
limit 10;
SQL

Checking query status...
