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)