Wikipedia:Database reports/Forgotten articles/Configuration

SELECT
MAX(rev_timestamp)ASlastedit,COUNT(rev_id)ASeditcount,page_title
FROM
revision,
/******************************************************************************************************/
/* This inner query returns the 500 pages with the earliest timestamps on their latest revisions */
(
SELECT
rev_timestampaslastedit,page_id,page_title
FROM
page,revision
WHERE
page_idIN
/**********************************************************************************************/
/* 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
NOTEXISTS(SELECT1FROMpage_propsWHEREpp_page=page_idANDpp_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
ORDERBYlasteditASC
LIMIT500
)asInnerQuery
/******************************************************************************************************/
WHERE
rev_page=page_id
GROUPBY
page_id
ORDERBY
lasteditASC