Explore the archive

Archives: @author_full Bill · Page 9

Find articles and conversations by date, subject or search expression.

search syntax

Search syntax

Type words or a Sphinx search expression in the query box. The plugin uses this expression for full-text matching through SphinxQL.

Start with a few words, then narrow the search using these examples, inspired by recent posts on The Standard.

All words
unemployment statistics

Find both words, anywhere in the indexed text. A space means AND; unemployment & statistics also works.

A phrase
"data centres"

Find these words next to each other, in this order. Use straight double quotes, as shown.

Either word
Labour | National

Find either word. Use the vertical bar for OR.

Leave a word out
election -Trump

Find election while excluding Trump. election !Trump also works. Include a positive search word; -Trump on its own is not a valid search.

Group alternatives
(Labour | National) unemployment

Find unemployment together with either Labour or National. Parentheses make combinations easier to read.

Words near each other
"coalition government"~5

Find these words close together, in either order, allowing fewer than five intervening words.

In a title
@title "data centres"

Find the phrase in a post or page title. Comments have no indexed title; select Posts for articles only.

In the body
@body "tactical voting"

Find the phrase in the text of a post, page or comment.

By an author
@author lprent @body search

Find search in the body of items whose indexed author name contains lprent. Use the displayed author or commenter name, which may differ from a login name.

In a category
@category politics

Match words in indexed category names. Use the Categories checkboxes to select a specific category and its descendants.

In a tag
@tags election

Match words in indexed tag names. Use the Tags checkboxes to select a specific tag. Comments inherit their parent post’s categories and tags.

Combine fields
@title election @body (Labour | National)

Require election in the title and either Labour or National in the body. A field applies to following words until another field or the end of its parenthesized group. @* switches back to all fields.

Which fields work with @?

The current index supports @title, @body, @author, @author_full, @category and @tags. @author_full lprent searches the same author text as @author lprent; it uses the same word-matching rules.

The date columns published_utc, calendar_day and date_added are numeric attributes used for filtering, date counts or ordering. They cannot be searched with @: expressions such as @published_utc 2026 or @calendar_day 20261107 produce a query error. Use the From and To (inclusive) controls for dates.

Likewise, use Content for posts, pages or comments, and the Categories and Tags checkboxes for specific terms. Their numeric IDs and content-type attributes cannot be searched with @.

For example, enter @title election, select Posts, set From to 2026-01-01 and To (inclusive) to 2026-11-07, then press Search. This combines the title search with an inclusive date range in the site’s time zone.

Find recent posts

Select Posts only and Newest first. In Text Search or Archive Explorer, set From to one year ago and To (inclusive) to today, then press Search. The sidebar opens Text Search, where you can add these dates. For comments, the date range uses the comment’s own date.

Try @title election, @title "data centres" or unemployment statistics. Recent starting points:

If the results surprise you

Check Content and the date, category and tag filters. English word endings may match the same stem, so quotes fix word order rather than spelling. Wildcard searches such as elect* require index settings that the plugin’s default configuration does not enable.

Enter the expression itself in the box; choose dates and ordering with the controls. For example, use Labour | National for alternatives.

Background: Search upgraded (yet again).

Content
Date range
Browse dates

    Date counts load after the page opens. You can also enter a date range above.

    Categories

    Names open category archives. Check boxes to combine filters, including subcategories.

    Browse all category archives

    Tags

    Popular tags and your selections. Names open tag archives; check boxes to combine filters.

    Browse all tag archives

    Clear all

    Searching: posts Sorted by: relevance Results: 241–270 of 412

    Post

    Housing. Cut the Crap.

    · Bill

    I'm not the only one a bit tired of hearing about housing policy that's geared to satisfying buyers. And I'm not the only one who rents, who will never buy, and who wants legislation passed that would end forever the type of bullshit that's going on in Glen Innes. Here are three simple things that ...

    housing tenants' rights

    Post

    Power Up!

    · Bill

    Back in 2008, Andrew Simms and Dr Viki Johnston worked out that we had about 100 months before it was no longer 'likely' that global average surface temperature increases could be held below 2 degrees centigrade. That was 100 months ago. Over that time, Andrew Simms has been writing a 'Climate ...

    climate change global warming International political alternatives science

    Post

    Hacking Schmacking

    · Bill

    Warning: do not spark up any illegal substances for the imbibing thereof before reading the linked report lest you become stranded on the floor gasping for breathe in fits of uncontrollable and possibly life threatening laughter. US Intelligence Report (pdf) This report is a declassified version of ...

    International making shit up Media us politics useless

    Post

    If home is where the heart is, then…

    · Bill

    The social context is the same but the raw numbers for New Zealand are different - significantly higher and from a much lower population base than the England Jonathan Pie is referring to in the video below. As for homeless services in NZ...someone else is going to have to provide that info, because ...

    class war discrimination poverty

    Post

    Question…

    · Bill

    Yesterday I came across a report claiming that the Security Council was meeting in camera after NATO officers had been arrested in eastern Aleppo. I sought verification (as you do) by looking for other news sources reporting the same thing, but didn't find much of anything beyond scant reports ...

    aid International Syria war

    Post

    Oh noes! The world’s not going to saved now!

    · Bill

    A bit of agitation and fear has accompanied the assumption that Donald trump will pull the US out of the Paris agreement. Can we all be clear about something? The Paris agreement only spans 10 years and if all commitments are made good in full, then the world will heat up by about 3.5 – 4 degrees C. ...

    climate change energy

    Post

    Blogs and Activism

    · Bill

    For me, internet based activism is primarily about shifting people's thoughts and perceptions. Done well, people can find themselves asking new questions and entertaining new ideas. Done badly, people become entrenched and incurious. Good activism always presents a pathway or avenue to walk down, or ...

    activism blogs uncategorized

    Post

    When the levee breaks…

    · Bill

    During the week someone alerted me to Rod Oram being interviewed by Lynn Freedman on National Radio. One particular moment jumped out as Rod went silent and seemed to wrestle with what he was about to say. It immediately brought to mind a piece I read in The Guardian a few weeks ago, maybe a month ...

    climate change global warming Media science

    Post

    World Water Week

    · Bill

    So bang on cue, just when NZ has been hitting the front pages of international newspapers because of the water contamination in Havelock North; and just when the possibility of a national discussion around our abysmal levels of negligence and stupidity might be about to gather steam - along comes " ...

    disaster Environment farming health and safety International water

    Post

    It’s a Side-show, “Bob”.

    · Bill

    So here we are. Politicians, yet again playing ego driven, stupid and bizarre games of musical chairs. Economists, yet again doing splendid impersonations of headless chickens. And the stenographers (h/t CV), as always, breathlessly relaying to us how crucial, unprecedented and dangerous it all is… ...

    capitalism climate change Economy Environment Financial markets global warming International newspapers Politics radio Revolution science tv