https://bugzilla.wikimedia.org/show_bug.cgi?id=59310
--- Comment #1 from Bugzilla Bug Importer (valhallasw) <wmf.bugconver...@gmail.com> --- ------------------------------------------------------------------------------- From: Lars Age Kamfjord <lars-toolserverw...@kamfjord.org> Date: Tue, 10 Feb 2009 21:05:23 ------------------------------------------------------------------------------- Not sure what you want here. Do you want just a query with year and total number of edits of all users this year, or username, year and users number of edits? Username,total edits, year will be this query: SELECT u.user_name,COUNT![][1] AS amount,LEFT(rev_timestamp,4) AS year FROM revision r JOIN user u ON u.user_id=rev_user WHERE u.user_name = 'Laaknor' GROUP BY LEFT(rev_timestamp,4),u.user_name; (just take out "WHERE u.user_name = 'Laaknor' to get all users Or if you wish to have just the total amount of edits group by year, it's much easier: SELECT COUNT![][1] AS amount,LEFT(rev_timestamp,4) FROM revision GROUP BY LEFT(rev_timestamp,4); Does this help? Edit: Bah, replace ![][1] with ( and * and ) [1]: https://jira.toolserver.org/images/icons/emoticons/star_yellow.gif -- 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
