Questions originally tagged [TAG] but now tagged [single-word-requests] or [phrase-requests]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

SELECT p.Id AS [Post Link], p.CreationDate, ph.Text AS [Initial tags], p.Tags
  FROM Posts AS p
  INNER JOIN PostTags AS pt ON p.Id = pt.PostId
  INNER JOIN Tags AS t ON t.Id = pt.TagId
  INNER JOIN PostHistory AS ph ON p.Id = ph.PostId
    AND ph.PostHistoryTypeId = 3 -- initial tags
  WHERE t.TagName IN ('single-word-requests', 'phrase-requests')
    AND ph.Text LIKE '%<' + ##TagName:string## + '>%'
    AND ph.Text NOT LIKE '%<single-word-requests>%'
    AND ph.Text NOT LIKE '%<phrase-requests>%'
  ORDER BY p.CreationDate DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results