SQL
x
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.