Number of posts in Stack Overflow that are over the 30k soft character limit

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  p.Id AS [Post Link],
  (CASE WHEN p.PostTypeId = 1 THEN 'Q' ELSE 'A' END) AS Type,
  p.Id,
  LEN(p.Body) AS HtmlSize,
  LEN(ph.Text) AS MarkdownSize,
  p.CreationDate,
  -- p.LastEditDate,
  ph.CreationDate AS LatestRevisionDate
FROM Posts p
  INNER JOIN PostHistory ph
    ON ph.PostId = p.Id
  LEFT OUTER JOIN PostHistory phb
    ON phb.PostId = ph.PostId AND ph.CreationDate < phb.CreationDate
WHERE (LEN(p.Body) > 30000 OR LEN(ph.Text) > 30000)
  AND ph.PostHistoryTypeId IN (2, 5, 8)
  AND phb.CreationDate IS NULL
  AND p.PostTypeId IN (1, 2)
ORDER BY MarkdownSize DESC

Enter Parameters

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