https://bugzilla.wikimedia.org/show_bug.cgi?id=57038
--- Comment #11 from Alvaro <[email protected]> --- With this SQL query you can get the information for all quarters: SELECT COUNT(DISTINCT(changes.id)) AS total, QUARTER(changed_on) as quarter, YEAR(changed_on) year, changed_by, people_upeople.upeople_id, people.name, company_id, companies.name FROM changes, people_upeople, people, acs_cvsanaly_mediawiki_2428.upeople_companies, acs_cvsanaly_mediawiki_2428.companies WHERE people.id = people_upeople.people_id AND changes.changed_by=people_upeople.people_id AND upeople_companies.upeople_id = people_upeople.upeople_id AND upeople_companies.company_id = companies.id AND new_value='2' AND companies.name <>'Wikimedia Deutschland' and companies.name<>'Wikimedia Foundation' GROUP BY QUARTER(changed_on), YEAR(changed_on), changed_by ORDER BY year, quarter, total DESC; +-------+---------+------+------------+------------+---------------------+------------+-------------------+ | total | quarter | year | changed_by | upeople_id | name | company_id | name | +-------+---------+------+------------+------------+---------------------+------------+-------------------+ | 13838 | 1 | 2013 | 29 | 171 | L10n-bot | 3051 | translatewiki.net | | 6346 | 1 | 2013 | 2 | 164 | jenkins-bot | 172 | Unknown | | 886 | 1 | 2013 | 385 | 343 | Pyoungmeister | 172 | Unknown | | 801 | 1 | 2013 | 54 | 236 | Tim Starling | 172 | Unknown | | 759 | 1 | 2013 | 156 | 505 | Tobias Gritschacher | 172 | Unknown | | 667 | 1 | 2013 | 6 | 340 | Kaldari | 172 | Unknown | .... | 1 | 3 | 2013 | 330 | 866 | Christian | 172 | Unknown | | 9011 | 4 | 2013 | 2 | 164 | jenkins-bot | 172 | Unknown | | 3226 | 4 | 2013 | 29 | 171 | L10n-bot | 3051 | translatewiki.net | | 239 | 4 | 2013 | 299 | 187 | Ottomata | 172 | Unknown | | 176 | 4 | 2013 | 405 | 151 | Xqt | 3054 | Independent | | 135 | 4 | 2013 | 20 | 92 | MaxSem | 172 | Unknown | | 123 | 4 | 2013 | 241 | 216 | Faidon Liambotis | 172 | Unknown | | 115 | 4 | 2013 | 65 | 10 | Mwalker | 172 | Unknown | | 108 | 4 | 2013 | 7 | 256 | Matmarex | 3054 | Independent | | 95 | 4 | 2013 | 3 | 89 | Jdlrobson | 172 | Unknown | ... 185 rows in set (0.48 sec) As you said it is a pretty good query to debug companies mapping! -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
