https://www.mediawiki.org/wiki/Special:Code/MediaWiki/114812
Revision: 114812
Author: giovanni
Date: 2012-04-09 18:58:52 +0000 (Mon, 09 Apr 2012)
Log Message:
-----------
small stylistic fix to sql/ratesnobots.sql
Modified Paths:
--------------
trunk/tools/wsor/editor_lifecycle/sql/ratesnobots.sql
Modified: trunk/tools/wsor/editor_lifecycle/sql/ratesnobots.sql
===================================================================
--- trunk/tools/wsor/editor_lifecycle/sql/ratesnobots.sql 2012-04-09
18:58:50 UTC (rev 114811)
+++ trunk/tools/wsor/editor_lifecycle/sql/ratesnobots.sql 2012-04-09
18:58:52 UTC (rev 114812)
@@ -1,26 +1,28 @@
+/*
+ Copyright (C) 2011 GIOVANNI LUCA CIAMPAGLIA, [email protected]
+ This program is free software; you can redistribute it and/or modify
+ it under the terms of the GNU General Public License as published by
+ the Free Software Foundation; either version 2 of the License, or
+ (at your option) any later version.
+
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ GNU General Public License for more details.
+
+ You should have received a copy of the GNU General Public License along
+ with this program; if not, write to the Free Software Foundation, Inc.,
+ 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
+ http://www.gnu.org/copyleft/gpl.html
+*/
--- Copyright (C) 2011 GIOVANNI LUCA CIAMPAGLIA, [email protected]
--- This program is free software; you can redistribute it and/or modify
--- it under the terms of the GNU General Public License as published by
--- the Free Software Foundation; either version 2 of the License, or
--- (at your option) any later version.
---
--- This program is distributed in the hope that it will be useful,
--- but WITHOUT ANY WARRANTY; without even the implied warranty of
--- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
--- GNU General Public License for more details.
---
--- You should have received a copy of the GNU General Public License along
--- with this program; if not, write to the Free Software Foundation, Inc.,
--- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
--- http://www.gnu.org/copyleft/gpl.html
-
-select
+SELECT
rev_user,
- min(rev_timestamp),
- max(rev_timestamp),
- count(*)
-from revision left join halfak.bot_20110711
-on rev_user = user_id
-where user_id is null and rev_user > 0
-group by rev_user;
+ MIN(rev_timestamp),
+ MAX(rev_timestamp),
+ COUNT(*)
+FROM revision
+LEFT JOIN halfak.bot_20110711
+ON rev_user = user_id
+WHERE user_id IS NULL AND rev_user > 0
+GROUP BY rev_user;
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
