Extended re-tagging campaigns

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
  PostHistory.CreationDate,
  ROw_NUMBER() OVER (ORDER BY PostHistory.CreationDate) AS Number
FROM PostHistory
WHERE PostHistory.PostHistoryTypeId = 6 -- Edit Tags
  AND PostHistory.UserId=##UserId##
  AND PostHistory.Text LIKE '%'+##tag##+'%'
  AND (PostHistory.CreationDate <= ##DummyDate:string? ## OR PostHistory.CreationDate > ##DummyDate##)
ORDER BY PostHistory.CreationDate

Enter Parameters

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