Discussion: The usual suspects in 2009

43 comments on “Discussion: The usual suspects in 2009 ”

• Comments are now closed

1. TightyRighty 1

   29 January 2010 at 3:43 pm

   Dammit, beaten by redbaiter, but then again, if i was a provocative person, i’d require more comments too.
2. BLiP 2

   29 January 2010 at 3:46 pm

   Guilty. I changed providers and it took me a wee while to learn to use the dot net thingy instead of dot com. Thanks for doing all the work.
3. mickysavage 3

   29 January 2010 at 3:46 pm

   Gee did I make that many comments?

   If I put that time into billable work …
   • Pat 3.1

     29 January 2010 at 4:10 pm

     I am thinking the same thing. 2010 better be the year of Stop-Fucking-About-On-Blogs.
     • felix 3.1.1

       29 January 2010 at 4:30 pm

       Me too. What method are you considering? Cold turkey?
       • mickysavage 3.1.1.1

         29 January 2010 at 4:39 pm

         There should be a support group.

         I know, someone could start a blog for compulsive bloggers! We could have online support meetings!

         I really do need help …
         • Lew 3.1.1.1.1

           29 January 2010 at 4:45 pm

           Just get some goddamned self-discipline, you wanton libertines. It’s mind over matter. Kids these days.

           L
       • Pat 3.1.1.2

         29 January 2010 at 5:31 pm

         “What method are you considering? Cold turkey?”

         Yep. Although I think I’ll consign myself to just Dimpost as some sort of nicotine patch while I wean myself off all the others.

         That one is the P tab of blogs. He had a genius post on Winston Peters 18 months ago, and I keep going back looking for the same hit.
         • BLiP 3.1.1.2.1

           29 January 2010 at 5:56 pm

           Yep. know what you mean. I got hooked with that John Key interview.
     • Chris 3.1.2

       31 January 2010 at 12:04 am

       Me too. I’m joining you Pat.
4. gingercrush 4

   29 January 2010 at 3:46 pm

   I’m guessing bytes is in regard to how much we’ve actually wrote? My bytes seem rather high but then I’ve never been able to write succintly (sp) only waffle.
   • Pat 4.1

     29 January 2010 at 4:06 pm

     Which means Rex Widerstrom writes the longest posts – 930 byte average.
     • gingercrush 4.1.1

       29 January 2010 at 4:09 pm

       Most of them in regards to, “When I met Winston”.
       • Rex Widerstrom 4.1.1.1

         29 January 2010 at 11:49 pm

         If only I had your erudition, gc…
     • lprent 4.1.2

       29 January 2010 at 4:17 pm

       Yeah I did think of doing the maths, but decided it’d be more fun for other people to have the fun.
5. felix 5

   29 January 2010 at 3:59 pm

   WINRAR!!1
   • lprent 5.1

     29 January 2010 at 4:07 pm

     You want a file compressor? What are you planning on compressing? 😉
   • r0b 5.2

     29 January 2010 at 4:09 pm

     Didn’t you win 100,000th comment too? You da felix! Keep up the good work…
   • BLiP 5.3

     29 January 2010 at 5:45 pm

     EPIC WIN!!

     Onya, mate. I marvel at your ability chop-dice-slice and deliver humour with such economy.
6. Lew 6

   29 January 2010 at 4:34 pm

   Lynn, I’m sure it wouldn’t be hard to chart volume (and byte size) of comments for certain commenters in hour intervals.

   That way we’d also be able to see who comments during work time >:)

   L
   • lprent 6.1

     29 January 2010 at 4:48 pm

     I think that falls under the privacy provisions 😈
7. ghostwhowalksnz 7

   29 January 2010 at 4:36 pm

   The top poster , is about equal to the last 6 or 7 in the top 50.
   Funny how he still seems invisible ?
8. IrishBill 8

   29 January 2010 at 4:47 pm

   I quite like the fact there are so many right-wingers in the top fifty. I’m not so sure I like the fact Burt probably writes more words on the standard in a year than I do. I either need to start writing more or start banning Burt more often 😉
   • lprent 8.1

     29 January 2010 at 4:53 pm

     The latter isn’t a sufficient reason. 🙂

     Besides you really don’t have the patience to keep up with burt. Do you remember that post with a couple of hundred huge comments in it largely between burt and r0b out the legal position on retrospective legislation.

     My fingers got worn out on the trackball.
     • IrishBill 8.1.1

       29 January 2010 at 5:02 pm

       It’s not so much keeping up I don’t have patience for as explaining the same thing ten times while he willfully misconstrues every second word.
   • felix 8.2

     29 January 2010 at 6:08 pm

     Burt probably writes more words on the standard in a year than I do

     Mostly just the same handful of words over and over though isn’t it?
     • IrishBill 8.2.1

       29 January 2010 at 6:55 pm

       You know, retrospectively, I think you may be correct.
       • Redogix 8.2.1.1

         29 January 2010 at 6:59 pm

         Sadly, that word has a whole new meaning for me… something like the view from between your own knees.
