Story-ID questions having at least one rarely-used tag


Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

select pt.PostId as [Post Link], p.Tags from PostTags pt 
join Posts p on pt.PostId = p.Id
where pt.PostId IN 
 (select PostId from PostTags where TagId = 130)
and PostId IN 
 (select PostId from PostTags group by PostId having COUNT(PostId) > 1)
and TagId IN 
 (select TagId from PostTags group by TagId having COUNT(TagId) < 50)

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results