Untitled query #38682

SQL

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

inner join page_assessments pa
on pa.pa_page_id = p.page_id

inner join page_assessments_projects pap
on pa.pa_project_id = pap.pap_project_id

inner join langlinks ll
on ll.ll_from = p.page_id
inner join arwiki_p.page
on replace(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.pap_project_title = "Yemen"
and p.page_namespace = 0
and ll.ll_lang = 'ar'

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

Checking query status...
