Find all open questions that have exactly one particular tag of your choosing — and no others
Q&A for linguists, etymologists, and serious English language enthusiasts
with singletons as ( select PostId from PostTags group by PostId having count(PostTags.TagId) = 1 ) select Id, Id as [Post Link], CreationDate as 'When', Score, AnswerCount as 'Answers', ViewCount as 'Views' from Posts inner join singletons on singletons.postid = posts.id where posts.postTypeId = 1 and -- post is a question posts.closeddate is null and -- not closed posts.Tags LIKE '<##tags##>' OR Tags LIKE 'é##tags##à' order by Posts.id