Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • And who leads the number of comments posted ? I bet it's you ;-
    • by pudge (1) on 2003.02.20 6:52 (#17286) Homepage Journal
      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!
      • 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. :)

        --
        J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers