Yona draft - Quarry

SQL

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)
SQL

Checking query status...
