select top #url.top# opr.ownerId, opr.fsltablecode, opr.fsl_choid, opr.operatorId from tbl_OPR_ClientOperators opr where opr.fsl_choId > 0 and opr.fsl_choIdDate is not null and opr.fsltablecode = and opr.ownerId = and not exists ( select * from tbl_SYS_Events e with (nolock) where e.ownerId = 66 and e.ownerType = 'MSC' and e.eventSubjectId = opr.fsl_choId and e.eventSubjectType = 'CHO' and e.eventName = 'operatorLinked' ) order by opr.fsl_choIdDate