Pathways Wellington office be closed on Monday, 24 January 2022 for Wellington Anniversary day.However, the Pathways Hamilton office will be operating as normal and our team would be happy to assist, as always!
Cape Reinga Lighthouse, north edge of New Zealand
SQL Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pathways_root.TABLE_PAGES_TABLES.RECORDID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL: SELECT TABLE_PAGES_TABLES.*, TABLE_NAV.RECORDID, TABLE_NAV.SORTNUM, 'TABLE_PAGES_TABLES' AS REFTABLE FROM TABLE_PAGES_TABLES INNER JOIN TABLE_NAV ON TABLE_PAGES_TABLES.PARENTID = TABLE_NAV.RECORDID WHERE TABLE_PAGES_TABLES.DESCRIPTION = 'edit4c158968d47e7' AND TABLE_PAGES_TABLES.USEFOR = 'main' GROUP BY TABLE_NAV.RECORDID ORDER BY TABLE_NAV.SORTNUM ASC