Untitled query #38682

SQL

use enwiki_p;
select p.page_title , p.page_namespace , ll.ll_title , pap_project_title , pa.pa_class  , pa.pa_importance 
#*#pa.pa_class , pa.pa_importance# , count(*) as counts #* 
from page p, langlinks ll, page_assessments pa, page_assessments_projects

inner join arwiki_p.page
on arwiki_p.page.page_title = replace(ll.ll_title," ", "_")
inner join arwiki_p.page_assessments
on arwiki_p.page_assessments.pa_project_id = arwiki_p.page.page_id

where pap_project_title = "Yemen"
and pa.pa_project_id = pap_project_id
and pa.pa_page_id = p.page_id
and p.page_id = ll.ll_from
and p.page_namespace = 0
and ll.ll_lang = 'ar'

#group by pa.pa_class , pa.pa_importance
limit 7
SQL

Checking query status...
