https://bugzilla.wikimedia.org/show_bug.cgi?id=59494

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Thu, 07 Nov 2013 22:45:37
-------------------------------------------------------------------------------

Here you go (SQL for each result included below):

Oldest surviving edit in the database:  
https://tl.wikipedia.org/w/index.php?title=Unang_Pahina&oldid=1  
https://tl.wikipedia.org/w/index.php?oldid=8120 (First non-mainpage edit)  
https://tl.wikipedia.org/w/index.php?oldid=10 (First non-mainpage article edit)

    SELECT * FROM revision ORDER BY rev_timestamp ASC LIMIT 15;

First article created which is not the Main Page:  
https://tl.wikipedia.org/wiki/Wikipedia

    SELECT page_title FROM page INNER JOIN (SELECT MIN(rev_timestamp) as time,
rev_page as id FROM revision GROUP BY rev_page) AS page_creations ON
page_creations.id = page_id WHERE page_namespace = 0 ORDER BY
page_creations.time ASC LIMIT 5;

First image uploaded to the local database:  
https://tl.wikipedia.org/wiki/Talaksan:Ph_seal_batanes.png (that's the oldest,
even considering deleted images)

    SELECT * FROM image ORDER BY img_timestamp ASC LIMIT 1;

nth Articles:  
Kalakhang_Maynila  
Isla  
1946  
Setyembre_7  
Oktubre_2  
Disyembre_6  
Emilio_F._Aguinaldo  
Pamantasang_De_La_Salle  
Pope_John_Paul_II  
Juan_Bautista_ng_La_Salle  
Ṭabariyyah  
Franz_Rosenzweig  
Ralph_Brambles  
Syudad_ng_Davao  
Sanitasyon  
Adversary_(komiks)

    SELECT page_title FROM page INNER JOIN (SELECT MIN(rev_timestamp) as time,
rev_page as id FROM revision GROUP BY rev_page) AS page_creations ON rev_page =
page_id WHERE page_namespace = 0 ORDER BY page_creations.time ASC LIMIT
{n-1},1;

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to