Discussion: The usual suspects in 2009

Written By: - Date published: 3:30 pm, January 29th, 2010 - 43 comments
Categories: admin, blogs - Tags:

Sysop

Ok, I promised a review of the comments in 2009. Here are the usual suspects with both the number of comments and the number of bytes in the comments so you can see who talks a lot and how much.

This was a little tricky because I used the e-mails to select the top e-mails, but then found that some people used more than one e-mail (yes – I mean you BLiP). Sometimes there were different pseudonyms used on the same e-mail (BLiP!).

But through the powers of SQL and some sub-selection cunning, I pulled them together. I used the most common pseudonym for each e-mail. Then merged the values for same pseudonyms. This gives something that is pretty close to an accurate result. Of course the required sub-queries were a bit hard on the MySQL, and locked everyone out of the database for a few minutes 😈

But I thank you one and all, and the thousands of others that aren’t mentioned here for helping make this site the dynamic and often pretty raucous place that it is to meet in.

The top 50 suspects are overleaf. But I have one query.

Felix probably has the most cutting comments designed to disrupt the underlying precepts of whomever he remarks on. But does he ever sleep?

SuspectCommentsBytes
1Felix2276495,797
2lprent18821,105,815
3Pascal’s bookie1882849,429
4BLiP1746538,327
5Draco T Bastard1303414,218
6Tim Ellis1249613,108
7burt1240455,386
8r0b1184559,326
9RedLogix983729,650
10Lew854391,128
11vto840319,635
12mickysavage828352,603
13Bill794467,603
14gingercrush772441,555
15the sprout747140,409
16Maynard J745331,966
17Ianmac686178,248
18Tigger674183,274
19Quoth the Raven667387,360
20jarbury650294,381
21gobsmacked632257,664
22IrishBill615165,138
23snoozer601167,306
24Daveski598262,645
25Pat594200,169
26outofbed584135,897
27Rex Widerstrom570530,471
28Anita539195,115
29Swampy530241,127
30George D504159,215
31toad496229,472
32So Bored471177,605
33Zaphod Beeblebrox467178,552
34tsmithfield452276,097
35mike44198,209
36prism436205,630
37Eddie436125,505
38Bright red410118,447
39roger nome396117,821
40gitmo39188,852
41Ari383139,864
42Killinginthenameof382110,177
43The Voice of Reason379189,373
44travellerev372234,726
45Tane371108,042
46Redbaiter362192,355
47TightyRighty359120,728
48Daveo356124,252
49Marty G32797,487
50ben321193,003

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

  1. TightyRighty 1

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

  2. BLiP 2

    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. Gee did I make that many comments?

    If I put that time into billable work …

    • Pat 3.1

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

      • felix 3.1.1

        Me too. What method are you considering? Cold turkey?

        • mickysavage 3.1.1.1

          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

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

            L

        • Pat 3.1.1.2

          “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.

      • Chris 3.1.2

        Me too. I’m joining you Pat.

  4. gingercrush 4

    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.

  5. Lew 6

    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

  6. ghostwhowalksnz 7

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

  7. IrishBill 8

    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

      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

        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

      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?

  8. RedLogix 9

    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

      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.

  9. George D 10

    Oh dear. 504 comments. Top 30.

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

  10. randal 11

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

  11. Outofbed 12

    I make it 17 ish Green voters amongst the top 50

  12. 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.

      • jarbury 13.1.1

        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

          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

          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

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

Recent Comments

Recent Posts

  • Membership: Australia and New Zealand Electronic Invoicing Board
    The Governments of Australia and New Zealand have announced the membership of the Australia and New Zealand Electronic Invoicing Board (ANZEIB) today. This is an important step towards implementing e-Invoicing across both countries to help businesses save time and money ...
    2 weeks ago
  • An end to unnecessary secondary tax
    Workers who are paying too much tax because of incorrect secondary tax codes are in line for relief with the passage of legislation through Parliament late last night. The Taxation (Annual Rates for 2018-19, Modernising Tax Administration, and Remedial Matters) ...
    2 weeks ago
  • Chatham Islands pāua plan approved
    Efforts to reverse the decline in the Chatham Islands pāua fishery are the focus of a new plan jointly agreed between government, the local community and industry. Fisheries Minister Stuart Nash says the plan was developed by the PauaMAC4 Industry ...
    2 weeks ago
  • Bill introduced for synthetics crackdown
    The Police will get stronger powers of search and seizure to crackdown on synthetic drugs under new legislation, which makes the two main synthetics (5F-ADB and AMB-FUBINACA) Class A drugs. The Government has today introduced the Misuse of Drugs Amendment ...
    3 weeks ago
  • Blasphemous libel law repealed
    The archaic blasphemous libel offence will be repealed following the passing of the Crimes Amendment Bill today, says Justice Minister Andrew Little. ...
    3 weeks ago
  • Coalition Government lassos livestock rustling
    New rules to crack down on livestock rustling will come into force following the passing of the Crimes Amendment Bill says Justice Minister Andrew Little. ...
    3 weeks ago
  • Medieval law axed
    The ‘year and a day rule’ rule will be repealed following the passing of the Crimes Amendment Bill, says Justice Minister Andrew Little. ...
    3 weeks ago
  • Further steps to combat tax evasion
    Further steps to combat tax evasion Revenue Minister Stuart Nash has announced New Zealand is expanding its global ability to combat tax evasion by joining forces with authorities in 30 countries and jurisdictions. Cabinet has agreed to add another ...
    3 weeks ago