SELECT DISTINCT ter.territoryId, ter.internalSalesId, ter.name FROM tbl_TER_Territories ter WHERE ter.ownerId = AND ter.fsl_tablecode = ORDER BY name FOR json path, include_null_values