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

--- Comment #5 from Bugzilla Bug Importer (valhallasw) 
<wmf.bugconver...@gmail.com> ---
-------------------------------------------------------------------------------
From: Hoo man <h...@online.de>
Date: Fri, 08 Nov 2013 18:27:15
-------------------------------------------------------------------------------

nth articles (excluding redirects):  
Enero  
Hapon  
Emilio_Aguinaldo  
Setyembre_15  
Oktubre_10  
Disyembre_15  
Agham_pangkompyuter  
Marso_1  
DeBarge  
Gitnang_Kabisayaan  
Demosthenes  
Barbara_Benitez  
Max_Surban  
Herminia_Roman  
Memphis  
Matamis_(paglilinaw)

    SELECT /* SLOW_OK */ page_title FROM page INNER JOIN (SELECT /* SLOW_OK */
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 AND
page_is_redirect = 0 ORDER BY page_creations.time ASC LIMIT {n-1},1

Number of articles by the end of each year (from 2004 to 2012):  
418  
2047  
4641  
14774  
20026  
24109  
46920  
54233  
58288

    SELECT COUNT(*) 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 AND page_is_redirect = 0
AND LEFT( page_creations.time, 4) <= {year};

-- 
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