SELECTMAX(rev_timestamp)ASlastedit,COUNT(rev_id)ASeditcount,page_titleFROMrevision,/******************************************************************************************************//* This inner query returns the 500 pages with the earliest timestamps on their latest revisions */(SELECTrev_timestampaslastedit,page_id,page_titleFROMpage,revisionWHEREpage_idIN/**********************************************************************************************//* This query returns the list of regular articles created earlier than page_id X */(SELECTpage_idFROMpageWHEREpage_namespace=0ANDpage_is_redirect=0ANDNOTEXISTS(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 */)/**********************************************************************************************/ANDrev_id=page_latestORDERBYlasteditASCLIMIT500)asInnerQuery/******************************************************************************************************/WHERErev_page=page_idGROUPBYpage_idORDERBYlasteditASC