Questions with one tag


Please login or register to vote for this query.

(click on this box to dismiss)

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.postTypeId = 1     and  -- post is a question
  posts.closeddate is null and  -- not closed
  posts.Tags LIKE '<##tags##>' OR Tags LIKE 'é##tags##à'
order by

Enter Parameters

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