select created, page.page_title, page.page_len from (

select min(r.rev_timestamp) created, page.page_id page_id, page.page_title, page.page_len

    from revision r, page

    where 

        page.page_namespace = 0 and

        page.page_is_redirect = 0 and

        r.rev_page = page.page_id and

        r.rev_timestamp < 20110000000000 and

        page.page_len < 2000) page,

        categorylinks as cat

        where    

      cat.cl_from = page.page_id

      and cat.cl_to like '%Indonesia%'

​

    group by 2 limit 200;