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_class , pa_importance# , count(*) as counts #* 
from page p, langlinks ll, page_assessments pa , page_assessments_projects pap## , arwiki_p.page arp
where pap.pap_project_title = "Yemen"

## and replace(arp.page_title," ", "_") = replace(ll.ll_title," ", "_")
## and arp.page_is_redirect = 0
## and p.page_namespace = arp.page_namespace

and pa.pa_project_id = pap.pap_project_id
and pa.pa_page_id = p.page_id
and p.page_id = ll_from
and p.page_namespace = 0
and p.page_is_redirect = 0
and ll.ll_lang = 'ar'
#group by pa.pa_class , pa.pa_importance
limit 700
SQL

Checking query status...
