Untitled query #11984

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

Checking query status...
