enwiki pages by link density

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 page_id < 5000000
                            # Big hackerish heuristic cheat here! Ignore all pages newer than page_id X.
                            # Currently set to ignore articles created after Dec 2008
                            # If less than 500 results appear in the final output, this needs to be re-baselined
                        )
                        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...
