page_assessments_projects

SQL

use enwiki_p;
select 
concat("|[[:en:Wikipedia:WikiProject ",pap.pap_project_title  , '|en]]') as en , 
concat("|| [[Wikipedia:WikiProject ",pap.pap_project_title , ']]') as ar , 
concat(" || ",pap.pap_project_title , ' || ') as b , 
concat(" || ", count(*) , ' ') as counts 

from page p
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
#and p.page_namespace = 0
and ll.ll_lang = 'ar'

group by pap.pap_project_title
#limit 2
SQL

Checking query status...
