vBulletin-CommunityServer-Posts-Migration.sql

WITH PostList AS (
	SELECT row_number() OVER (ORDER BY p.PostID DESC) Row,
	       p.PostID, p.ThreadID, p.ParentID, p.SortOrder, 
               p.PostDate, p.Subject, p.SectionID ForumID, p.PostAuthor UserName, 
               p.UserID UserID, p.IPAddress, t.ThreadDate, cast(p.[Body] as text) Body
	FROM cs_Posts p
	INNER JOIN cs_Threads t ON t.ThreadID = p.ThreadID
	INNER JOIN cs_Sections s ON s.SectionID = p.SectionID
	WHERE s.ApplicationType = 0 
)
SELECT * 
FROM PostList
WHERE Row BETWEEN 0 AND 300
ORDER BY PostID