empty pages - Quarry

SQL

SELECT Count(*) ll_count,
       page_title title_en,

  (SELECT ll_title
   FROM langlinks
   WHERE ll_from = page_id
     AND ll_lang = 'ru') title_ru
FROM page,
     langlinks
WHERE ll_from = page_id
  AND
    (SELECT Count(*)
     FROM langlinks
     WHERE ll_from = page_id) >= 50
  AND -- attempt to limit number of intermediate rows to fetch and sort
 page_id NOT IN
    (SELECT ll_from
     FROM langlinks
     WHERE ll_lang = 'hy')
  AND -- ... missing from SK (no direct iw equivalent there)
 page_namespace = 0 GROUP  BY page_id
  ORDER  BY ll_count DESC, page_title
LIMIT 3000; -- top N
SQL

Checking query status...
