public ActionResult ActTop(string forum, int? days, int? start)
{
    var model = new ActTopModel
    {
        Days         = days,
        CurrentForum = forum,
        Start        = start.GetValueOrDefault(0),
        PageSize     = _pageSize
    };

    using (var db = new RsdnDB())
    {
        int? forumID = null;

        if (!string.IsNullOrEmpty(forum))
        {
            forumID = db.Forums
                .Where(f => f.ShortName == forum.ToLower())
                .Select(f => (int?) f.ID)
                .FirstOrDefault();

            if (forumID == null)
                return ErrorMessageBoxFormat("Форум '{0}' не найден", (object)forum);
        }

        // Версии запроса для двух параметров: days и forumID.
        // Всего 4 варианта.
        //
        var q1 = days == null || days == 0
            ? forumID == null
                ? db.Accounts.Select(a => new
                {
                    a,
                    Count = a.Messages.Count(m => m.Forum.ReadLevel == AccessLevel.Anonymous)
                })
                : db.Accounts.Select(a => new
                {
                    a,
                    Count = a.Messages.Count(m => m.ForumID == forumID && m.Forum.ReadLevel == AccessLevel.Anonymous)
                })
            : forumID == null
                ? db.Accounts.Select(a => new
                {
                    a,
                    Count = a.Messages.Count(m =>
                        m.CreatedOn >= Sql.CurrentTimestamp.AddDays(-days.Value) &&
                        m.Forum.ReadLevel == AccessLevel.Anonymous)
                })
                : db.Accounts.Select(a => new
                {
                    a,
                    Count = a.Messages.Count(m =>
                        m.ForumID == forumID &&
                        m.CreatedOn >= Sql.CurrentTimestamp.AddDays(-days.Value) &&
                        m.Forum.ReadLevel == AccessLevel.Anonymous)});

        // Тело запроса.
        //
        var q2 =
            from t in q1
            where t.a.ID > 0 && t.Count > 0
            orderby t.Count descending , t.a.ID
            select
                new ActTopModel.AccountData
                {
                    ID = t.a.ID,
                    DisplayName = t.a.GetDisplayName(),
                    Title = t.a.Title,
                    TitleColor = t.a.TitleColor ?? 0,
                    UserRole =
                        t.a.ForumModerators.Any() && t.a.AccessLevel == AccessLevel.TeamMember && forumID != null
                            ? UserRole.Moderator
                            : t.a.ForumExperts.Any() && t.a.AccessLevel == AccessLevel.User
                                ? UserRole.Expert
                                : (UserRole) t.a.AccessLevel,
                    Count = t.Count
                };

        // Выполняем первый запрос для получения подверженных запросу количества записей.
        //
        model.Total = q2.Count();

        // Организация пейджинга.
        //
        if (start != null)
            q2 = q2.Skip(start.Value);

        // Запрашиваем данные.
        //
        model.AccountDatas = q2.Take(_pageSize).ToArray();

        model.CurrentForum = forum;
    }

    return View(model);
}

-- DECLARE @forumID Int32
-- DECLARE @p1 Double

-- SET @forumID = 8
-- SET @p1 = -31

SELECT
    Count(*) as [cnt]
FROM
    (
        SELECT
            [a].[userid] as [ID],
            (
                SELECT
                    Count(*)
                FROM
                    [forum_tree] [c]
                        INNER JOIN [forum_groups] [t1] ON [c].[gid] = [t1].[gid]
                WHERE
                    [a].[userid] = [c].[uid] AND
                    [c].[gid] = @forumID AND
                    [c].[dte] >= DateAdd(Day, @p1, CURRENT_TIMESTAMP) AND
                    [t1].[ucread] = 4
            ) as [c1]
        FROM
            [users] [a]
    ) [t]
WHERE
    [t].[ID] > 0 AND [t].[c1] > 0

-- DECLARE @forumID Int32
-- DECLARE @p1 Double

-- SET @forumID = 8
-- SET @p1 = -31

