Explore the archive

Search · 2017-01-01 to 2017-12-31 · Page 43

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
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: newest Results: 1,261–1,290 of 2,173

Post

Tertiary education: keep it public

· notices and features

Two public meetings are being held next week to shine a light on the government’s Education (Tertiary Education and Other Matters) Amendment Bill. It would allow the Minister for Tertiary Education – currently Epsom’s Paul Goldsmith – to take public funds away from universities, polytechs…

privatisation

Post

$2.3b Health funding shortfall

· Anthony R0bins

Labour's health spokesperson David Clark is doing good work: Fiery exchanges over mental health as Minister fronts to Parliament's health committee ... Coleman's appearance came at the same time the Labour Party released its own updated figures, claiming $2.3 billion had been effectively stripped from…

health labour national

Post

Open Mike 09/06/2017

· notices and features

Open mike is your post. For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy). Step up to the mike …

open mike

Post

Daily Review 08/06/2017

· notices and features

Daily review is also your post. This provides Standardistas the opportunity to review events of the day. The usual rules of good behaviour apply (see the Policy). Don’t forget to be kind to each other …

Daily review

Post

Slum rentals in the brighter future

· Anthony R0bins

I've only just caught up with this depressing piece by Amanda Saxton in the SST: 18-month-old Julia, the innocent face of modern NZ's brutal, archaic boarding houses Eighteen-month-old Julia Alatina is smiley, snotty-nosed, and dotted with flea bites. She's trusting; exchanging her toy broom, made…

class war housing national

Post

Pre-UK election discussion

· notices and features

A general discussion thread for the lead up to the UK General election. This post will be bumped up daily, and a new one will go up Friday morning for the day of the election itself. To get us started, here's Jonathan Pie in fine…

democratic participation Politics uk politics

Post

Open Mike 08/06/2017

· notices and features

Open mike is your post. For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy). Step up to the mike …

open mike

Post

Daily Review 07/06/2017

· notices and features

Daily review is also your post. This provides Standardistas the opportunity to review events of the day. The usual rules of good behaviour apply (see the Policy). Don’t forget to be kind to each other …

Daily review

Post

Kiwis send a message to Tillerson

· Anthony R0bins

Predictably, the Nats don't dare to speak any sanity to the visiting representative of the Trump regime. Patrick Gower: English tries to hide from the reality of Trump's America ... Mr English said "I don't think it is our position to comment on the way…

activism climate change us politics

Post

Trying to wedge the Greens

· Anthony R0bins

The political right try it on every election year, in an attempt to sow a bit of discord. But it's all just a bit too obvious and clumsy really. Alex Braae explains: Greens would be fools to court National Around this point of the electoral…

election 2017 greens labour

Post

Open Mike 07/06/2017

· notices and features

Open mike is your post. For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy). Step up to the mike …

open mike

Post

Daily Review 06/06/2017

· mickysavage

Daily review is also your post. This provides Standardistas the opportunity to review events of the day. The usual rules of good behaviour apply (see the Policy). Don’t forget to be kind to each other …

Daily review

Post

Offline this morning for a short time

· lprent

The server will be shifted when its network link gets shunted to a new location. That will happen sometime this morning.Wednesday (I hope - see comments). So the site will be offline when it does. I have to physically pick up the server and reconnect at the new…

admin notices The Standard

Post

The 50th anniversary of the Six Day War

· advantage

June 5th is the 50th anniversary of the Six Day War. Following Egypt’s military closure of the Straits of Tiran, the armed forces of Egypt, Jordan, Syria, and Lebanon were defeated by Israel, pretty comprehensively. Israel then occupied the West Bank, the Gaza Strip, the…

International war

Post

Open Mike 06/06/2017

· notices and features

Open mike is your post. For announcements, general discussion, whatever you choose. The usual rules of good behaviour apply (see the Policy). Step up to the mike …

open mike

Post

UK election goes down to the wire

· mickysavage

Who would have thought even two weeks ago that Labour had a chance of winning the UK election. It was meant to be a foregone election.  Theresa May's Conservatives were meant to crush all before them, achieve an increased majority and then proceed to dismantle the last…

Donald Trump International iraq uk politics war

Post

Arise Sir John

· mickysavage

For creating a New Zealand where there are over 250,000 kids living in poverty ... For refusing to get the bodies out of the Pike River mine and thereby helping individuals avoid justice ... For Dirty Politics ... For the increasing numbers of homeless sleeping rough…

john key useless