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

  • Ō-Rākau Remembrance Bill passes first reading
    The return of the historic Ō-Rākau battle site to the descendants of those who fought there moved one step closer today with the first reading of Te Pire mō Ō-Rākau, Te Pae o Maumahara / The Ō-Rākau Remembrance Bill. The Bill will entrust the 9.7-hectare battle site, five kilometres west ...
    BeehiveBy beehive.govt.nz
    7 hours ago
  • Government to boost public EV charging network
    Energy Minister Simeon Brown has announced 25 new high-speed EV charging hubs along key routes between major urban centres and outlined the Government’s plan to supercharge New Zealand’s EV infrastructure.  The hubs will each have several chargers and be capable of charging at least four – and up to 10 ...
    BeehiveBy beehive.govt.nz
    7 hours ago
  • Residential Property Managers Bill to not progress
    The coalition Government will not proceed with the previous Government’s plans to regulate residential property managers, Housing Minister Chris Bishop says. “I have written to the Chairperson of the Social Services and Community Committee to inform him that the Government does not intend to support the Residential Property Managers Bill ...
    BeehiveBy beehive.govt.nz
    7 hours ago
  • Independent review into disability support services
    The Government has announced an independent review into the disability support system funded by the Ministry of Disabled People – Whaikaha. Disability Issues Minister Louise Upston says the review will look at what can be done to strengthen the long-term sustainability of Disability Support Services to provide disabled people and ...
    BeehiveBy beehive.govt.nz
    13 hours ago
  • Justice Minister updates UN on law & order plan
    Justice Minister Paul Goldsmith has attended the Universal Periodic Review in Geneva and outlined the Government’s plan to restore law and order. “Speaking to the United Nations Human Rights Council provided us with an opportunity to present New Zealand’s human rights progress, priorities, and challenges, while responding to issues and ...
    BeehiveBy beehive.govt.nz
    14 hours ago
  • Trade Minister travels to Riyadh, OECD, and Dubai
    Trade Minister Todd McClay heads overseas today for high-level trade talks in the Gulf region, and a key OECD meeting in Paris. Mr McClay will travel to Riyadh to meet with counterparts from Saudi Arabia and the Gulf Cooperation Council (GCC). “New Zealand’s goods and services exports to the Gulf region ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Education priorities focused on lifting achievement
    Education Minister Erica Stanford has outlined six education priorities to deliver a world-leading education system that sets Kiwi kids up for future success. “I’m putting ambition, achievement and outcomes at the heart of our education system. I want every child to be inspired and engaged in their learning so they ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • NZTA App first step towards digital driver licence
    The new NZ Transport Agency (NZTA) App is a secure ‘one stop shop’ to provide the services drivers need, Transport Minister Simeon Brown and Digitising Government Minister Judith Collins say.  “The NZTA App will enable an easier way for Kiwis to pay for Vehicle Registration and Road User Charges (RUC). ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Supporting whānau out of emergency housing
    Whānau with tamariki growing up in emergency housing motels will be prioritised for social housing starting this week, says Associate Housing Minister Tama Potaka. “Giving these whānau a better opportunity to build healthy stable lives for themselves and future generations is an essential part of the Government’s goal of reducing ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Tribute to Dave O'Sullivan
    Racing Minister Winston Peters has paid tribute to an icon of the industry with the recent passing of Dave O’Sullivan (OBE). “Our sympathies are with the O’Sullivan family with the sad news of Dave O’Sullivan’s recent passing,” Mr Peters says. “His contribution to racing, initially as a jockey and then ...
    BeehiveBy beehive.govt.nz
    1 day ago
  • Speech – Eid al-Fitr
    Assalaamu alaikum, greetings to you all. Eid Mubarak, everyone! I want to extend my warmest wishes to you and everyone celebrating this joyous occasion. It is a pleasure to be here. I have enjoyed Eid celebrations at Parliament before, but this is my first time joining you as the Minister ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Government saves access to medicines
    Associate Health Minister David Seymour has announced Pharmac’s largest ever budget of $6.294 billion over four years, fixing a $1.774 billion fiscal cliff.    “Access to medicines is a crucial part of many Kiwis’ lives. We’ve committed to a budget allocation of $1.774 billion over four years so Kiwis are ...
    BeehiveBy beehive.govt.nz
    2 days ago
  • Pharmac Chair appointed
    Hon Paula Bennett has been appointed as member and chair of the Pharmac board, Associate Health Minister David Seymour announced today. "Pharmac is a critical part of New Zealand's health system and plays a significant role in ensuring that Kiwis have the best possible access to medicines,” says Mr Seymour. ...
    BeehiveBy beehive.govt.nz
    3 days ago
  • Taking action on Fetal Alcohol Spectrum Disorder
    Hundreds of New Zealand families affected by Fetal Alcohol Spectrum Disorder (FASD) will benefit from a new Government focus on prevention and treatment, says Health Minister Dr Shane Reti. “We know FASD is a leading cause of preventable intellectual and neurodevelopmental disability in New Zealand,” Dr Reti says.  “Every day, ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • New sports complex opens in Kaikohe
    Regional Development Minister Shane Jones today attended the official opening of Kaikohe’s new $14.7 million sports complex. “The completion of the Kaikohe Multi Sports Complex is a fantastic achievement for the Far North,” Mr Jones says. “This facility not only fulfils a long-held dream for local athletes, but also creates ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Diplomacy needed more than ever
    Foreign Minister Winston Peters’ engagements in Türkiye this week underlined the importance of diplomacy to meet growing global challenges.    “Returning to the Gallipoli Peninsula to represent New Zealand at Anzac commemorations was a sombre reminder of the critical importance of diplomacy for de-escalating conflicts and easing tensions,” Mr Peters ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Anzac Commemorative Address, Buttes New British Cemetery Belgium
    Ambassador Millar, Burgemeester, Vandepitte, Excellencies, military representatives, distinguished guests, ladies and gentlemen – good morning and welcome to this sacred Anzac Day dawn service.  It is an honour to be here on behalf of the Government and people of New Zealand at Buttes New British Cemetery, Polygon Wood – a deeply ...
    BeehiveBy beehive.govt.nz
    4 days ago
  • Anzac Commemorative Address – NZ National Service, Chunuk Bair
    Distinguished guests -   It is an honour to return once again to this site which, as the resting place for so many of our war-dead, has become a sacred place for generations of New Zealanders.   Our presence here and at the other special spaces of Gallipoli is made ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • Anzac Commemorative Address – Dawn Service, Gallipoli, Türkiye
    Mai ia tawhiti pamamao, te moana nui a Kiwa, kua tae whakaiti mai matou, ki to koutou papa whenua. No koutou te tapuwae, no matou te tapuwae, kua honoa pumautia.   Ko nga toa kua hinga nei, o te Waipounamu, o te Ika a Maui, he okioki tahi me o ...
    BeehiveBy beehive.govt.nz
    5 days ago
  • PM announces changes to portfolios
    Paul Goldsmith will take on responsibility for the Media and Communications portfolio, while Louise Upston will pick up the Disability Issues portfolio, Prime Minister Christopher Luxon announced today. “Our Government is relentlessly focused on getting New Zealand back on track. As issues change in prominence, I plan to adjust Ministerial ...
    BeehiveBy beehive.govt.nz
    6 days ago
  • New catch limits for unique fishery areas
    Recreational catch limits will be reduced in areas of Fiordland and the Chatham Islands to help keep those fisheries healthy and sustainable, Oceans and Fisheries Minister Shane Jones says. The lower recreational daily catch limits for a range of finfish and shellfish species caught in the Fiordland Marine Area and ...
    BeehiveBy beehive.govt.nz
    7 days ago
  • Minister welcomes hydrogen milestone
    Energy Minister Simeon Brown has welcomed an important milestone in New Zealand’s hydrogen future, with the opening of the country’s first network of hydrogen refuelling stations in Wiri. “I want to congratulate the team at Hiringa Energy and its partners K one W one (K1W1), Mitsui & Co New Zealand ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Urgent changes to system through first RMA Amendment Bill
    The coalition Government is delivering on its commitment to improve resource management laws and give greater certainty to consent applicants, with a Bill to amend the Resource Management Act (RMA) expected to be introduced to Parliament next month. RMA Reform Minister Chris Bishop has today outlined the first RMA Amendment ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Overseas decommissioning models considered
    Overseas models for regulating the oil and gas sector, including their decommissioning regimes, are being carefully scrutinised as a potential template for New Zealand’s own sector, Resources Minister Shane Jones says. The Coalition Government is focused on rebuilding investor confidence in New Zealand’s energy sector as it looks to strengthen ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Release of North Island Severe Weather Event Inquiry
    Emergency Management and Recovery Minister Mark Mitchell has today released the Report of the Government Inquiry into the response to the North Island Severe Weather Events. “The report shows that New Zealand’s emergency management system is not fit-for-purpose and there are some significant gaps we need to address,” Mr Mitchell ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Justice Minister to attend Human Rights Council
    Justice Minister Paul Goldsmith is today travelling to Europe where he’ll update the United Nations Human Rights Council on the Government’s work to restore law and order.  “Attending the Universal Periodic Review in Geneva provides us with an opportunity to present New Zealand’s human rights progress, priorities, and challenges, while ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Patterson reopens world’s largest wool scouring facility
    Associate Agriculture Minister, Mark Patterson, formally reopened the world’s largest wool processing facility today in Awatoto, Napier, following a $50 million rebuild and refurbishment project. “The reopening of this facility will significantly lift the economic opportunities available to New Zealand’s wool sector, which already accounts for 20 per cent of ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Speech to the Southland Otago Regional Engineering Collective Summit, 18 April 2024
    Hon Andrew Bayly, Minister for Small Business and Manufacturing  At the Southland Otago Regional Engineering Collective (SOREC) Summit, 18 April, Dunedin    Ngā mihi nui, Ko Andrew Bayly aho, Ko Whanganui aho    Good Afternoon and thank you for inviting me to open your summit today.    I am delighted ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Government to introduce revised Three Strikes law
    The Government is delivering on its commitment to bring back the Three Strikes legislation, Associate Justice Minister Nicole McKee announced today. “Our Government is committed to restoring law and order and enforcing appropriate consequences on criminals. We are making it clear that repeat serious violent or sexual offending is not ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • New diplomatic appointments
    Foreign Minister Winston Peters has today announced four new diplomatic appointments for New Zealand’s overseas missions.   “Our diplomats have a vital role in maintaining and protecting New Zealand’s interests around the world,” Mr Peters says.    “I am pleased to announce the appointment of these senior diplomats from the ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Humanitarian support for Ethiopia and Somalia
    New Zealand is contributing NZ$7 million to support communities affected by severe food insecurity and other urgent humanitarian needs in Ethiopia and Somalia, Foreign Minister Rt Hon Winston Peters announced today.   “Over 21 million people are in need of humanitarian assistance across Ethiopia, with a further 6.9 million people ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Arts Minister congratulates Mataaho Collective
    Minister for Arts, Culture and Heritage Paul Goldsmith is congratulating Mataaho Collective for winning the Golden Lion for best participant in the main exhibition at the Venice Biennale. "Congratulations to the Mataaho Collective for winning one of the world's most prestigious art prizes at the Venice Biennale.  “It is good ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Supporting better financial outcomes for Kiwis
    The Government is reforming financial services to improve access to home loans and other lending, and strengthen customer protections, Commerce and Consumer Affairs Minister Andrew Bayly and Housing Minister Chris Bishop announced today. “Our coalition Government is committed to rebuilding the economy and making life simpler by cutting red tape. We are ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • Trade relationship with China remains strong
    “China remains a strong commercial opportunity for Kiwi exporters as Chinese businesses and consumers continue to value our high-quality safe produce,” Trade and Agriculture Minister Todd McClay says.   Mr McClay has returned to New Zealand following visits to Beijing, Harbin and Shanghai where he met ministers, governors and mayors and engaged in trade and agricultural events with the New ...
    BeehiveBy beehive.govt.nz
    1 week ago
  • PM’s South East Asia mission does the business
    Prime Minister Christopher Luxon has completed a successful trip to Singapore, Thailand and the Philippines, deepening relationships and capitalising on opportunities. Mr Luxon was accompanied by a business delegation and says the choice of countries represents the priority the New Zealand Government places on South East Asia, and our relationships in ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • $41m to support clean energy in South East Asia
    New Zealand is demonstrating its commitment to reducing global greenhouse emissions, and supporting clean energy transition in South East Asia, through a contribution of NZ$41 million (US$25 million) in climate finance to the Asian Development Bank (ADB)-led Energy Transition Mechanism (ETM). Prime Minister Christopher Luxon and Climate Change Minister Simon Watts announced ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Minister releases Fast-track stakeholder list
    The Government is today releasing a list of organisations who received letters about the Fast-track applications process, says RMA Reform Minister Chris Bishop. “Recently Ministers and agencies have received a series of OIA requests for a list of organisations to whom I wrote with information on applying to have a ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Judicial appointments announced
    Attorney-General Judith Collins today announced the appointment of Wellington Barrister David Jonathan Boldt as a Judge of the High Court, and the Honourable Justice Matthew Palmer as a Judge of the Court of Appeal. Justice Boldt graduated with an LLB from Victoria University of Wellington in 1990, and also holds ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Education Minister heads to major teaching summit in Singapore
    Education Minister Erica Stanford will lead the New Zealand delegation at the 2024 International Summit on the Teaching Profession (ISTP) held in Singapore. The delegation includes representatives from the Post Primary Teachers’ Association (PPTA) Te Wehengarua and the New Zealand Educational Institute (NZEI) Te Riu Roa.  The summit is co-hosted ...
    BeehiveBy beehive.govt.nz
    2 weeks ago
  • Value of stopbank project proven during cyclone
    A stopbank upgrade project in Tairawhiti partly funded by the Government has increased flood resilience for around 7000ha of residential and horticultural land so far, Regional Development Minister Shane Jones says. Mr Jones today attended a dawn service in Gisborne to mark the end of the first stage of the ...
    BeehiveBy beehive.govt.nz
    2 weeks ago

Page generated in The Standard by Wordpress at 2024-04-30T11:49:59+00:00