from tbl_fspro_members fsp with (nolock) where fsp.ownerid = and fsp.fsl_tablecode = and fsp.orgid = and fsp.orgtype = and ( fsp.staffmember = 1 or (fsp.staffmember = 0 and ( (fsp.orgtype = 'opr' and fsp.orgid in ( )) or (fsp.orgtype in ('cdr','cdrd','dst')) (fsp.orgtype in ('cdr','cdrd','dst') and fsp.orgid in ( )) ) ) fsp.staffmember = 1 fsp.staffmember = 1 or (fsp.staffmember = 0 and ( (fsp.orgtype = 'opr' and fsp.orgid in ( )) or (fsp.orgtype in ('cdr','cdrd','dst')) ) ) fsp.staffmember = 1 ) and email <> '' and ( ( fsp.email like or fsp.firstname like or fsp.lastname like ) and 1 = 1 ) and exists ( select * from tbl_ter_teammembers where teamMemberUserId = fsp.fspro_userid and territoryId = )