Untitled query #41586

SQL

select ll_title , en_pap.pap_project_title
from page as en_p, langlinks , page_assessments as en_pa, page_assessments_projects as en_pap
where en_pa.pa_project_id = en_pap.pap_project_id
and en_pap.pap_project_title in ( "Alabama" )
and en_pa.pa_page_id = en_p.page_id
and page_id = ll_from
and en_p.page_namespace = 0
and en_p.page_is_redirect = 0
and ll_lang = 'ar'
and EXISTS ( select ar_p.page_title
    from arwiki_p.page ar_p, arwiki_p.templatelinks as atemp
      where atemp.tl_from = ar_p.page_id
        and atemp.tl_title in ("بذرة_سياسي_أمريكي")
        and ar_p.page_title = REPLACE(ll_title, ' ', '_')
        AND atemp.tl_namespace = 10
        and ar_p.page_namespace = en_p.page_namespace
        group by ar_p.page_title
    )
limit 10
SQL

Checking query status...
