0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

SELECT Id AS PostLink
FROM dbo.Posts P
WHERE P.PostTypeId = 1
  AND EXISTS (SELECT 1
              FROM dbo.PostTags PT 
                   JOIN dbo.Tags T ON PT.TagId = T.Id
              WHERE P.Id = PT.PostId
                AND T.TagName = ##TagName:string##)
  AND NOT EXISTS (SELECT 1
                  FROM dbo.PostTags PT
                       JOIN dbo.Tags T ON PT.TagId = T.Id
                  WHERE P.Id = PT.PostId
                    AND T.TagName != ##TagName:string##);

view current version

edited dec 6

created dec 6 Larnu