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 page.page_title 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 "Trains"
  and pl_from_namespace in (1,0)
)
and page.page_namespace in (0)
and page.page_id  in (
	select ll_from from langlinks
	where  ll_lang like "ar"
)
limit 10
*/

SELECT DISTINCT page.page_title
FROM page
JOIN pagelinks ON page.page_id = pagelinks.pl_from
WHERE page.page_namespace = 0
  AND LOCATE('Trains', page.page_title) > 0
  AND pagelinks.pl_namespace = 100
  AND pagelinks.pl_title = 'Trains'
  AND EXISTS (
    SELECT 1
    FROM langlinks
    WHERE langlinks.ll_from = page.page_id
      AND langlinks.ll_lang = 'ar'
  )
LIMIT 10;
SQL

Checking query status...
