Jump to content

Wikipedia:Database reports/Forgotten articles/Configuration

From Wikipedia, the free encyclopedia
SELECT
        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
                        /* Big hackerish heuristic cheat here! Ignore all pages newer than page_id X */
                        page_id < 21000000
                        /* 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