web analytics

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?

Suspect Comments Bytes
1 Felix 2276 495,797
2 lprent 1882 1,105,815
3 Pascal’s bookie 1882 849,429
4 BLiP 1746 538,327
5 Draco T Bastard 1303 414,218
6 Tim Ellis 1249 613,108
7 burt 1240 455,386
8 r0b 1184 559,326
9 RedLogix 983 729,650
10 Lew 854 391,128
11 vto 840 319,635
12 mickysavage 828 352,603
13 Bill 794 467,603
14 gingercrush 772 441,555
15 the sprout 747 140,409
16 Maynard J 745 331,966
17 Ianmac 686 178,248
18 Tigger 674 183,274
19 Quoth the Raven 667 387,360
20 jarbury 650 294,381
21 gobsmacked 632 257,664
22 IrishBill 615 165,138
23 snoozer 601 167,306
24 Daveski 598 262,645
25 Pat 594 200,169
26 outofbed 584 135,897
27 Rex Widerstrom 570 530,471
28 Anita 539 195,115
29 Swampy 530 241,127
30 George D 504 159,215
31 toad 496 229,472
32 So Bored 471 177,605
33 Zaphod Beeblebrox 467 178,552
34 tsmithfield 452 276,097
35 mike 441 98,209
36 prism 436 205,630
37 Eddie 436 125,505
38 Bright red 410 118,447
39 roger nome 396 117,821
40 gitmo 391 88,852
41 Ari 383 139,864
42 Killinginthenameof 382 110,177
43 The Voice of Reason 379 189,373
44 travellerev 372 234,726
45 Tane 371 108,042
46 Redbaiter 362 192,355
47 TightyRighty 359 120,728
48 Daveo 356 124,252
49 Marty G 327 97,487
50 ben 321 193,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. felix 5

    WINRAR!!1

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

  7. ghostwhowalksnz 7

    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

    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?

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

  10. George D 10

    Oh dear. 504 comments. Top 30.

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

  11. randal 11

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

  12. Outofbed 12

    I make it 17 ish Green voters amongst the top 50

  13. jarbury 13

    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

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

  • Jump starting research careers
    The Government is investing up to $10 million to support 30 of the country’s top early-career researchers to develop their research skills. “The pandemic has had widespread impacts across the science system, including the research workforce. After completing their PhD, researchers often travel overseas to gain experience but in the ...
    BeehiveBy beehive.govt.nz
    3 hours ago
  • Project protects jobs and nature
    A Waitomo-based Jobs for Nature project will keep up to ten people employed in the village as the tourism sector recovers post Covid-19 Conservation Minister Kiri Allan says. “This $500,000 project will save ten local jobs by deploying workers from Discover Waitomo into nature-based jobs. They will be undertaking local ...
    BeehiveBy beehive.govt.nz
    22 hours ago
  • Minister Shaw speaks with U.S. Presidential Envoy John Kerry
    Minister for Climate Change, James Shaw spoke yesterday with President Biden’s Special Presidential Envoy for Climate John Kerry. “I was delighted to have the opportunity to speak with Mr. Kerry this morning about the urgency with which our governments must confront the climate emergency. I am grateful to him and ...
    BeehiveBy beehive.govt.nz
    23 hours ago
  • Minister of Foreign Affairs makes three diplomatic appointments
    Foreign Affairs Minister Hon Nanaia Mahuta today announced three diplomatic appointments: Alana Hudson as Ambassador to Poland John Riley as Consul-General to Hong Kong Stephen Wong as Consul-General to Shanghai   Poland “New Zealand’s relationship with Poland is built on enduring personal, economic and historical connections. Poland is also an important ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Major redevelopment of Wainuiomata High School underway
    Work begins today at Wainuiomata High School to ensure buildings and teaching spaces are fit for purpose, Education Minister Chris Hipkins says. The Minister joined principal Janette Melrose and board chair Lynda Koia to kick off demolition for the project, which is worth close to $40 million, as the site ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • New expert group appointed to advise Government on Oranga Tamariki
    A skilled and experienced group of people have been named as the newly established Oranga Tamariki Ministerial Advisory Board by Children’s Minister Kelvin Davis today. The Board will provide independent advice and assurance to the Minister for Children across three key areas of Oranga Tamariki: relationships with families, whānau, and ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • COVID-19 vaccine slated for possible approval next week
    The green light for New Zealand’s first COVID-19 vaccine could be granted in just over a week, Prime Minister Jacinda Ardern said today. “We’re making swift progress towards vaccinating New Zealanders against the virus, but we’re also absolutely committed to ensuring the vaccines are safe and effective,” Jacinda Ardern said. ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • New ACC Board members announced.
    The Minister for ACC is pleased to announce the appointment of three new members to join the Board of ACC on 1 February 2021. “All three bring diverse skills and experience to provide strong governance oversight to lead the direction of ACC” said Hon Carmel Sepuloni. Bella Takiari-Brame from Hamilton ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Economic boost for Southland marae
    The Government is investing $9 million to upgrade a significant community facility in Invercargill, creating economic stimulus and jobs, Infrastructure Minister Grant Robertson and Te Tai Tonga MP Rino Tirikatene have announced.  The grant for Waihōpai Rūnaka Inc to make improvements to Murihiku Marae comes from the $3 billion set ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Celebrating the Entry Into Force of the Treaty on the Prohibition of Nuclear Weapons
    [Opening comments, welcome and thank you to Auckland University etc] It is a great pleasure to be here this afternoon to celebrate such an historic occasion - the entry into force of the Treaty on the Prohibition of Nuclear Weapons. This is a moment many feared would never come, but ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Supporting disabled people to stay connected
    The Government is providing $3 million in one-off seed funding to help disabled people around New Zealand stay connected and access support in their communities, Minister for Disability Issues, Carmel Sepuloni announced today. The funding will allow disability service providers to develop digital and community-based solutions over the next two ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Voluntary saliva testing offered to quarantine workers from Monday
    Border workers in quarantine facilities will be offered voluntary daily COVID-19 saliva tests in addition to their regular weekly testing, COVID-19 Response Minister Chris Hipkins said today. This additional option will be rolled out at the Jet Park Quarantine facility in Auckland starting on Monday 25 January, and then to ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Next steps in firearms buy-back
    The next steps in the Government’s ambitious firearms reform programme to include a three-month buy-back have been announced by Police Minister Poto Williams today.  “The last buy-back and amnesty was unprecedented for New Zealand and was successful in collecting 60,297 firearms, modifying a further 5,630 firearms, and collecting 299,837 prohibited ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • Jobs for Nature projects target iconic ecosystems
    Upscaling work already underway to restore two iconic ecosystems will deliver jobs and a lasting legacy, Conservation Minister Kiri Allan says.  “The Jobs for Nature programme provides $1.25 billion over four years to offer employment opportunities for people whose livelihoods have been impacted by the COVID-19 recession. “Two new projects ...
    BeehiveBy beehive.govt.nz
    7 days ago
  • New Public Housing Plan announced
    The Government has released its Public Housing Plan 2021-2024 which outlines the intention of where 8,000 additional public and transitional housing places announced in Budget 2020, will go. “The Government is committed to continuing its public house build programme at pace and scale. The extra 8,000 homes – 6000 public ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Prime Minister congratulates President Joe Biden on his inauguration
    Prime Minister Jacinda Ardern has congratulated President Joe Biden on his inauguration as the 46th President of the United States of America. “I look forward to building a close relationship with President Biden and working with him on issues that matter to both our countries,” Jacinda Ardern said. “New Zealand ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Jobs for Nature funding will create training and employment opportunities
    A major investment to tackle wilding pines in Mt Richmond will create jobs and help protect the area’s unique ecosystems, Biosecurity Minister Damien O’Connor says. The Mt Richmond Forest Park has unique ecosystems developed on mineral-rich geology, including taonga plant species found nowhere else in the country. “These special plant ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Pre-departure testing extended to all passengers to New Zealand
    To further protect New Zealand from COVID-19, the Government is extending pre-departure testing to all passengers to New Zealand except from Australia, Antarctica and most Pacific Islands, COVID-19 Response Minister Chris Hipkins said today. “The change will come into force for all flights arriving in New Zealand after 11:59pm (NZT) on Monday ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Bay Cadets learn skills to protect environment
    Bay Conservation Cadets launched with first intake Supported with $3.5 million grant Part of $1.245b Jobs for Nature programme to accelerate recover from Covid Cadets will learn skills to protect and enhance environment Environment Minister David Parker today welcomed the first intake of cadets at the launch of the Bay ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Cook Islanders to resume travel to New Zealand
    The Prime Minister of New Zealand Jacinda Ardern and the Prime Minister of the Cook Islands Mark Brown have announced passengers from the Cook Islands can resume quarantine-free travel into New Zealand from 21 January, enabling access to essential services such as health. “Following confirmation of the Cook Islands’ COVID ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Supporting communities and landowners to grow employment opportunities
    Jobs for Nature funding is being made available to conservation groups and landowners to employ staff and contractors in a move aimed at boosting local biodiversity-focused projects, Conservation Minister Kiritapu Allan has announced. It is estimated some 400-plus jobs will be created with employment opportunities in ecology, restoration, trapping, ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Border exception for some returning international tertiary students
    The Government has approved an exception class for 1000 international tertiary students, degree level and above, who began their study in New Zealand but were caught offshore when border restrictions began. The exception will allow students to return to New Zealand in stages from April 2021. “Our top priority continues ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Tiwai deal gives time for managed transition
    Today’s deal between Meridian and Rio Tinto for the Tiwai smelter to remain open another four years provides time for a managed transition for Southland. “The deal provides welcome certainty to the Southland community by protecting jobs and incomes as the region plans for the future. The Government is committed ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • New member for APEC Business Advisory Council
    Prime Minister Jacinda Ardern has appointed Anna Curzon to the APEC Business Advisory Council (ABAC). The leader of each APEC economy appoints three private sector representatives to ABAC. ABAC provides advice to leaders annually on business priorities. “ABAC helps ensure that APEC’s work programme is informed by business community perspectives ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Govt’s careful economic management recognised
    The Government’s prudent fiscal management and strong policy programme in the face of the COVID-19 global pandemic have been acknowledged by the credit rating agency Fitch. Fitch has today affirmed New Zealand’s local currency rating at AA+ with a stable outlook and foreign currency rating at AA with a positive ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Additional actions to keep COVID-19 out of NZ
    The Government is putting in place a suite of additional actions to protect New Zealand from COVID-19, including new emerging variants, COVID-19 Response Minister Chris Hipkins said today. “Given the high rates of infection in many countries and evidence of the global spread of more transmissible variants, it’s clear that ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • 19 projects will clean up and protect waterways
    $36 million of Government funding alongside councils and others for 19 projects Investment will clean up and protect waterways and create local jobs Boots on the ground expected in Q2 of 2021 Funding part of the Jobs for Nature policy package A package of 19 projects will help clean up ...
    BeehiveBy beehive.govt.nz
    3 weeks ago