Forgotten articles 2

SQL

SELECT SQL_SMALL_RESULT
                    MAX(rev_timestamp) AS lastedit, COUNT(rev_id) AS editcount, page_title
                    FROM revision,
                    # This inner query returns the 500 pages with the earliest timestamps on their latest revisions
                    ( SELECT rev_timestamp as lastedit,page_id,page_title
                     FROM page, revision
                     WHERE page_id IN
                     # This query returns the list of regular articles created earlier than page_id X
                     ( SELECT page_id
                      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' )
                     )
                     AND rev_id=page_latest
                     ORDER BY lastedit ASC
                     LIMIT 500
                    ) as InnerQuery
                WHERE rev_page=page_id
                GROUP BY page_id
                ORDER BY lastedit ASC
SQL

Checking query status...
