select opr.companyName, opr.oprType, opr.focusAccount, opr.address, opr.city, opr.state, opr.county, opr.zipcode, opr.phone, opr.areacode, opr.oprCompanyType, opr.oprparentCo, opr.directCustomer, opr.annualSales_TY, opr.annualSales_LY, opr.annualSales_lastUpdate, opr.faxNumber, opr.cuisineId, mbr.firstName, mbr.lastName, mbr.email, mbr.phone contactPhone, mbr.title, mbr.caJobFunction , cseg.clientsegid, cdr.cdr_recordId, cdr2.cdr_recordId cdr_recordId_2, cls.classificationId, mbr.fspro_userid, cm.fspro_userId customerManagerId, dd.accountNumber ddAccountNumber, dd.avgWeeklyPurchases ddAvgWeeklyPurchases, ( select count(*) from tbl_SPL_Opportunities spl inner join tbl_SPL_Stages s on s.stageId = spl.stageId where spl.partnerId = opr.operatorId and spl.partnerType = 'OPR' and spl.ownerId = opr.ownerId and spl.ownerType = opr.fsltablecode and s.statusCode in ('I','A')) opportunityCount from tbl_OPR_ClientOperators opr with (nolock) left outer join tbl_FSPro_members mbr with (nolock) on mbr.fspro_userid = opr.primaryContactId and mbr.ownerid = opr.ownerId and mbr.fsl_tablecode = opr.fslTablecode left outer join tbl_CDR_Distributors cdr with (nolock) on cdr.cdr_recordId = opr.distrib1 and cdr.ownerId = opr.ownerId and cdr.fsl_tablecode = opr.fsltablecode left outer join tbl_CDR_Distributors cdr2 with (nolock) on cdr2.cdr_recordId = opr.distrib2 and cdr2.ownerId = opr.ownerId and cdr2.fsl_tablecode = opr.fsltablecode left outer join tbl_OPR_DistributionDetails dd with (nolock) on dd.operatorId = opr.operatorId and dd.cdr_recordId = opr.distrib1 and dd.ownerId = opr.ownerId and dd.ownerType = opr.fsltablecode left outer join tbl_OPR_ClientSegments cseg with (nolock) on cseg.clientsegid = opr.oprsegment and cseg.ownerId = opr.ownerId and cseg.fsl_tablecode = opr.fsltablecode left outer join tbl_OPR_Classifications cls with (nolock) on cls.classificationId = opr.classificationId and cls.ownerId = opr.ownerId and cls.ownerType = opr.fsltablecode left outer join tbl_FSpro_members cm with (nolock) on cm.fspro_userid = opr.mfr_bsr_id and cm.ownerId > 0 where opr.ownerId = and opr.fsltablecode = and opr.operatorId = select f.name, f.fieldId, v.data from tbl_OPR_Fields f with (nolock) left outer join tbl_OPR_FieldValues v with (nolock) on v.fieldId = f.fieldId and v.partnerType = 'OPR' and v.partnerId = where f.ownerId = and f.ownerType = select opr.operatorId from tbl_OPR_ClientOperators opr with (nolock) /* inner join tbl_OPR_ClientChainDistribution ccd on ccd.chainOperatorId = opr.oprParentCo and ccd.ownerId = opr.ownerId and ccd.ownerType = opr.fsltablecode and ccd.territoryId = opr.territoryId */ left outer join tbl_CDR_Distributors cdr with (nolock) on cdr.cdr_recordId = opr.distrib1 on cdr.cdr_recordId = opr.distrib2 and cdr.ownerId = opr.ownerId and cdr.fsl_tablecode = opr.fsltablecode and cdr.crmActive = 'Y' where opr.ownerId = and opr.fsltablecode = and opr.oprCompanyType = '0' and opr.oprParentCo = and opr.crmActive = 'Y' and opr.directCustomer = 'N' and cdr.cdr_recordId is null ---> select spl.opportunityId from tbl_SPL_Opportunities spl with (nolock) inner join tbl_SPL_Stages stg with (nolock) on stg.stageId = spl.stageId and stg.statusCode in ( 'I', 'A' ) inner join tbl_SPL_OpportunitySubjectDetails osd with (nolock) on osd.opportunityId = spl.opportunityId and osd.subjectDetailType = 'SKU' and osd.subjectDetailId = where spl.ownerId = and spl.ownerType = and spl.partnerType = 'OPR' and spl.partnerId = and spl.subjectType = 'PRD' and spl.subjectId =