Trevor Parscal wrote: > Can we please exclude branches from this calculation?
I think this is what you want. mysql> select cr_author, count(*) from code_rev where cr_status = 'fixme' and cr_path not like '/branches/%' group by cr_author order by count(*) desc; +--------------+----------+ | cr_author | count(*) | +--------------+----------+ | awjrichards | 7 | | kaldari | 5 | | nimishg | 5 | | werdna | 4 | | platonides | 4 | | huji | 4 | | catrope | 3 | | demon | 3 | | btongminh | 3 | | daniel | 2 | | pdhanda | 2 | | sean_colombo | 2 | | happy-melon | 2 | | tparscal | 2 | | jeroendedauw | 2 | | maxsem | 2 | | mgrabovsky | 1 | | rainman | 1 | | yaauie | 1 | | philip | 1 | | hartman | 1 | | ialex | 1 | | mah | 1 | | aaron | 1 | | soxred93 | 1 | | vyznev | 1 | | jdpond | 1 | | leonsp | 1 | | tisane | 1 | | thomasv | 1 | | brion | 1 | | nikerabbit | 1 | | siebrand | 1 | | tstarling | 1 | | diana | 1 | | dantman | 1 | | purodha | 1 | | svip | 1 | +--------------+----------+ 38 rows in set (0.07 sec) The total is 74. This chart could be made dynamic in a Toolserver tool, if there were interest. It could also possibly go into the extension, but the database would need some indices first. MZMcBride _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
