Who favourited this question?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Finds the user ID and user names of those who favourited a particular question on TeX.SE (based on the question ID).

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

-- Find who favourited a particular question

DECLARE @QuestionID int = ##QuestionID##

SELECT
  v.CreationDate AS [Voted On],
  v.UserId AS [User ID],
  u.DisplayName AS [User Name]
FROM
  Votes v
  INNER JOIN
  Users u ON v.UserId = u.Id
WHERE v.VoteTypeId = 5 AND v.PostID = ##QuestionID##
ORDER BY v.CreationDate DESC;

Enter Parameters

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