select distinct mfr.ownerId, mfr.fsltablecode as ownerType, mfr.operatorId, mfr.fsl_choId from tbl_OPR_CLientOperators cho inner join tbl_OPR_ClientOperators mfr on mfr.fsl_choid = cho.fsl_choId where cho.fsl_choId > 0 and cho.fsltablecode = 'CHO' and cho.crmActive = 'Y' and mfr.fsltablecode = 'MFR' AND cho.ownerId > 0 and mfr.ownerId = 1 order by mfr.operatorId