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,
				   *
				   FROM (
				   SELECT DISTINCT
				   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
		) AS TBL WHERE TBL.RowNum BETWEEN
		((@PageNumber - 1) * @NumRecords + 1) AND (@PageNumber * @NumRecords)