Top Journal Posters

pudge on 2003-02-20T04:03:32

As of right now, ziggy and gnat are tied at 499. I trail with a respectable 451. TorgoX is, of course, #1, closing in on 1,000.

Update: er, 452!


Number of comments

rafael on 2003-02-20T10:09:49

And who leads the number of comments posted ? I bet it's you ;-

Re:Number of comments

pudge on 2003-02-20T11:52:15

Ouch! Indeed.
mysql> SELECT COUNT(*) AS c, users.uid, users.nickname FROM comments, users WHERE users.uid=comments.uid GROUP BY users.uid ORDER BY c DESC LIMIT 10;
+------+------+----------+
| c    | uid  | nickname |
+------+------+----------+
| 1554 |    1 | pudge    |
|  679 | 1087 | Matts    |
|  659 | 1361 | jdavidb  |
|  615 |   74 | hfb      |
|  591 |   25 | ziggy    |
|  501 | 1933 | TorgoX   |
|  472 | 2603 | djberg96 |
|  457 |   29 | gnat     |
|  450 | 1316 | darobin  |
|  387 |   22 | jjohn    |
+------+------+----------+
10 rows in set (0.09 sec)
The most interesting thing about this, to me, is that TorgoX has posted more journal entries than anyone else (except for me) has posted comments. Heck, and he has posted more comments than anyone else (except for him) has posted journal entries. But I've posted more journal entries and comments combined than anyone else, even TorgoX.

That sounds too much like a word problem! Brane!

Re:Number of comments

jdavidb on 2003-02-26T20:28:33

Hmm, wow; I'm a top comment poster? I'm surprised. Apparently I've got a lot to say.

Do you realize this means the vast majority of comments here are made by conservatives? No wonder everyone thinks we're everywhere. :)

Number 8, baby!

jjohn on 2003-02-20T14:24:37

I'm number 8 in the top 10 journlist. Suck it!