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 |

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.07 sec)
 * cc_user_text    | comments | totalLength | avgLength |
 * Brion VIBBER    |     1153 |      169945 |  147.3938 |
 * Catrope         |     1080 |      288535 |  267.1620 |
 * Tim Starling    |      858 |      221889 |  258.6119 |
 * Nikerabbit      |      631 |      111591 |  176.8479 |
 * ^demon          |      594 |       77439 |  130.3687 |
 * Simetrical      |      572 |      165488 |  289.3147 |
 * Platonides      |      522 |       87664 |  167.9387 |
 * Siebrand        |      509 |       76329 |  149.9587 |
 * Aaron Schulz    |      500 |       32673 |   65.3460 |
 * Reedy           |      373 |       49853 |  133.6542 |
 * Raymond         |      358 |       70116 |  195.8547 |
 * Bryan           |      332 |       46223 |  139.2259 |
 * Werdna          |      288 |       33890 |  117.6736 |
 * Trevor Parscal  |      259 |       48082 |  185.6448 |
 * MaxSem          |      213 |       27951 |  131.2254 |
 * MarkAHershberger |     202 |       34591 |  171.2426 |
 * Hashar          |      194 |       20938 |  107.9278 |
 * Jeroen De Dauw  |      184 |       24909 |  135.3750 |
 * IAlex           |      137 |       15989 |  116.7080 |
 * Mdale           |      132 |       31701 |  240.1591 |
 * Kaldari         |      115 |       17717 |  154.0609 |
 * 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 |
 * Krinkle         |       27 |        6099 |  225.8889 |