User:MisterHand/queries

Link
http://www.wikisign.org/

Oldest articles
SELECT cur_title, cur_namespace, cur_timestamp FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 ORDER BY cur_timestamp LIMIT 10

Examined from 11/5/2005 dump

 * 2001-2100 (LIMIT 2000,100) -- 6/10-6/13/2004
 * 2101-2200 (LIMIT 2100,100) -- 6/13-6/18/2004
 * 2201-2300 (LIMIT 2200,100) -- 6/18-6/22/2004

Examined from 1/25/2006 dump

 * 1-100 (LIMIT 100) -- 6/4/2004

Examined from 2/8/2006 dump

 * 1-100 (LIMIT 100) -- 6/4-6/10/2004
 * 1501-1600 (LIMIT 1500,100) -- 9/1-9/5/2004

Oldest Article
By "Oldest Article" I mean the non-redirect article in the English database that has gone the longest without an edit. See also Special:Ancientpages (appears to be limited to 1000 entries)

As of January 29, 2006 the oldest non-redirect article in the English database is JPATS. edited 2/3/2006

2/8/2006 Dump
The Prodigal Son (last edited June 3, 2004 -- edited anew on February 9, 2006)