select cho_name from tbl_CHO_Operators where cho_id = select m.mfr_id, m.mfr_name, f.formatId, f.formatName, count( distinct b.batchId ) batches, min( b.batchTime ) firstBatch, max( b.batchTime ) lastBatch from tbl_OPR_ClientOperators opr inner join tblManufacturers m on m.mfr_id = opr.ownerId inner join tbl_EAI_InboundFileFormats f on f.ownerId = opr.ownerId and f.ownerType = opr.fsltablecode and f.formatName like 'TPM[_]PROOF[_]OF[_]DELIVERY[_]OPR' + convert( varchar, opr.operatorId ) + '[_]%' left outer join tbl_EAI_inboundBatches b on b.ownerId = f.ownerId and b.ownerType = f.ownerType and b.fileFormat = f.formatName where opr.fsl_choId = and opr.fsltablecode = 'MFR' and opr.ownerId > 0 group by m.mfr_id, m.mfr_name, f.formatId, f.formatName order by m.mfr_name, batches desc, lastBatch desc #_formatStatisticsHTML#