instruction: Question which had the tag but no longer have it (including the editor).
response: WITH firstrev_cte AS (SELECT MIN(ph.Id) AS MinId, p.Id FROM Posts AS p JOIN PostHistory AS ph ON ph.PostId = p.Id WHERE ph.Text LIKE '%<##tagName##>%' AND NOT (p.Tags LIKE '%<##tagName##>%') GROUP BY p.Id) SELECT PostId AS "post_link", url = 'site://posts/' + CAST(PostId AS TEXT) + '/revisions', UserId AS "user_link", UserDisplayName, CreationDate FROM PostHistory INNER JOIN firstrev_cte ON PostHistory.Id = MinId ORDER BY CreationDate DESC