enwiki pages by link density

SQL

SELECT SQL_SMALL_RESULT
    p.page_len / IFNULL(COUNT(pl.pl_from), 1) AS length_to_link_ratio, 
    COUNT(r.rev_id) AS editcount, 
    p.page_title
FROM revision r
JOIN page p ON p.page_id = r.rev_page
LEFT JOIN pagelinks pl ON pl.pl_from = p.page_id AND pl.pl_namespace = 0,
    # This inner query returns the 500 pages with the earliest timestamps on their latest revisions
    (SELECT rev_timestamp AS lastedit, page.page_id, page.page_title, page.page_len
        FROM page
        JOIN revision ON page.page_id = revision.rev_page
        WHERE page.page_id IN
            # This query returns the list of regular articles created earlier than page_id X
            (SELECT page.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.page_id AND pp_propname = 'disambiguation')
                AND page_id < 5000000
                # Big heuristic cheat! Ignore articles created after Dec 2008
            )
        AND revision.rev_id = page.page_latest
        ORDER BY lastedit ASC
        LIMIT 500
    ) AS InnerQuery
WHERE r.rev_page = p.page_id
GROUP BY p.page_id
ORDER BY length_to_link_ratio ASC;
SQL

Checking query status...
