Untitled query #38702

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, langlinks ll


inner join arwiki_p.page arp
on replace(arp.page_title," ", "_") = replace(ll.ll_title," ", "_")
#inner join arwiki_p.page_assessments paar
#on paar.pa_page_id = arp.page_id

#inner join arwiki_p.page_assessments_projects papr
#on paar.pa_project_id = papr.pap_project_id

where pap.pap_project_title = "Canada"
and pa.pa_page_id = p.page_id
and pa.pa_project_id = pap.pap_project_id
and ll.ll_from = p.page_id
#and papr.pap_project_title = "اليمن"
#and p.page_namespace = arp.page_namespace
and p.page_namespace = 0
and p.page_is_redirect = 0
and arp.page_is_redirect = 0
and ll.ll_lang = 'ar'
#group by pa.pa_class , pa.pa_importance
limit 10000
SQL

Checking query status...
