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 (0.77 sec)
 * cr_status | COUNT(DISTINCT cr_id) |
 * deferred |                  1312 |
 * fixme    |                    54 |
 * new      |                   775 |
 * ok       |                 16985 |
 * old      |                 11837 |
 * resolved |                   857 |
 * reverted |                   565 |
 * verified |                    13 |

Top 50 commenters by number of comments
mysql> SELECT cc_user_text, COUNT(*) AS comments, SUM(length) AS totalLength, SUM(length)/COUNT(*) AS avgLength FROM (SELECT cc_user_text, LENGTH(cc_text) AS length FROM code_comment) AS d GROUP BY cc_user_text ORDER BY comments DESC LIMIT 50; +--+--+-+---+ +--+--+-+---+ +--+--+-+---+ 50 rows in set (0.21 sec)
 * cc_user_text    | comments | totalLength | avgLength |
 * Brion VIBBER    |     1153 |      169945 |  147.3938 |
 * Catrope         |     1100 |      290358 |  263.9618 |
 * Tim Starling    |      858 |      221889 |  258.6119 |
 * Nikerabbit      |      633 |      111748 |  176.5371 |
 * ^demon          |      594 |       77439 |  130.3687 |
 * Simetrical      |      572 |      165488 |  289.3147 |
 * Platonides      |      524 |       89370 |  170.5534 |
 * Siebrand        |      509 |       76329 |  149.9587 |
 * Aaron Schulz    |      500 |       32673 |   65.3460 |
 * Reedy           |      374 |       49936 |  133.5187 |
 * Raymond         |      358 |       70116 |  195.8547 |
 * Bryan           |      334 |       46561 |  139.4042 |
 * Werdna          |      288 |       33890 |  117.6736 |
 * Trevor Parscal  |      267 |       48941 |  183.2996 |
 * MaxSem          |      213 |       27951 |  131.2254 |
 * MarkAHershberger |     202 |       34591 |  171.2426 |
 * Hashar          |      195 |       20949 |  107.4308 |
 * Jeroen De Dauw  |      184 |       24909 |  135.3750 |
 * IAlex           |      138 |       16032 |  116.1739 |
 * Mdale           |      132 |       31701 |  240.1591 |
 * Kaldari         |      117 |       17877 |  152.7949 |
 * Voice of All    |       90 |        6591 |   73.2333 |
 * MZMcBride       |       78 |       15178 |  194.5897 |
 * NeilK           |       73 |       23215 |  318.0137 |
 * Happy-melon     |       70 |       16462 |  235.1714 |
 * Duesentrieb     |       70 |        9807 |  140.1000 |
 * OverlordQ       |       62 |       14761 |  238.0806 |
 * TheDJ           |       59 |        9944 |  168.5424 |
 * PhiLiP          |       56 |        9865 |  176.1607 |
 * Mr.Z-man        |       53 |       10766 |  203.1321 |
 * Jack Phoenix    |       50 |       18080 |  361.6000 |
 * Umherirrender   |       46 |        7963 |  173.1087 |
 * Adammiller      |       45 |        9257 |  205.7111 |
 * Skizzerz        |       44 |       24741 |  562.2955 |
 * Ilmari Karonen  |       43 |       14899 |  346.4884 |
 * Danny B.        |       42 |       12058 |  287.0952 |
 * Church of emacs |       42 |       12720 |  302.8571 |
 * Shinjiman       |       41 |        6877 |  167.7317 |
 * Awjrichards     |       40 |       15184 |  379.6000 |
 * Freakolowsky    |       38 |        6557 |  172.5526 |
 * Remember the dot |      35 |       16883 |  482.3714 |
 * ThomasV         |       35 |        5150 |  147.1429 |
 * Yaron Koren     |       34 |        5247 |  154.3235 |
 * Jbeigel         |       32 |        5496 |  171.7500 |
 * Gurch           |       31 |        7380 |  238.0645 |
 * Bawolff         |       30 |        8063 |  268.7667 |
 * X!              |       28 |        3039 |  108.5357 |
 * Nimish Gautam   |       28 |        3801 |  135.7500 |
 * Mormegil        |       27 |        7635 |  282.7778 |
 * Peachey88       |       27 |        4405 |  163.1481 |