use enwiki_p;

select 

    page_title, c, page_len

    from categorylinks as cat

    join (select count(*) as c, page.page_id, page.page_title, page.page_len

    from langlinks, page 

    where 

        page.page_namespace = 0 and

        page.page_is_redirect = 0 and

        langlinks.ll_from = page.page_id and

        page_len < 4000

​

    group by 2 desc having count(*) >= 19) as page

    ON cat.cl_from = page.page_id

    where cat.cl_to like '%Indonesia%'

    limit 100