Most active commenters in post git process in the last 30 days, 90 days, all time

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
greggles's picture

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

tim.plunkett's picture

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

oadaeh's picture

that it doesn't take much time or effort to help out tremendously and be on the top of the list. :^)

All time

Michelle's picture

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

tim.plunkett's picture

"All time" since the git migration, I believe.

.

Michelle's picture

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

greggles's picture

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.

.

Michelle's picture

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

zzolo's picture

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

davidhernandez's picture

That System Message guy is awesome. Always helping out.

more project application commenter stats

greggles's picture

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:

count(1) uid name
44 109890 sreynen
35 241634 tim.plunkett
30 1358080 patrickd
28 180064 System Message
27 36762 greggles
24 406552 Everett Zufelt
20 243021 MGParisi
19 784944 ELC
18 202830 TR
14 30906 rfay
14 1011436 rootatwc
11 64383 mlncn
11 369262 bfr
11 107701 joachim
10 1179164 sebasvdkamp
10 742906 Kartagis
9 59610 peronas
9 979270 terryzwt
9 239714 jeffschuler
8 1522762 enmasksteve

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.

the cvsapplicationqueue

greggles's picture

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.

count(1) count(distinct(p.nid)) uid name
6584 2514 55077 kiamlaluno
961 960 180064 System Message
442 324 147331 zzolo
137 129 158886 arianek
203 120 54793 kiam
201 114 54136 sun
153 105 39030 AjK
133 92 53892 Dave Reid
135 72 46854 brianV
101 52 620770 drupalshrek
52 41 23570 Michelle
47 40 202830 TR
50 38 99340 dereine
81 31 613694 Scyther
59 27 109890 sreynen
44 27 213194 Manuel Garcia
46 22 107701 joachim
27 21 258568 YesCT
34 20 1017700 donSchoe
60 20 122101 pcambra

jan 31 numbers

greggles's picture

Here it is for the last 30 days:

count(c.cid) count(distinct c.nid) uid name
301 154 1358080 patrickd
271 197 262198 klausi
261 158 382892 MiSc
240 93 833794 doitDave
118 42 253683 raynimmo
113 68 148199 jthorson
77 77 180064 System Message
71 8 669922 barnettech
47 28 784944 ELC
38 16 1564666 natemow
28 2 531118 yannickoo
28 8 243882 andrewyager
28 20 36762 greggles
26 9 890274 rudiedirkx
26 15 846558 drupalnetworks
25 7 577920 bailey86
23 10 919186 michaelmol
22 8 369262 bfr
22 11 263391 f4k1r
20 16 574814 chakrapani

Code review for security advisory coverage applications

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week