SELECT CountAll, FirstName, LastName, JobTitle, SystemUserID, Username, ImagePath  FROM
        (
            SELECT ROW_NUMBER() OVER

                (
                ORDER BY
                --1 e za name i asc, 2ka e za popularity asc, 3 za name desc, 4 za popularity desc
                    (
                    CASE @OrderBy
                    WHEN 0 THEN su.FirstName
                    END
                    ) ASC --topic name asc
                    ,
                    (
                    CASE @OrderBy
                    WHEN 1 THEN su.FirstName
                    END
                    )
                    DESC -- topic name desc
                    -- TO DO : ADD LOGIC FOR POPULAR TOPICS

                )

                 AS RowNum,
                   COUNT(*) OVER ()  AS CountAll,
                   su.FirstName,
                   su.LastName,
                   c.[Description] AS JobTitle,
                   su.SystemUserID,
                   su.Username,
                   su.ImagePath
                FROM Media.MediaTopic mt
                INNER JOIN Media.Media m ON mt.MediaID = m.MediaID AND m.IsDeleted=0
                INNER JOIN Users.SystemUser su ON m.UserID=su.SystemUserID AND su.IsDeleted=0 AND su.SystemUserType=1
                LEFT JOIN Users.SystemUserCompany suc ON suc.UserID = su.SystemUserID
                LEFT JOIN Users.CentalCompany c ON c.CompanyID = suc.CompanyID
                WHERE mt.TopicId=@TopicId
        ) AS TBL WHERE TBL.RowNum BETWEEN
        ((@PageNumber - 1) * @NumRecords + 1) AND (@PageNumber * @NumRecords)