spGetEmailProjectEventTransactions

CREATE PROCEDURE [dbo].[spGetEmailProjectEventTransactions]
( @EmailProjectID int,
@ProjectAppealID int,
@AppealListID int) AS
BEGIN

SELECT    et.[GiftPaymentMethod],
        count(et.EventTransactionsID) Registrations, sum(et.GiftAmount) GiftAmount
FROM EventTransactions et 
INNER JOIN Email e on et.EmailID = e.[ID]
INNER JOIN emailprojectappeal_ListEmail epale on e.ProjectAppealListEmailID = epale.[ID]
INNER JOIN EmailProjectAppeal_EmailList epael on epale.[EmailProjectAppealListID] = epael.[ID] 
INNER JOIN EmailProjectAppeal epa on epael.EmailProjectAppealID = epa.[ID] 
INNER JOIN EmailProject ep on epa.[EmailProjectID] = ep.[ID]
WHERE (ep.[ID] = @EmailProjectID OR @EmailProjectID = 0) AND (epa.[ID] = @ProjectAppealID OR @ProjectAppealID = 0) 
AND (epael.[ID] = @AppealListID OR @AppealListID = 0) AND epael.AppealListType = 1
and isdeleted = 0
and et.Status = 1
GROUP BY et.[GiftPaymentMethod]
END