https://bugzilla.wikimedia.org/show_bug.cgi?id=57038
--- Comment #3 from Alvaro <[email protected]> --- Maybe a first approach could be to list the people that have used the +2 rights. With the actual data gathered from gerrit I think it should be too difficult. Let me try: mysql -u root acs_gerrit_mediawiki_2428 mysql> select count(distinct(changed_by)) from changes where new_value='2'; +-----------------------------+ | count(distinct(changed_by)) | +-----------------------------+ | 149 | +-----------------------------+ 149 people have used the +2 rights. We have join with upeople_companies table to search for its affiliations. mysql> select count(distinct(changes.id)) as total, changed_by, 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' group by changed_by order by total desc limit 20; +-------+------------+---------------------+------------+-----------------------+ | total | changed_by | name | company_id | name | +-------+------------+---------------------+------------+-----------------------+ | 38543 | 2 | jenkins-bot | 172 | Unknown | | 28142 | 29 | L10n-bot | 3051 | translatewiki.net | | 4765 | 15 | Reedy | 3053 | Wikimedia Foundation | | 2862 | 69 | Siebrand | 3053 | Wikimedia Foundation | | 2530 | 101 | Mark Bergsma | 3053 | Wikimedia Foundation | | 2439 | 27 | Hashar | 3053 | Wikimedia Foundation | | 2159 | 25 | Catrope | 3053 | Wikimedia Foundation | | 1869 | 61 | Ryan Lane | 3053 | Wikimedia Foundation | | 1868 | 35 | Aaron Schulz | 3053 | Wikimedia Foundation | | 1862 | 120 | Jeroen De Dauw | 3052 | Wikimedia Deutschland | | 1567 | 70 | GWicke | 3053 | Wikimedia Foundation | | 1469 | 10 | Ori.livneh | 3053 | Wikimedia Foundation | | 1448 | 156 | Tobias Gritschacher | 3052 | Wikimedia Deutschland | | 1360 | 20 | MaxSem | 3053 | Wikimedia Foundation | | 1356 | 299 | Ottomata | 3053 | Wikimedia Foundation | | 1239 | 353 | Dzahn | 3053 | Wikimedia Foundation | | 1235 | 54 | Tim Starling | 3053 | Wikimedia Foundation | | 1201 | 9 | Nikerabbit | 3053 | Wikimedia Foundation | | 1049 | 12 | Krinkle | 3053 | Wikimedia Foundation | | 1048 | 167 | awjrichards | 3053 | Wikimedia Foundation | +-------+------------+---------------------+------------+-----------------------+ With this query you have the top20 +2 reviewers with the org. If we want to exclude Wikimedia: mysql> select count(distinct(changes.id)) as total, changed_by, 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 not like '%Wikimedia%' group by changed_by order by total desc limit 20; +-------+------------+------------------+------------+-------------------+ | total | changed_by | name | company_id | name | +-------+------------+------------------+------------+-------------------+ | 38543 | 2 | jenkins-bot | 172 | Unknown | | 28142 | 29 | L10n-bot | 3051 | translatewiki.net | | 515 | 36 | IAlex | 172 | Unknown | | 468 | 170 | Mwjames | 3054 | Independent | | 466 | 94 | Santhosh | 172 | Unknown | | 293 | 31 | Hoo man | 3054 | Independent | | 264 | 405 | Xqt | 3054 | Independent | | 233 | 7 | Matmarex | 3054 | Independent | | 199 | 83 | Raimond Spekking | 3054 | Independent | | 196 | 66 | Addshore | 3054 | Independent | | 191 | 28 | Alex Monk | 3054 | Independent | | 183 | 242 | Yaron Koren | 3055 | WikiWorks | | 178 | 171 | Pgehres | 3054 | Independent | | 148 | 26 | Parent5446 | 3054 | Independent | | 146 | 50 | Legoktm | 3054 | Independent | | 117 | 132 | Tpt | 3054 | Independent | | 109 | 293 | Merlijn van Deen | 3054 | Independent | | 108 | 91 | Petr Onderka | 172 | Unknown | | 106 | 22 | TheDJ | 3054 | Independent | | 93 | 109 | Ladsgroup | 172 | Unknown | +-------+------------+------------------+------------+-------------------+ 20 rows in set (0.41 sec) We can create querterly reports also from this core SQL query. Something like that Quim? -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
