Top 100 posts by length

1

Please login or register to vote for this query.

(click on this box to dismiss)

Tezos

Q&A for users, experts, and developers of the Tezos blockchain project

SELECT TOP 100
  pt.Name As PostType,
  LEN(p.Body) AS Length,
  u.DisplayName AS UserName,
  ('site://q/' + CONVERT(NVARCHAR, p.Id) + '|' + q.Title) AS Title
FROM Posts p
INNER JOIN Users u ON p.OwnerUserId = u.Id
INNER JOIN PostTypes pt on p.PostTypeId = pt.Id
INNER JOIN Posts q ON p.ParentId = q.Id OR p.parentId IS NULL AND p.ID = q.Id
ORDER BY Length DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results