Questions where a given tag was added not by its author

1

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT TOP 100
  q.Id AS [Post Link],
  h.Text AS [Edited Tags],
  q.OwnerUserId AS [User Link],
  q.CreationDate AS [Post Date],
  h.UserId AS [User Link],
  h.CreationDate AS [Edit Date]
FROM PostHistory h, Posts q
WHERE h.PostId = q.Id
  AND h.PostHistoryTypeId = 6 -- tag edit
  AND h.Text LIKE '%<' + '##Tag##' + '>%'
  AND h.UserId <> q.OwnerUserId
  AND NOT EXISTS (SELECT Id FROM PostHistory g
                  WHERE g.PostId = h.PostId
                    AND (g.PostHistoryTypeId = 3 OR g.PostHistoryTypeId = 6)
                    AND g.CreationDate < h.CreationDate
                    AND g.Text LIKE '%<' + '##Tag##' + '>%')

Enter Parameters

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