Untitled query #40705

SQL

use enwiki_p;
select nan.a1 , nan.a2 , nan.a3 , nan.a4 , nan.a5 , nan.arname
from (select en_p.page_title as a1 , en_p.page_namespace as a2, ll_title as a3, en_pap.pap_project_title as a4, en_pa.pa_class as a5, en_pa.pa_importance
, concat(REPLACE( REPLACE(REPLACE(ll_title, 'ويكيبيديا:', ' '), 'قالب:', ' ') , 'تصنيف:', ' ')) as arname
from page as en_p, langlinks , page_assessments as en_pa, page_assessments_projects as en_pap
where en_pap.pap_project_title = "Primates"
and en_pa.pa_project_id = en_pap.pap_project_id
and en_pa.pa_page_id = en_p.page_id
and page_id = ll_from
#and en_p.page_namespace = 14
and en_p.page_is_redirect = 0
and ll_lang = 'ar'
) as nan
and nan.arname not in ( select uu.iio from (ar_p.page_title as iio
from arwiki_p.page ar_p , arwiki_p.page_assessments  as arpa, arwiki_p.page_assessments_projects as arpap
where arpap.pap_project_title = "رئيسيات"
and arpa.pa_project_id = arpap.pap_project_id
and arpa.pa_page_id = ar_p.page_id
and ar_p.page_title = nan.arname
and ar_p.page_namespace = en_p.page_namespace ) as uu )
 limit 15
SQL

Checking query status...
