vwEmailJobProfileUpdateStats

CREATE VIEW [dbo].[vwEmailJobProfileUpdateStats]
AS
    SELECT
        ej.[ID] As [EmailJobID],
        Count(pt.[ProfileUpdateTransactionsID]) As [ProfileUpdateTransactionsCount]
    FROM 
        [dbo].[EmailJob] ej
    INNER JOIN [dbo].[EmailJob_Recipient] ejr
        ON ej.[ID] = ejr.[EmailJobID]
    INNER JOIN [dbo].[ProfileUpdateTransactions] pt
        ON ejr.[ID] = pt.[EmailJobRecipientID]
    where pt.isdeleted = 0
    GROUP BY ej.[ID]