IF EXISTS (SELECT name
FROM sysobjects
WHERE name = 'cln_SelLastTopic' AND type = 'P')
DROP PROCEDURE [dbo].[cln_SelLastTopic]
GO

CREATE PROCEDURE [dbo].[cln_SelLastTopic]
@Count int = 10
WITH ENCRYPTION
AS
BEGIN
    SELECT * FROM (SELECT ROW_NUMBER() OVER (
    ORDER BY [t].[TopicID] DESC) AS Num,
        [t].[TopicID] AS 'TopicID',
        [t].[Topic] AS 'Topic',
        [m].[Message] AS 'Message'
    FROM [yaf_Topic] t, [yaf_Message] m
    WHERE [t].[ForumID] <> 1
        AND [t].[TopicID] = [m].[TopicID]
        AND [m].[Indent] = 0
        AND [t].[IsDeleted] = 0 ) t
    WHERE num BETWEEN 1 AND @Count
END
GO