select cho.cho_id as coopId, cho.cho_name as coopName from tbl_CHO_Operators cho with (nolock) inner join tbl_OPR_clientOperators opr with (nolock) on cho.cho_id = opr.fsl_choId inner join tbl_fsPro_members fspro on opr.mfr_bsr_id = fspro.fsPro_userId where opr.ownerId = and opr.fslTableCode = 'BRO' and opr.mfr_bsr_id > 0 and cho.cho_type = 'G' and cho.cho_segmentId = 56 and cho.cho_1fsSchoolsMember = 'Y' and fspro.ownerID = and fspro.fsl_tableCode = 'BRO' and fspro.email = order by cho.cho_name