Is there a way to know who favorited ★ a question?
If yes, how?
If not, why does it have to be 'private information'?
Sure, it's possible. I wrote a simple query, which you can find on Data StackExchange here.
It takes in an input of
Question ID, and returns a list of
User ID and
User names who favourited that particular question.
E.g. Question ID 8021 is Is there a (La)TeX distribution running on iPad?
Running the query on this gives 11 favourites:
It's easy to verify that these people actually did favourite that question by going to their profiles and checking their activity.
With regards to the privacy concerns, there has been a discussion on Meta before, Can there be an option to keep your list of favourites private?.
For those who do not know how to get the question ID, it'll be on the URL. For example:
And I decided to post the query here for posterity:
-- 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;