sqlQuery: SELECT PositionReference, PositionTitle, LocationName, ShortDescription, ClosingDate, ContactName, ContactTelephone, ContactEmail, EmploymentType, CountryCode FROM vacancies WHERE ClosingDate >= '2009-1-9' AND Open = 'true' AND InternalOnly = 'false' AND CountryCode = 'nz' ORDER BY ClosingDate ASC