Posted by greggles on August 18, 2011 at 3:50am
In some irc discussions today heyrocker asked who was active in the project application review queue these days.
This query counts unique comments, so it kind of rewards people for posting a lot of comments and not necessarily just good comments, nor full reviews.
It does give us a sense of who is generally active in the queue.
Last 30 days
select count(1), c.uid, u.name from project_issue_comments p inner join comments c on p.cid = c.cid inner join users u on c.uid = u.uid where p.pid = 1025112 and c.timestamp > unix_timestamp() - 246060*30 group by c.uid, u.name order by count(1) desc limit 10;
+----------+---------+----------------+
| count(1) | uid | name |
+----------+---------+----------------+
| 92 | 241634 | tim.plunkett |
| 37 | 1011436 | rootatwc |
| 36 | 648658 | ccardea |
| 20 | 747308 | berkas1 |
| 20 | 180064 | System Message |
| 16 | 148199 | jthorson |
| 14 | 274559 | davidhernandez |
| 14 | 372772 | eosrei |
| 14 | 1145950 | yannisc |
| 12 | 1358080 | patrickd |
+----------+---------+----------------+
Last 90 days
+----------+---------+----------------+
| count(1) | uid | name |
+----------+---------+----------------+
| 212 | 1131606 | jordojuice |
| 138 | 648658 | ccardea |
| 106 | 241634 | tim.plunkett |
| 105 | 148199 | jthorson |
| 98 | 109890 | sreynen |
| 90 | 107701 | joachim |
| 85 | 180064 | System Message |
| 57 | 1217654 | Ralt |
| 54 | 1368774 | alexreinhart |
| 53 | 274559 | davidhernandez |
+----------+---------+----------------+
All time
+----------+---------+----------------+
| count(1) | uid | name |
+----------+---------+----------------+
| 225 | 1131606 | jordojuice |
| 220 | 109890 | sreynen |
| 188 | 107701 | joachim |
| 171 | 180064 | System Message |
| 169 | 648658 | ccardea |
| 139 | 36762 | greggles |
| 133 | 30906 | rfay |
| 124 | 241634 | tim.plunkett |
| 115 | 148199 | jthorson |
| 97 | 55077 | kiamlaluno |
+----------+---------+----------------+
There we have it...
I'm disappointed (but not surprised) to see that I've really dropped off my involvement. Great work to everyone in these lists!
Comments
Just today I went through and
Just today I went through and won't fixed all 49 of the 3+ month old issues stuck on "needs work".
So take my stats with a grain of salt.
It just goes to show
that it doesn't take much time or effort to help out tremendously and be on the top of the list. :^)
All time
The "all time" one isn't really fair because this was going on over email long before it was moved to the issue queues. :)
Michelle
"All time" since the git
"All time" since the git migration, I believe.
.
Ah, that's different than "all time" then. It's just a nit... I don't care about retroactive credit for me since I didn't spend a ton of time on it. I think my biggest contribution was suggesting it be moved to the issue queues. :) But AJK did a lot of work on this pretty much unknown since it was behind the scenes and it seems a shame to leave him out of an "all time".
Michelle
I think the concept of "all
I think the concept of "all time within this context" is pretty clear given the intro text and group this was posted in.
I just spent a few minutes looking for a way I could query the old application database to get the right info and it doesn't seem to be currently possible.
knaddison blog | Morris Animal Foundation
.
Not so sure "all time" in a group named "code review" obviously excludes the person who started doing the code reviews and did them by himself for a long time. But, if it's a technical limitation, so be it. I just felt bad that all his work seemed to be forgotten, that's all.
Michelle
Awesome
That's great to see. It would be super to cool to see this a regular site somewhere more public. These fine folks need more recognition.
--
zzolo
That System Message guy is
That System Message guy is awesome. Always helping out.
more project application commenter stats
I updated the title to make it more clear what process this is about.
Here are the top 20 folks from the last 30 days:
Cool to see some new folks there, though it seems like some of the strongest contributors from the last time I did this are no longer involved. It would be interesting to know what keeps people's attention going.
knaddison blog | Morris Animal Foundation
the cvsapplicationqueue
Here is similar data for the entire life of http://drupal.org/project/cvsapplications which was used immediately before our current process.
I'm now also pulling a new column that shows the number of unique issues (i.e. aplications) that were commented on. So you can read the first line as "kiamlaluno posted on 2514 issues a total of 6,584 times" which is just a testament to the fact that kiamlaluno is a really amazing contributor.
knaddison blog | Morris Animal Foundation
jan 31 numbers
Here it is for the last 30 days:
knaddison blog | Morris Animal Foundation