# Página con más tiempo sin ediciones (el page_latest es el más chico)

select *

from page

where page_namespace = 0

    and page_is_redirect = 0

    AND not exists (select 1 from page_props WHERE pp_page = page_id AND pp_propname='disambiguation')

order by page_latest asc

limit 10;

​

# Página con más tiempo sin ediciones y nueva

select *

from page

where page_namespace = 0

    and page_is_redirect = 0

    and page_is_new = 1

    AND not exists (select 1 from page_props WHERE pp_page = page_id AND pp_propname='disambiguation')

order by page_latest asc

limit 10;