vwEmailJobDonationStats

CREATE VIEW [dbo].[vwEmailJobDonationStats]
AS
    SELECT
        ej.[ID] As [EmailJobID],
        Count(dt.[DonationTransactionsID]) As [DonationTransactionsCount]
    FROM 
        [dbo].[EmailJob] ej
    INNER JOIN [dbo].[EmailJob_Recipient] ejr
        ON ej.[ID] = ejr.[EmailJobID]
    INNER JOIN [dbo].[DonationTransactions] dt
        ON ejr.[ID] = dt.[EmailJobRecipientID]
    where dt.isdeleted = 0
    and dt.[Status] = 1        
    GROUP BY ej.[ID]