\\ bug query on markdown

0

Please login or register to vote for this query.

(click on this box to dismiss)

with bits stolen from http://data.stackexchange.com/stackoverflow/query/494264/longest-answers-by-markdown

TeX - LaTeX

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

Select 
      p.Id AS [Post Link], 
          'site://posts/' + CAST(p.Id AS nvarchar) + '/edit|' + 
  'Edit'  AS [Edit Link],
      p.OwnerUserId as [User Link],
      p.CreationDate
From Posts p, PostHistory ph
Where 
       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 year(p.CreationDate) < 2014 
      and  (replace(replace(ph.Text,'\\',''), ' ','X')  like '%\XXXX%') 
Order By p.CreationDate Desc

Enter Parameters

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