Longest Answers by Markdown for Mark S.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

-- The longest answers in terms of Markdown

Select Top 100 
      p.Id AS [Post Link], 
      Len(ph.Text) as [Markdown Length],
      p.Score as [Score]
From Posts p, PostHistory ph
Where YEAR(p.CreationDate) >= 2011
      and p.PostTypeId = 2                     -- is an answer
      and ph.PostId = p.Id                 -- getting history for the right post
      and ph.PostHistoryTypeId in (2,5,8)  -- initial body, edit body, rollback body
      and not exists (                     -- no later revisions of the body
        Select * from PostHistory phtwo
        Where phtwo.PostId = p.Id
          and phtwo.PostHistoryTypeId in (2,5,8)
          and phtwo.CreationDate > ph.CreationDate
      )
      and p.OwnerUserId = 26369
Order By Len(ph.Text) Desc

Enter Parameters

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