User:πŸ˜‚/Commit stats

From mediawiki.org
Jump to navigation Jump to search

Words in commit messages[edit]

sucks[edit]

mysql> select cr_author, count(cr_author) as num from code_rev where cr_message like '%sucks%' group by cr_author order by num desc;
+------------+-----+
| cr_author  | num |
+------------+-----+
| brion      |  10 | 
| mark       |   2 | 
| david      |   2 | 
| catrope    |   2 | 
| simetrical |   2 | 
| demon      |   2 | 
| valhallasw |   2 | 
| vibber     |   1 | 
| midom      |   1 | 
| kim        |   1 | 
| werdna     |   1 | 
| rainman    |   1 | 
| dale       |   1 | 
| overlordq  |   1 | 
| reedy      |   1 | 
| btongminh  |   1 | 
+------------+-----+
16 rows in set (4.87 sec)

fuck[edit]


mysql> select cr_author, count(cr_author) as num from code_rev where cr_message like '%fuck%' group by cr_author order by num desc;
+-------------+-----+
| cr_author   | num |
+-------------+-----+
| aaron       |  22 | 
| robchurch   |   5 | 
| brion       |   4 | 
| david       |   4 | 
| avar        |   3 | 
| siebrand    |   2 | 
| markbergsma |   1 | 
| vibber      |   1 | 
| nickj       |   1 | 
| daniel      |   1 | 
| nicdumz     |   1 | 
+-------------+-----+