select count(*), page.page_title from langlinks, page 

    where 

        page.page_namespace = 0 and

        page.page_is_redirect = 0 and

        page.page_title not like 'AD%' and

        page.page_title not regexp '^\d+$' and

        langlinks.ll_from = page.page_id and

        not exists (select * from langlinks where langlinks.ll_from = page.page_id and langlinks.ll_lang = 'id')

    group by 2 order by 1 desc limit 200