Page MenuHomePhabricator
Paste P9646

List of recent most active Phab "Priority" field setters
ActivePublic

Authored by Dzahn on Nov 15 2019, 7:35 PM.
Tags
None
Referenced Files
F31091663: raw.txt
Nov 15 2019, 7:35 PM
Subscribers
Tokens
"Like" token, awarded by Akuckartz.
mysql:phstats@m3-slave.eqiad.wmnet [phabricator_maniphest]> SELECT usr.username, COUNT(usr.username) AS cnt FROM maniphest_transaction trs JOIN phabricator_user.user usr WHERE trs.transactionType = "priority" AND FROM_UNIXTIME(trs.dateModified) >= (NOW() - INTERVAL 4 MONTH) AND trs.authorPHID = usr.phid GROUP BY usr.username ORDER BY cnt DESC LIMIT 30;
+---------------+-----+
| username | cnt |
+---------------+-----+
| sbassett | 252 |
| Krinkle | 170 |
| ssastry | 142 |
| Jdlrobson | 137 |
| CCicalese_WMF | 135 |
| JMinor | 131 |
| WDoranWMF | 130 |
| DannyS712 | 127 |
| ovasileva | 127 |
| LGoto | 121 |
| Marostegui | 116 |
| Pginer-WMF | 115 |
| Aklapper | 104 |
| RobH | 99 |
| NavinoEvans | 97 |
| Charlotte | 95 |
| Urbanecm | 90 |
| Ecritures | 85 |
| Mholloway | 80 |
| Xqt | 73 |
| hashar | 72 |
| eprodromou | 68 |
| herron | 67 |
| StrikerBot | 61 |
| aborrero | 60 |
| kzimmerman | 58 |
| zeljkofilipin | 56 |
| jbond | 56 |
| Ejegg | 52 |
| fdans | 50 |
+---------------+-----+
30 rows in set (2.64 sec)