Untitled query #40705

SQL

use enwiki_p;
select en_p.page_title, en_p.page_namespace, ll_title, en_pap.pap_project_title, en_pa.pa_class, en_pa.pa_importance

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'
and not EXISTS ( select ar_p.page_title
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 = REPLACE( REPLACE(REPLACE(ll_title, 'ويكيبيديا:', ' '), 'قالب:', ' ') , 'تصنيف:', ' ')
and ar_p.page_namespace = en_p.page_namespace )

 limit 15
SQL

Checking query status...
