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