Q&A for administrators, end users, developers and designers for Craft CMS
-- Created by aminography [https://stackoverflow.com/users/1631967/aminography] SELECT TOP 1000 ROW_NUMBER() OVER(ORDER BY Posts.CreationDate DESC) AS [#], Posts.Id AS [Post Link], Posts.Body, LEN(Posts.Body) [Post Length], Posts.Score FROM Posts WHERE PostTypeId=2 AND LEN(Posts.Body)<30 AND Posts.Score>5 ORDER BY Posts.CreationDate DESC;