Edits that removed the mathematical-physics tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT 
  edits.PostId AS [Post Link],
  edits.CreationDate,
  --edits.Comment,
  edits.Text AS 'Edited tags',
  originalTags.Text AS 'Original tags'
FROM PostHistory edits
JOIN PostHistory originalTags ON originalTags.PostId = edits.PostId
WHERE edits.PostHistoryTypeId=6 --edited tags
  AND originalTags.PostHistoryTypeId=3 --original tags
  AND originalTags.Text LIKE '%mathematical-physics%'
  AND edits.Text NOT LIKE '%mathematical-physics%'
ORDER BY edits.CreationDate DESC

Enter Parameters

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