1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for anime and manga fans

SELECT Id AS [Post Link],
       CreationDate AS [Creation Date]
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##);

fork query

edited dec 6

created dec 6 Larnu