Questions with one tag on [pets.se]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Find all the questions on [pets.se] that have exactly one tag, with the premise that they need more to classify (at least) pet type and the problem.

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

with singletons as (
  select PostId from PostTags
    group by PostId
    having count(PostTags.TagId) = 1
)

select 
  Id, Id as [Post Link], Tags 
from Posts inner join singletons on singletons.postid = posts.id
where
  posts.postTypeId = 1 and
  posts.closeddate is null
order by Posts.id

Enter Parameters

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