Untitled query #58333

SQL

select concat("قالب:",(select ll_title from langlinks where ll_from = p2.page_id and ll_lang = "ar")),
       concat("[[en:Template:",p1.page_title,"]]")
from
page p1
inner join page p2
on p2.page_title = p1.page_title
where p1.page_namespace = 10
and p1.page_is_redirect = 0
and p2.page_namespace = 0
and p2.page_is_redirect = 0
#and p1.page_id not in (select cl_from from categorylinks where p1.page_id = cl_from and cl_to = "Wikipedia_soft_redirected_categories")
#and p1.page_id not in (select cl_from from categorylinks where p1.page_id = cl_from and cl_to = "Hidden_categories")
#and p1.page_id not in (select cl_from from categorylinks where p1.page_id = cl_from and cl_to = "Disambiguation_categories")
and p2.page_id in (select cl_from from categorylinks where cl_from = p2.page_id and cl_to = p1.page_title)
and p1.page_id in (select ll_from from langlinks where ll_from = p1.page_id and ll_lang = "ar")
and p2.page_id
	in
    (select ll_from from langlinks where ll_from = p2.page_id and ll_lang = "ar")
    limit 10;
SQL

Checking query status...
