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


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

  p.Id AS [Post Link],
  (CASE WHEN p.PostTypeId = 1 THEN 'Q' ELSE 'A' END) AS Type,
  LEN(p.Body) AS HtmlSize,
  LEN(ph.Text) AS MarkdownSize,
  -- 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

Switch to meta site
loading Hold tight while we fetch your results