http://www.mediawiki.org/wiki/Special:Code/MediaWiki/95121
Revision: 95121
Author: giovanni
Date: 2011-08-21 04:03:28 +0000 (Sun, 21 Aug 2011)
Log Message:
-----------
added user and user_talk to namespaces fetched by contrib.sql
Modified Paths:
--------------
trunk/tools/wsor/contribution_inequality/contrib.sql
Modified: trunk/tools/wsor/contribution_inequality/contrib.sql
===================================================================
--- trunk/tools/wsor/contribution_inequality/contrib.sql 2011-08-21
04:03:24 UTC (rev 95120)
+++ trunk/tools/wsor/contribution_inequality/contrib.sql 2011-08-21
04:03:28 UTC (rev 95121)
@@ -3,7 +3,7 @@
select namespace, year, user_id, sum(edits) as total_contributions
from halfak.giovanni
-where namespace in (0,1,4,5) and user_id > 0
+where namespace in (0,1,2,3,4,5) and user_id > 0
group by user_id, namespace, year
-- having total_contributions >= 1000
order by namespace, year, total_contributions;
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
