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
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
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