0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for researchers, developers, and users of Tor

-- Posts where the length of the body is less than 50 characters
SELECT p.Id AS [Post Link], u.DisplayName, Len(p.Body) AS [Body Length], p.Score, p.ViewCount, p.Tags
FROM Posts p
join
Users u on u.Id = p.OwnerUserId
WHERE Len(p.Body) < 50
AND p.PostTypeId = 1
ORDER BY Len(p.Body) DESC

fork query

edited mar 6 Ian Kemp

created mar 6 CrSb0001