use hewiki_p;

select ll_title, ll_lang, page_namespace, page_title, page_id, page_len from page join langlinks

where page_id = ll_from

and page_is_redirect = 0

and (ll_lang, ll_title) in

(select ll_lang, ll_title from page join langlinks as ll1

on page_id = ll1.ll_from

and page_namespace <> 2

and page_is_redirect = 0

and exists

(select * from langlinks as ll2

 where ll1.ll_lang = ll2.ll_lang

 and ll1.ll_title = ll2.ll_title

 and ll1.ll_from <> ll2.ll_from

 and not exists

 (select * from page as p1

  where p1.page_id = ll2.ll_from

  and p1.page_namespace = 2)

 and exists

 (select * from page as p2

  where p2.page_id = ll2.ll_from

  and p2.page_is_redirect = 0))

group by ll_lang, ll_title)

​