Untitled query #73621

SQL

/*
select count(distinct page.page_title) from pagelinks
inner join page on page.page_id = pagelinks.pl_from
where pl_namespace in (100)
and pl_title like "Trains"
and pl_from_namespace in (1,0)
*/
/*
select * from langlinks
#here ll_lang like "ar"
where ll_from in (11729) and ll_lang like "ar"
*/


select ll_title from langlinks
where  ll_lang like "ar"
and ll_from in (
	select page.page_id from page where page_title in (
	
    select distinct page.page_title from pagelinks
    inner join page on page.page_id = pagelinks.pl_from
    where pl_namespace in (100)
    and pl_title like "São_Tomé_and_Príncipe"
    and pl_from_namespace in (1,0)
  )
  and page.page_namespace in (0)

)
SQL

Checking query status...
