select distinct territoryId from qmd_brokerTerritories where teamMemberRole like 'MPR:%' and teamMemberUserId = select ter.territoryId from tbl_CRM_MarketingActivityTargets mat inner join tbl_TER_Territories ter on ter.territoryId = mat.territoryId and ter.ownerId = mat.ownerId and ter.fsl_tablecode = mat.ownerType where mat.ownerId = and mat.ownerType= and mat.marketingActivityId = select * from qmd_stats where cast(marketingActivityId as varchar) = select marketingactivitypartnertypes,sortOrder, campaignid,completedcount,crmactive,enddate,enrollmentcount,enrollmentenddate, enrollmentrulecode,enrollmentstartdate,enrollmentstate,fsl_oprid,lifecyclestate,lifecyclestatesortrank, marketingactivityid,marketingactivityname,marketingactivitytype,primarycontactuserid,publishdate,quotacount, sortrank,startdate,unpublishdate,userids,version, completedSurveyCount, sentSurveyCount, surveys from qmd_marketingActivities where enrollmentCount > 0quotaCount > 0 group by marketingactivitypartnertypes,sortOrder, campaignid,completedcount,crmactive,enddate,enrollmentcount,enrollmentenddate, enrollmentrulecode,enrollmentstartdate,enrollmentstate,fsl_oprid,lifecyclestate,lifecyclestatesortrank, marketingactivityid,marketingactivityname,marketingactivitytype,primarycontactuserid,publishdate,quotacount, sortrank,startdate,unpublishdate,userids,version, completedSurveyCount, sentSurveyCount, surveys order by sortOrder, sortRank