spGetEmailProjectDonationTransactions

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

SELECT    et.[GiftPaymentMethod],
        count(et.DonationTransactionsID) Donations, sum(et.GiftAmount) GiftAmount
FROM DonationTransactions 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 et.isdeleted = 0
and et.Status = 1
GROUP BY et.[GiftPaymentMethod]
END