select zipcode, companyname from tbl_opr_clientoperators with (nolock) where operatorid = and ownerid = and fsltablecode = select cdr_dstzip as zipcode, cdr_dstname as companyname from tbl_cdr_distributors with (nolock) where cdr_recordid = and ownerid = and fsl_tablecode = select '' as marker, '#_markerColorDefault#' as markerColor, 0 as activeOpps, 'false' as buying, 'false' as target, * from qcf_accounts where partnerid <> or partnertype <> order by distance select count(*) buyingCount from tbl_OPR_ProductStatus ops with (nolock) where ops.operatorId = and ops.ownerId = and ops.ownerType = and ops.purchasingStatus = 'b' select count(*) as oppCount from tbl_SPL_Opportunities spl with (nolock) inner join tbl_SPL_Stages stg with (nolock) on stg.StageID = spl.StageID and stg.StatusCode = 'A' where spl.OwnerID = and spl.OwnerType = and spl.PartnerID = and spl.PartnerType = select count(*) as initiativeCount from tbl_CRM_Participants p with (nolock) inner join tbl_crm_marketingactivities ma with (nolock) on ma.ownerId = p.ownerId and ma.ownerType = p.ownerType and ma.marketingActivityId = p.marketingActivityId and getdate() >= ma.startdate and getdate() <= ma.enddate and crmactive = 'y' and ready = 'y' inner join tbl_crm_interactions int with (nolock) on int.participantid = p.participantid and int.ownerid = p.ownerid and int.ownertype = p.ownertype and int.disposition = '?' where p.ownerId = and p.ownerType = and p.partnerId = and p.partnerType = 'OPR'

#_end-_start# ms