Closing users who "know" about a tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Arqade

Q&A for passionate videogamers on all platforms

declare @tagName varchar(30) = ##tagName:string?ingress##

select distinct Users.Id as [User Link], Users.DisplayName
  from
  (
    (
      (
        select OwnerUserId, ParentId, Score
          from (Posts join PostTypes on Posts.PostTypeId = PostTypes.Id)
          where PostTypes.Name = 'Answer'
      ) as a
      join
      (
        select Posts.Id, Tags.TagName, Score
          from ((Posts join PostTypes on Posts.PostTypeId = PostTypes.Id)
          join (PostTags join Tags on PostTags.TagId = Tags.Id) on Posts.Id = PostTags.PostId)
          where PostTypes.Name = 'Question'
            and Tags.TagName = @tagName
      ) as q
      on a.ParentId = q.Id
    )
    join Users on a.OwnerUserId = Users.Id
  )
  where Users.Reputation > 3000
    and a.Score > 1
  order by Users.DisplayName ASC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results