CREATE PROCEDURE dbo.[Forum_Subscriptions_PostDeleted]
    @PostID INT,
    @EmailQueueID INT
AS
    DECLARE @ForumID INT,
        @GroupID INT,
        @PortalID INT,
        @ThreadID INT,
        @UserID INT
    SET @ThreadID = ( SELECT    ThreadID
                      FROM      dbo.Forum_Posts
                      WHERE     PostID = @PostID
                    )
    SET @ForumID = ( SELECT ForumID
                     FROM   dbo.Forum_Threads
                     WHERE  ThreadID = @ThreadID
                   )
    SET @GroupID = ( SELECT GroupID
                     FROM   dbo.Forum_Forums
                     WHERE  ForumID = @ForumID
                   )
    SET @PortalID = ( SELECT    PortalID
                      FROM      dbo.Forum_Groups
                      WHERE     GroupID = @GroupID
                    )
    SET @UserID = ( SELECT  UserID
                    FROM    dbo.Forum_Posts
                    WHERE   PostID = @PostID
                  )
    IF @EmailQueueID > 0
        BEGIN
            INSERT  INTO dbo.[Forum_EmailQueue_TaskEmails]
                    (
                      EmailAddress,
                      EmailQueueID,
                      IsHTML,
                      DisplayName,
                      DateAdded
                    )
                    ( SELECT DISTINCT
                                ( Email ),
                                @EmailQueueID,
                                EmailFormat,
                                DisplayName,
                                GETDATE()
                      FROM      dbo.vw_Users U
                                INNER JOIN dbo.Forum_Users FU ON U.UserID = FU.UserID
                      WHERE     FU.UserID = @UserID
                                AND FU.PortalID = @PortalID
                                AND IsDeleted = 0
                                AND Authorised = 1
                    )
        END
    ELSE
        BEGIN
            ( SELECT DISTINCT
                        ( Email ),
                        EmailFormat,
                        DisplayName
              FROM      dbo.vw_Users U
                        INNER JOIN dbo.Forum_Users FU ON U.UserID = FU.UserID
              WHERE     FU.UserID = @UserID
                        AND FU.PortalID = @PortalID
                        AND IsDeleted = 0
                        AND Authorised = 1
            )
        END

GO