SELECT FSPro_UserID, FirstName, LastName, fsl_tablecode as fspro_ownerType FROM tbl_FSPro_Members m WITH (NOLOCK) WHERE m.OwnerID = AND m.FSL_TableCode = AND m.StaffMember = 1 AND m.FSPro_UserID IN ( SELECT PrimaryManager FROM tbl_TER_Territories WITH (NOLOCK) WHERE OwnerID = m.OwnerID AND FSL_TableCode = m.FSL_TableCode AND PrimaryManager > 0 ) ORDER BY LastName, FirstName FOR json path, include_null_values