User:😂/hexmodesquery

mysql> select count(*),cr_status from code_rev where cr_repo_id = 1 and cr_id > 47459 and cr_id < 87529 and cr_path like '/trunk%' group by cr_status; +--+---+ +--+---+ +--+---+ 7 rows in set (7.39 sec)
 * count(*) | cr_status |
 * 13945 | deferred |
 * 82 | fixme    |
 * 339 | new      |
 * 16532 | ok       |
 * 1240 | old      |
 * 1585 | resolved |
 * 793 | reverted |