Explore the archive

Search: @author_full "stargazer"

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: 1–12 of 12

    Post

    immigration profiling

    · stargazer

    The good news is that our Immigration Minister has put the "pilot data modelling programme" on hold, with assurances that race and nationality were never used.  I sincerely hope so, because there are huge issues if it does get used.  From Gordon Campbell: Apparently….age, gender, ethnicity and ...

    human rights immigration law racism

    Post

    free-to-air sports

    · stargazer

    I don't know about you, but I've really enjoyed the coverage of the Commonwealth Games this week.  With TVNZ providing coverage over 3 channels, there's an ability to watch a range of sports and to keep an eye on various things by switching between channels.  I had a quiet day today, so loved ...

    sport tv

    Post

    overpopulation myth

    · stargazer

    It's been a while since I've written a blog post, almost a three-year break.  But I'm finally in a position to start writing again, so let's see how this goes. I found this twitter thread by Hossam really resonating with me: "Overpopulation" is one of the most prominent thinly veiled racist (and ...

    capitalism Economy poverty racism twitter

    Post

    police and african youth

    · stargazer

    Having been away for the weekend, I hadn't had time to write about this piece of research by Camille Nakhid, showing that the police are using "derogatory insults or comments, dismissive behaviour and even excessive force by the police". The police immediately went into defensive mode, attacking the ...

    police racism uncategorized

    Post

    intersections

    · stargazer

    Before I start my actual post, I'll just say that I haven't posted here for maybe a year or so, for personal reasons.  I haven't posted on any blog during that time.  But I'm finally in a place and space where I can write again. In the last couple of days, I've been thinking.  Mostly about that ...

    identity Left Social issues

    Post

    investing in social cohesion

    · stargazer

    tonight i attended a holocaust memorial service in hamilton, hosted by the waikato jewish association.  it was nice to be invited and welcomed; even nicer to have several members of the jewish community thank me for coming and talk to me about my political activism in a positive manner.  they know ...

    uncategorized

    Post

    can we just ignore it?

    · stargazer

    well, happy new year everyone.  i've been absent from posting over the summer because i decided i just needed a break from the negativity that has been pouring out from many directions, targeting muslims or islam.  so i decided to just enjoy the break with my family and stay away, as much as i could ...

    Media religion

    Post

    inability to access food

    · stargazer

    this morning i was alerted, through a facebook discussion, about some people having difficulty accessing emergency benefits in the lead up to the holiday season.  the sort of issues being reported are: an inability to walk in to WINZ offices to apply for emergency grants.  they are requiring photo ...

    benefits poverty

    Post

    #TortureReport

    · stargazer

    finally had time to read up on the CIA report released in a summary version, with lots of redacted bits.  this post has a summary of the 5 most damning findings: torture didn't stop a single terrorist attack the CIA lied about the success of torture in obtaining evidence not everyone approved of the ...

    Abuse of power International us politics

    Post

    rising poverty amongst asians

    · stargazer

    this article in the herald was published a few days ago, and raises concerning trends amongst asian families: Pacific and Maori young still have by far the highest rates of poverty-related illness, but the Maori rate dropped steeply from 58 hospital admissions for poverty-linked conditions for every ...

    employment im/migration jobs poverty racism racism