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
, 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 = "Afghanistan"
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'
limit 7

and arname not in ( 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 = arname
and ar_p.page_namespace = en_p.page_namespace = 14 )


 limit 15000
 offset 0
SQL

Checking query status...
