User:Catrope/CR stats

Breakdown of revisions by status in /trunk/phase3 mysql> SELECT cr_status, COUNT(DISTINCT cr_id) FROM code_rev, code_paths WHERE cr_repo_id=1 AND cp_repo_id=1 AND cp_rev_id=cr_id AND cp_path LIKE '/trunk/phase3%' GROUP BY cr_status; +---+---+ +---+---+ +---+---+ 8 rows in set (20.72 sec)
 * cr_status | COUNT(DISTINCT cr_id) |
 * deferred |                  1309 |
 * fixme    |                    58 |
 * new      |                   839 |
 * ok       |                 16874 |
 * old      |                 11837 |
 * resolved |                   847 |
 * reverted |                   565 |
 * verified |                    13 |