0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and scholars of mythology and folklore

SELECT 
  Tags.TagName AS tag_name
FROM PostTags
  INNER JOIN Tags
    ON Tags.Id = PostTags.TagId
WHERE 
  PostTags.PostId IN 
  (
    SELECT DISTINCT PostId
    FROM PostTags
      INNER JOIN Tags
        ON Tags.Id = PostTags.TagId
    WHERE Tags.TagName = '##TagName##'
  )
  AND Tags.TagName <> '##TagName##'
GROUP BY Tags.TagName

fork query

edited aug 14 12

created aug 14 12 anonymous