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

0

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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(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 to main site
loading Hold tight while we fetch your results