0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited dec 6 jack2020

created nov 28 aminography