Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems
Select p.Id AS [Post 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 = 2 -- initial body and year(p.CreationDate) < 2014 and (replace(replace(replace(replace(ph.text,'\\','Y'),'X','Y'), char(9),'XXXX'),' ','X') like '%\XXXX%') Order By p.CreationDate Desc