spGetEmailProjectMembershipTransactions

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

SELECT    et.[GiftPaymentMethod],
        count(et.ID) Memberships, sum(et.GiftAmount) GiftAmount
FROM MembershipTransactions 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