select ownerId, fsltablecode, operatorId, oprCompanyType, companyName from tbl_OPR_ClientOperators opr with (nolock) where opr.fsltablecode = 'CHO' and opr.comments2 like '%##subgroup%' and opr.comments2 like '%round2%' and opr.fsl_choId > 0 and exists ( select * from tbl_OPR_ClientOperators x with (nolock) where x.ownerId = and x.fsltablecode= and x.fsl_choId = opr.fsl_choId ) select opr.ownerId, opr.fsltablecode, opr.operatorId, opr.fsl_choId from tbl_OPR_ClientOperators opr with (nolock) where opr.ownerId = and opr.fsltablecode = and opr.oprParentCo = and opr.fsl_choId > 0 select opr.ownerId, opr.fsltablecode, opr.operatorId, opr.fsl_choId from tbl_OPR_ClientOperators opr with (nolock) inner join tbl_CRM_Affiliations a with (nolock) on a.partnerId = opr.operatorId and a.partnerType = 'OPR' and a.ownerId = opr.ownerId and a.ownerType = opr.fsltablecode where a.ownerId = and a.ownerType = and a.orgType = 'OPR' and a.orgId = and opr.fsl_choId > 0

#htmleditformat( companyName )# - #lsnumberformat( qmd_groupMembers.recordCount )#

Skipping #operatorId#