Untitled query #40863

SQL

use arwiki_p;
select DISTINCT p.page_title , p.page_namespace , ll_title , pap.pap_project_title , enpa.pa_importance

from page as p, langlinks , page_assessments as pa, page_assessments_projects as pap
,enwiki_p.page en_p, enwiki_p.page_assessments_projects as enpap , enwiki_p.page_assessments as enpa
where pa.pa_project_id = pap.pap_project_id
and ( pap.pap_project_title = "فيزياء" )
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 pa.pa_importance = "غير معروفة"
and ll_lang = 'en'

#select DISTINCT en_p.page_title
and enpa.pa_project_id = enpap.pap_project_id
and enpap.pap_project_title = "Physics"
and enpa.pa_page_id = en_p.page_id
and en_p.page_title = REPLACE(ll_title,' ','_')
and en_p.page_namespace = p.page_namespace  
group by en_p.page_title
#limit 100
;
SQL

Checking query status...
