1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings

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