Untitled query #40705

SQL

use enwiki_p;
select page_title , page_namespace ,  ll_title, pap_project_title , pa_class , pa_importance 

, concat(REPLACE( REPLACE(REPLACE(ll_title, 'ويكيبيديا:', ' '), 'قالب:', ' ') , 'تصنيف:', ' ')) as arname

from page , langlinks , page_assessments , page_assessments_projects
where pap_project_title = "Yemen"
and pa_project_id = pap_project_id
and pa_page_id = page_id
and page_id = ll_from
and page_namespace = 14
and page_is_redirect = 0
and ll_lang = 'ar'
limit 7

and ll_title not in (select arwiki_p.page.page_title from arwiki_p.page inner join arwiki_p.categorylinks on arwiki_p.page.page_id = 
             arwiki_p.categorylinks.cl_from where arwiki_p.categorylinks.cl_to = "مقالات_مشروع_ويكي_{}"
             and ll_title = arwiki_p.page.page_title)
SQL

Checking query status...
