Questions where the given word was removed from the title (including the editor)


Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

;  with revisions_cte as
DISTINCT p.Id AS pid, ph1.Id AS phId
FROM PostHistory ph1 INNER JOIN Posts p ON ph1.PostId=p.Id
WHERE ph1.PostHistoryTypeId in (1,4,7)
  and ph1.Text Like '%##word##%'
  and NOT(p.Title Like '%##word##%')
), firstrev_cte AS
pid, MIN(ph2.Id) as MinId
  FROM revisions_cte INNER JOIN PostHistory ph2 ON ph2.PostId=pid
  WHERE (ph2.Id>phId)
   AND ph2.PostHistoryTypeId in (1,4,7)
   AND NOT(ph2.Text Like '%##word##%')
--- 1 = Initial Title - initial title (questions only)
--- 4 = Edit Title - modified title (questions only)
--- 7 = Rollback Title - reverted title (questions only)

SELECT PostId AS [Post Link],
  revisions = 'site://posts/' + CAST(PostId AS varchar)+'/revisions',
  UserId AS [User Link], UserDisplayName, CreationDate, Comment
FROM PostHistory INNER JOIN firstrev_cte ON PostHistory.Id=MinId
ORDER BY CreationDate DESC

Enter Parameters

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