SELECT TOP (100)
    [t].[ID] as [ID1],
    [t].[LoginName] as [LoginName1],
    [t].[UserNick] as [UserNick1],
    [t].[RealName] as [RealName1],
    [t].[Title] as [Title1],
    Coalesce([t].[TitleColor], 0) as [c1],
    CASE WHEN EXISTS(
        SELECT
            *
        FROM
            [forum_moderators] [c]
        WHERE
            [t].[ID] = [c].[uid]
    ) THEN 1 ELSE 0 END as [c2],
    [t].[AccessLevel] as [AccessLevel1],
    CASE WHEN EXISTS(
        SELECT
            *
        FROM
            [forum_experts] [c3]
        WHERE
            [t].[ID] = [c3].[uid]
    ) THEN 1 ELSE 0 END as [c4],
    [t].[c6] as [c61]
FROM
    (
        SELECT
            [a].[userid] as [ID],
            (
                SELECT
                    Count(*)
                FROM
                    [forum_tree] [c5]
                        INNER JOIN [forum_groups] [t1] ON [c5].[gid] = [t1].[gid]
                WHERE
                    [a].[userid] = [c5].[uid] AND
                    [c5].[gid] = @forumID AND
                    [c5].[dte] >= DateAdd(Day, @p1, CURRENT_TIMESTAMP) AND
                    [t1].[ucread] = 4
            ) as [c6],
            [a].[username] as [LoginName],
            [a].[usernick] as [UserNick],
            [a].[realname] as [RealName],
            [a].[Title],
            [a].[TitleColor],
            [a].[userclass] as [AccessLevel]
        FROM
            [users] [a]
    ) [t]
WHERE
    [t].[ID] > 0 AND [t].[c6] > 0
ORDER BY
    [t].[c6] DESC,
    [t].[ID]

-- DECLARE @forumID Int32
-- DECLARE @p1 Double

-- SET @forumID = 8
-- SET @p1 = -31

SELECT *
FROM
(
    SELECT
        t2.*,
        ROW_NUMBER() OVER
        (
            ORDER BY
                oby DESC,
                oby1
        ) as rn
    FROM
    (
        SELECT
            [t].[ID] as [ID1],
            [t].[LoginName] as [LoginName1],
            [t].[UserNick] as [UserNick1],
            [t].[RealName] as [RealName1],
            [t].[Title] as [Title1],
            Coalesce([t].[TitleColor], 0) as [c1],
            CASE WHEN EXISTS(
                SELECT
                    *
                FROM
                    [forum_moderators] [c]
                WHERE
                    [t].[ID] = [c].[uid]
            ) THEN 1 ELSE 0 END as [c2],
            [t].[AccessLevel] as [AccessLevel1],
            CASE WHEN EXISTS(
                SELECT
                    *
                FROM
                    [forum_experts] [c3]
                WHERE
                    [t].[ID] = [c3].[uid]
            ) THEN 1 ELSE 0 END as [c4],
            [t].[c6] as [c61],
            [t].[c6] as [oby],
            [t].[ID] as [oby1]
        FROM
            (
                SELECT
                    [a].[userid] as [ID],
                    (
                        SELECT
                            Count(*)
                        FROM
                            [forum_tree] [c5]
                                INNER JOIN [forum_groups] [t1] ON [c5].[gid] = [t1].[gid]
                        WHERE
                            [a].[userid] = [c5].[uid] AND
                            [c5].[gid] = @forumID AND
                            [c5].[dte] >= DateAdd(Day, @p1, CURRENT_TIMESTAMP) AND
                            [t1].[ucread] = 4
                    ) as [c6],
                    [a].[username] as [LoginName],
                    [a].[usernick] as [UserNick],
                    [a].[realname] as [RealName],
                    [a].[Title],
                    [a].[TitleColor],
                    [a].[userclass] as [AccessLevel]
                FROM
                    [users] [a]
            ) [t]
        WHERE
            [t].[ID] > 0 AND [t].[c6] > 0
    ) t2
) t3
WHERE
    t3.rn BETWEEN 77 AND 176