--DECLARE @total INT 
SELECT  @total = COUNT(*)
FROM    ( SELECT    ROW_NUMBER() OVER ( PARTITION BY BigInfoID ORDER BY b.DTEHFTime DESC ) RowIDD ,
                    c.* ,
                    ISNULL(b.IntRatingID, 0) IntRatingID ,
                    b.VarHFContent ,
                    b.DTEHFTime ,
                    b.VarRatingName ,
                    d.VarUserName
          FROM      ( SELECT    c.BigInfoID ,
                                c.DteCreateDate ,
                                c.VarEnterpriseName ,
                                c.VarAddress ,
                                c.VarSpeName ,
                                c.IntIsVip ,
                                c.VarIndustryIDs ,
                                c.VarPlaceIDs ,
                                c.DteVipExpire
                      FROM      Base_Enterprise AS c
                      WHERE     IntFlag = 1
                                AND BigInfoID IN (
                                SELECT DISTINCT
                                        ( BigClientAUID )
                                FROM    Fao_PublicPool
                                WHERE   IntFlag = 1
                                        AND IntDepartment IN (
                                        SELECT  IntID
                                        FROM    f_GetDepartByID(1) ) )
                    ) AS c
                    LEFT JOIN Fao_UserHF b ON c.BigInfoID = b.BigClientAUID
                                              AND b.IntLast = 1
                                              AND b.IntDepartment != 0
                    LEFT JOIN Fao_MyClient d ON c.BigInfoID = d.BigClientAUID
                                                AND d.IntFlag = 1
          WHERE     1 = 1
        ) m
WHERE   m.RowIDD = 1
        AND m.IntRatingID NOT IN ( 6, 7 )

SELECT TOP ( 10 )
        *
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY BigInfoID ) RowID ,
                    *
          FROM      ( SELECT    ROW_NUMBER() OVER ( PARTITION BY BigInfoID ORDER BY b.DTEHFTime DESC ) RowIDD ,
                                c.* ,
                                ISNULL(b.IntRatingID, 0) IntRatingID ,
                                b.VarHFContent ,
                                b.DTEHFTime ,
                                b.VarRatingName ,
                                d.VarUserName
                      FROM      ( SELECT    c.BigInfoID ,
                                            c.DteCreateDate ,
                                            c.VarEnterpriseName ,
                                            c.VarAddress ,
                                            c.VarSpeName ,
                                            c.IntIsVip ,
                                            c.VarIndustryIDs ,
                                            c.VarPlaceIDs ,
                                            c.DteVipExpire
                                  FROM      Base_Enterprise AS c
                                  WHERE     IntFlag = 1
                                            AND BigInfoID IN (
                                            SELECT DISTINCT
                                                    ( BigClientAUID )
                                            FROM    Fao_PublicPool
                                            WHERE   IntFlag = 1
                                                    AND IntDepartment IN (
                                                    SELECT  IntID
                                                    FROM    f_GetDepartByID(1) ) )
                                ) AS c
                                LEFT JOIN Fao_UserHF b ON c.BigInfoID = b.BigClientAUID
                                                          AND b.IntLast = 1
                                                          AND b.IntDepartment != 0
                                LEFT JOIN Fao_MyClient d ON c.BigInfoID = d.BigClientAUID
                                                            AND d.IntFlag = 1
                      WHERE     1 = 1
                    ) m
          WHERE     m.RowIDD = 1
                    AND m.IntRatingID NOT IN ( 6, 7 )
        ) m
WHERE   m.RowID > ( 1 - 1 ) * 10;