| SQL |
SELECT cp.campaignId, cp.name as campaignName, cp.emailSubject, cp.runDate
, '' as sendDate, '' as weekday, count(*) as totalRecipients, 0 as totalRecipientClicks, 0 as totalClicks, 0 as clickRate, 0 as openRate, 0 as uniqueClicks, 0 as totalUnsubscribers
FROM tbl_EML_Campaign cp
JOIN tbl_EML_CampaignRecipients cr
ON cr.campaignId = cp.campaignId
WHERE cp.statusCd = 'SUC'
AND cp.ownerId = 201
AND cp.FSL_TableCode = 'MFR'
AND cp.rundate >= '2017-01-01 00:00:00.000' AND cp.rundate <= '2017-12-31 00:00:00.000'
AND cp.campaignId in ( 16584 )
GROUP BY cp.campaignId, cp.name, cp.EmailSubject, cr.campaignID, cp.runDate
ORDER BY cp.campaignId |