0

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

-- @PostId -> need to know id of post
DECLARE @UserId int = ##UserId##

SELECT DISTINCT u.id, u.DisplayName
FROM Users u
INNER JOIN Badges b ON u.Id = b.UserId
WHERE NOT EXISTS (
  SELECT 1
  FROM Users u2
  WHERE u2.Id = @UserId AND u2.Id NOT IN (
        SELECT b2.Id
        FROM Badges b2
        WHERE b2.UserId = u.Id
  )
)

fork query

edited dec 3

created dec 3 jon.doe46308