SELECT opr.operatorId, opr.companyName , popr.operatorId parentOperatorId, popr.companyName parentCompanyName , gpopr.operatorId grandParentOperatorId, gpopr.companyName grandParentCompanyName , cho.cho_logoid, images.ContentPath logoImageURL FROM tbl_OPR_ClientOperators opr LEFT OUTER JOIN tbl_OPR_ClientSegments seg ON seg.clientsegid = opr.oprsegment AND seg.ownerid = opr.ownerid AND seg.fsl_tablecode = opr.fsltablecode LEFT OUTER JOIN tbl_CHO_Operators cho ON cho.cho_id = opr.fsl_choid LEFT OUTER JOIN qrycontentFullPathLookup images ON images.contentid = cho.cho_logoid LEFT OUTER JOIN tbl_OPR_ClientOperators popr ON popr.operatorid = opr.oprparentco AND popr.ownerid = opr.ownerId AND popr.fsltablecode = opr.fsltablecode LEFT OUTER JOIN tbl_OPR_ClientOperators gpopr ON gpopr.operatorid = popr.oprparentco AND gpopr.ownerid = popr.ownerId AND gpopr.fsltablecode = popr.fsltablecode WHERE opr.ownerId = AND opr.fsltablecode = AND opr.territoryId in () AND opr.reqBusinessPlan = ORDER BY #attributes.orderBy#