CREATE PROCEDURE dbo.[Forum_Group_Get] @GroupID INT
AS
    SELECT  [GroupID],
            [Name],
            [PortalID],
            [ModuleID],
            [SortOrder],
            [CreatedDate],
            [UpdatedDate],
            [CreatedByUser],
            [UpdatedByUser],
            ISNULL(( SELECT COUNT(DISTINCT [ForumID])
                     FROM   dbo.Forum_Forums
                     WHERE  GroupID = @GroupID
                   ), 0) AS ForumCount,
            ISNULL(( SELECT COUNT(DISTINCT [ForumID])
                     FROM   dbo.Forum_Forums
                     WHERE  GroupID = @GroupID
                            AND IsActive = 1
                   ), 0) AS ActiveForumCount
    FROM    dbo.Forum_Groups
    WHERE   [GroupID] = @GroupID

GO