select mem.fspro_userId, mem.firstName + ' ' + mem.lastName as fullName from tbl_SCRUM_FieldLookups fl with (nolock) inner join tbl_FSPRO_Members mem with (nolock) on mem.fspro_userId = fl.selectionValue where fl.ownerId = 78 and fl.ownerType = 'MSC' and fl.fieldName = 'REQ_ASSIGNEDTO' and fl.selectionValue not in ( 156659, 2842747, 3363705, 3512263, 3858604, 4152676, 451734, 462282 ) order by mem.lastName for json auto, include_null_values