9. RedLogix 9

   29 January 2010 at 6:09 pm

   Seeing as how Pascal’s Bookie and I took out the byte count (not including the bastard sysop playing with trolls)….can we borrow your magic file compressor felix?
   • felix 9.1

     29 January 2010 at 6:21 pm

     Anytime.

     Hey Lynn does your byte-count include the additions and notes you make on other people’s comments? Cos if not, that would put your score through the roof.
     • lprent 9.1.1

       29 January 2010 at 9:18 pm

       Nope. They’re allocated to whoever received them…
10. George D 10

    29 January 2010 at 8:10 pm

    Oh dear. 504 comments. Top 30.

    I wonder how many of them weren’t criticising Labour.
    • mickysavage 10.1

      29 January 2010 at 8:40 pm

      Both of them?
      • lukas 10.1.1

        29 January 2010 at 9:00 pm

        try using your fingers and toes next time as well as your hands for counting micky
        • mickysavage 10.1.1.1

          29 January 2010 at 9:13 pm

          Sorry not expressed very well. I wanted to suggest that there were more than one post that did not criticise Labour …
11. randal 11

    30 January 2010 at 10:23 am

    lookiss.
    try writing something that is not a putdown of somebdoy else.
12. Outofbed 12

    30 January 2010 at 6:18 pm

    I make it 17 ish Green voters amongst the top 50
13. jarbury 13

    30 January 2010 at 10:47 pm

    Wow I’m quite surprised that I’m that high up. I guess I wrote quite a lot earlier in the year. Awesome work putting this list together lprent.
    • lprent 13.1

      30 January 2010 at 11:01 pm

      Just SQL..
      • jarbury 13.1.1

        30 January 2010 at 11:48 pm

        Ah that’s all gobble-di-gook to me, makes me think of the word “squirrel” for some reason. A pity as I’d be curious who were the most common commenters on my blog.

        I assume there were more comments in 2009 than 2008, just like there were many more posts?
        • lprent 13.1.1.1

          31 January 2010 at 3:03 am

          You’re running WordPress 2.9.1, same as I am. The query will work on that.

          You have to have access to running a SQL query on your system. You should be able to do it if you have a web access to your SQL server. I used Navicat because I happen to like the tool.

          I’ll put the code up if I remember when I open the laptop. The SQL on the comments wasn’t particularly efficient (I was more interested in the results of a one-off query), so expect it to slow or disable your access to the database while it runs.

          As far as I’m aware there were more comments in 2009.
        • lprent 13.1.1.2

          31 January 2010 at 12:54 pm

          Ok – here is the query. Bear in mind this is grossly inefficient because it was a one-time query and I didn’t bother to optimize. On this site with 150k comments it effectively disables the MySQL while running. The problem is in that top subquery if anyone wants to optimize it. It has to pick up all comments in the top 500 commentators.

          
SELECT
(SELECT comment_author FROM wp_comments AS C
WHERE B.comment_author_email=C.comment_author_email
GROUP BY comment_author
ORDER BY COUNT(*) DESC LIMIT 1) as Name,
SUM(B.Number) AS Comments,
SUM(B.Bytes) AS Bytes
FROM
(
SELECT
comment_author_email,
count(*) as number,
sum(length(comment_content)) as Bytes
FROM
wp_comments AS A
WHERE
comment_date >= "2009-01-01 00:00:00"
AND
comment_date < "2010-01-01 00:00:00" AND comment_approved=1 AND length(comment_author_email) > 0
AND
length(comment_type) = 0
GROUP BY
comment_author_email
ORDER BY
number DESC
LIMIT 500
) AS B
GROUP BY Name
ORDER BY Comments DESC
LIMIT 50
14. kiwiteen123 14

    10 February 2010 at 10:07 pm

    Would you be able to tell me how many comments I’ve made this year… Please… For your favourite blog reviewer 😛

• Comments are now closed

• Log in
• Donate
• Contribute post

• Articles RSS