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

  • Progress in establishment of Aged Care Commissioner
    Recruitment for an Aged Care Commissioner will start next month, to ensure greater oversight of New Zealand’s aged care sector. “This sector is responsible for supporting a large and often vulnerable population. While most people are able to access quality care, there have been cases where that care has fallen ...
    BeehiveBy beehive.govt.nz
    2 hours ago
  • New record number of homes consented
    In the year ended June 2021, the actual number of new dwellings consented was 44,299, up 18 percent from the June 2020 year. In June 2021, the seasonally adjusted number of new dwellings consented rose 3.8 percent. In June 2021, 4,310 new dwellings were consented, an increase of 3.8 per ...
    BeehiveBy beehive.govt.nz
    23 hours ago
  • Communities backed to tackle wilding pines
    Twelve community projects across New Zealand will receive a share of $2 million to carry out wilding pine control, Biosecurity Minister Damien O’Connor announced as part of Biosecurity Week. “Wilding pines are a serious problem that threaten many of the unique landscapes that New Zealanders value. Community groups and trusts ...
    BeehiveBy beehive.govt.nz
    24 hours ago
  • Health Minister Andrew Little responding to the New Zealand Nurses Organisation's rejection of ...
    I was advised last night that the result of the ballot of Tōpūtanga Tapuhi Kaitiaki o Aotearoa New Zealand Nurses Organisation members have rejected the latest proposal to settle their collective agreement. Let me be clear: the proposal was one they put to the Government. The Nurses Organisation rejected their ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Conversion Practices Prohibition Legislation introduced to Parliament
    Legislation has been introduced to Parliament to protect against practices intended to change or suppress someone’s sexual orientation, gender identity, or gender expression. Introducing the Conversion Practices Prohibition Legislation Bill, Minister of Justice, Kris Faafoi, said the measures proposed were aimed at ending conversion practices which don’t work, are widely ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • New school site for booming West Auckland
    The Government will build on a new school site in West Auckland to cope with rapid population growth in the area, Education Minister Chris Hipkins says. The Ministry is working with existing local schools to determine how the 1.5-hectare site at 279 Hobsonville Point Road will be used to support ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Trans-Tasman travel window to close at midnight tomorrow
    A further 500 MIQ rooms released for managed returnees from NSW Further Government actions announced today are balanced to provide more certainty for Kiwis wanting to return from Australia, while continuing to protect New Zealand from COVID-19, acting Minister for COVID-19 Response Ayesha Verrall says. The actions were foreshadowed last ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Govt investing millions in Hawke's Bay and Tairāwhiti schools
    Napier Boys’ and Girls’ High Schools are among those set to benefit from a $16.5 million investment in the Hawke's Bay and Tairāwhiti region, Economic and Regional Development Minister Stuart Nash announced today. The Government has set aside money in Budget 2021 to accelerate five projects in Napier, Hastings, Havelock North ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Game changing Jobs for Nature investment for Northland
    Conservation Minister Kiri Allan has announced Jobs for Nature funding for a portfolio of projects that will create ‘game changing’ gains for nature and communities across Northland/Te Tai Tokerau as part of the Government’s acceleration of the economic recovery from COVID. “This portfolio of 12 projects will see over $20 ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Third COVID-19 vaccine receives provisional approval
    New Zealand’s regulatory authority Medsafe has granted provisional approval of the AstraZeneca COVID-19 vaccine for individuals 18 years of age and older, Acting Minister for COVID-19 Response Dr Ayesha Verrall announced today. New Zealand secured 7.6 million doses (enough for 3.8 million people) of the AstraZeneca COVID-19 vaccine through an ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Bowel-cancer screening programme is saving lives
    More than 1000 New Zealanders have had bowel cancer – New Zealand’s second-most-common cause of death from cancer - detected under the Government’s National Bowel Screening Programme, Health Minister Andrew Little said today. More than 1200 New Zealanders died from bowel cancer in 2017. The screening programme aims to save ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Govt welcomes draft report on the retail grocery sector
    The Commerce Commission’s draft report into the retail grocery sector is being welcomed by Government as a major milestone. “I asked the Commerce Commission to look at whether this sector is as competitive as it could be and today it has released its draft report for consultation,” Commerce and Consumer ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Christchurch’s Youth Hub ‘set to go’ thanks to further Government funding
    Construction of New Zealand’s first, purpose-built centre for youth well-being is ready to get underway thanks to an extra $2.5 million of COVID-19 response funding, Housing Minister and Associate Minister of Finance, Megan Woods announced today.  “The Christchurch Youth Hub is about bringing together all the things young people need ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Next step to protect Milford Sound Piopiotahi
    Expert group lays out plan to better protect iconic UNESCO World Heritage site Milford Sound Piopiotahi and its surrounds Funding confirmed for dedicated unit and Establishment Board to assess the recommendations and provide oversight of the process from here Milford Opportunities Project a test case for transformational change in tourism ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • Funding for projects to reduce waste from construction and demolition
    The Government has announced funding for projects in Auckland and the lower North Island to help reduce construction and demolition waste. “Construction is the main source of waste sent to landfill, and much of this could be reduced, reused and recovered,” Environment Minister David Parker said. “The Government is funding ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • Speech at the launch of the National Hepatitis C Action Plan
    Tēnā koutou katoa. Thank you Anglesea Pharmacy and Te Manawa Taki for hosting this event. As a doctor, I saw first hand the impact of hepatitis C. I met Moana in 2019; she came to the infectious diseases outpatient clinic at Wellington Hospital having tested positive for hepatitis C. Like ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • Plan to eliminate hepatitis C as a major health threat by 2030
    A plan to eliminate hepatitis C in New Zealand, reducing liver cancer and the need for liver transplants, has been released today by Associate Minister of Health Dr Ayesha Verrall. “Around 45,000 New Zealanders have hepatitis C, but only around half know they have it,” said Ayesha Verrall. “Symptoms often ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • School upgrades and new classrooms for West Coast, Tasman and Canterbury
    A funding injection from Budget 2021 to complete four shovel ready projects and new classrooms at six schools and kura will provide a real boost to local communities, Minister Dr Megan Woods announced today. “This Government has committed to providing quality fit for purpose learning environments and 100,000 new student ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • Warmer Kiwi Homes smashes annual target
    The Government's highly successful insulation and heating programme, Warmer Kiwi Homes, is celebrating a key milestone with the completion of more than 38,000 insulation and efficient heater installs in the year to the end of June, smashing its target of 25,000 installs for the year. “The Warmer Kiwi Homes scheme ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Exemption granted for Wallabies to enter NZ
    Bledisloe Cup rugby will be played in New Zealand after the Australian rugby team received an economic exemption to enter New Zealand. Travel between Australia and New Zealand was suspended on Friday for at least eight weeks following the worsening of the COVID outbreak across the Tasman. New Zealanders have ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Minister of Foreign Affairs makes three diplomatic appointments
    Foreign Affairs Minister Nanaia Mahuta today announced three New Zealand Head of Mission appointments. They are: Mike Walsh as Ambassador to Iran Michael Upton as Ambassador to Ethiopia and the African Union Kevin Burnett as Ambassador to Indonesia Iran “Aotearoa New Zealand has a long-standing and constructive relationship with Iran, despite a ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Enhanced Task Force Green Approved for West Coast and Marlborough
    The Government has activated Enhanced Task Force Green (ETFG) in response to the West Coast and Marlborough floods, Social Development and Employment Minister Carmel Sepuloni announced today. “To assist with the clean-up, up to $500,000 will be made available to support the recovery in Buller and Marlborough which has experienced ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Govt support for upgrade of Eden Park players facilities
    Minister for Sport and Recreation Hon Grant Robertson has announced funding to upgrade the players facilities at Eden Park ahead of upcoming Women’s World Cup events. Eden Park is a confirmed venue for the Rugby World Cup 2021, the ICC Women’s Cricket World Cup 2022, and a proposed venue for matches of ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • More jobs and quicker public transport motoring towards West Auckland
    Work to improve public transport for West Aucklanders and support the region’s economic recovery by creating hundreds of jobs has officially kicked off, Transport Minister Michael Wood announced today. Michael Wood and Auckland Mayor Phil Goff this morning marked the start of construction on the Northwestern Bus Improvements project. It ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Government backs critical health research
    Research into some of New Zealanders’ biggest health concerns including cancer, diabetes, and heart disease is getting crucial support in the latest round of health research funding, Health Minister Andrew Little announced today. The funding, awarded through the Health Research Council of New Zealand, covers 31 General Project grants ($36.64 ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • New Bay of Islands hospital facilities to bring services closer to home
    Prime Minister Jacinda Ardern and Health Minister Andrew Little have joined a ceremony to bless the site and workers for Phase Two of the redevelopment of the Bay of Islands Hospital in Kawakawa today. The new building will house outpatients and primary care facilities, as well as expanded renal care ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Raukokore re-imagined with ‘smart’ relocatable rent to own housing
    Iwi, Crown Partnership Relocatable, fully insulated housing, connected to a new solar plant Provides a pathway to home ownership New housing in the remote eastern Bay of Plenty community of Raukokore shows how iwi and Crown agencies can work together effectively to provide warm, dry, energy efficient homes in a ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Cabinet accepts Turkish authorities’ request for the managed return of three NZ citizens
    Cabinet has agreed to the managed return of a New Zealand citizen and her two young children from Turkey, Prime Minister Jacinda Ardern announced today. The three have been in immigration detention in Turkey since crossing the border from Syria earlier this year. Turkey has requested that New Zealand repatriate ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Govt delivers more classrooms so children can focus on learning
    Extra Government investment in classrooms and school building projects will enable students and teachers to focus on education rather than overcrowding as school rolls grow across the country, Prime Minister Jacinda Ardern and Associate Education Minister Kelvin Davis say. The pair visited Ruakākā School in Whangārei today to announce $100 ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • New station a platform for AirportLink to take off
    Every Aucklander with access to the rail network will now have a quick and convenient trip to the airport, Transport Minister Michael Wood and Auckland Mayor Phil Goff said during the official opening of the new Puhinui Interchange today. The new interchange links the rail platform with a new bus ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • 10 days sick leave for employees delivered
    Legislation doubling employees’ minimum sick leave entitlement to 10 days comes into effect today, bringing benefits to both businesses and employees, Workplace Relations and Safety Minister Michael Wood announced today. “Our Government is delivering on a key manifesto commitment to help Kiwis and workplaces stay healthy,” Michael Wood said. “COVID-19 ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Prime Minister congratulates Fiame Naomi Mata’afa on Election Win
    Prime Minister Jacinda Ardern tonight congratulated Prime Minister-elect Fiame Naomi Mata’afa on her victory in the Samoa’s general election. “New Zealand has a special relationship with Samoa, anchored in the Treaty of Friendship. We look forward to working with Samoa’s new government in the spirit of partnership that characterises this ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Quarantine Free Travel with Australia suspended
    Quarantine Free Travel from all Australian states and territories to New Zealand is being suspended as the Covid situation there worsens, Prime Minister Jacinda Ardern and COVID-19 Response Minister Chris Hipkins announced today. From 11.59pm today Australians will no longer be able to enter New Zealand quarantine-free. This will be ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Growing conservation efforts in Gisborne
    A big injection of Jobs for Nature funding will create much-needed jobs and financial security for families in TeTairāwhiti, and has exciting prospects for conservation in the region, Conservation Minister Kiri Allan says. “The projects target local communities most affected by the economic consequences of COVID 19 and are designed ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Flood recovery given further assistance
    The Government is contributing a further $1 million to help the flood battered Buller community, Acting Emergency Management Minister Kris Faafoi announced today. “Buller is a small community which has found itself suddenly facing significant and ongoing welfare costs. While many emergency welfare costs are reimbursed by Government, this money ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Funding for five projects to reduce food waste
    The Government is funding five projects to help address the growing problem of food waste, Environment Minister David Parker announced today. “New Zealand households throw away nearly 300,000 tonnes of food every year, half of which could still be eaten. By supporting these initiatives, we’re taking steps to reduce this ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Temporary Accommodation Service activated for West Coast flooding event
    The Temporary Accommodation Service (TAS) has been activated today - meaning residents on the West Coast of the South Island and in the Marlborough region hit by flooding over the weekend can now access help finding temporary accommodation, announced Associate Minister of Housing (Public Housing) Poto Williams in Westport today. ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Pause to Quarantine Free Travel from South Australia to New Zealand
    Quarantine Free Travel from South Australia to New Zealand will be paused from 11.59am (NZT) tonight, COVID-19 Response Minister Chris Hipkins has announced. However, people currently in the state who ordinarily live in New Zealand will be able to return on “managed return” flights starting with the next available flight, ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • New Zealand condemns malicious cyber activity by Chinese state-sponsored actors
    New Zealand has established links between Chinese state-sponsored actors known as Advanced Persistent Threat 40 (APT40) and malicious cyber activity in New Zealand. “The GCSB has worked through a robust technical attribution process in relation to this activity. New Zealand is today joining other countries in strongly condemning this malicious ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Remarks to Diplomatic Corps
    It is a pleasure to be with you all this evening. Some of you may have been surprised when you received an invitation from the Minister of Disarmament and Arms Control, and I would forgive you if you were. New Zealand is unique in having established a Ministerial portfolio ...
    BeehiveBy beehive.govt.nz
    2 weeks ago