Is there a way to know who favorited ★ a question?

If yes, how?

If not, why does it have to be 'private information'?

  • 2
    If you can narrow down the pool of users to a couple of "suspects", you can check their profile pages with the list of favourites. For example you can see my "favourites" here tex.stackexchange.com/users/36296/samcarter?tab=favorites (the quotation marks because I use it as some kind of bookmark to be able to find some questions again) Commented Dec 28, 2018 at 20:41
  • @samcarter Well that would be the hard way. What if there are "100 suspects" or what if you have absolutely no idea who could be. Commented Dec 28, 2018 at 20:49
  • That's why my comment started with "if" :) Commented Dec 28, 2018 at 20:56
  • @samcarter Ah. ok :) Commented Dec 28, 2018 at 21:01
  • 5
    off-topic: please don't interpret too much in any counts of favourites. Users use this button for all kinds of purposes (to compensate other missing functionalities in the UI of this site), knowing who favourites a question would not be really useful, unless you ask the user why he/she/it favoured the post Commented Dec 28, 2018 at 21:01
  • @samcarter Yes, you are totally right, I was just being curious. Commented Dec 28, 2018 at 21:06
  • @samcarter is right when she said users use the "favorite" button for any kind of purpose: in my case, other than my favorite posts, I use it also to flag the question I think I could ask, to answer when I have time, if nobody else already did it meanwhile. However, the question is very interesting, +1!
    – CarLaTeX
    Commented Dec 29, 2018 at 6:22
  • @CarLaTeX it is, isn't? :D Commented Dec 29, 2018 at 18:17
  • Absolutely! :):):)
    – CarLaTeX
    Commented Dec 29, 2018 at 18:22

1 Answer 1


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##

  v.CreationDate AS [Voted On],
  v.UserId AS [User ID],
  u.DisplayName AS [User Name]
  Votes v
  Users u ON v.UserId = u.Id
WHERE v.VoteTypeId = 5 AND v.PostID = ##QuestionID##
ORDER BY v.CreationDate DESC;
  • 1
    Great! I run it on some of my questions and I surprisingly found out that users who flagged them, in general, aren't "habitué" of the site!
    – CarLaTeX
    Commented Dec 29, 2018 at 6:34
  • Thank you for your answer. Commented Dec 29, 2018 at 18:17
  • Your request does not work in all cases. There are users who are not displayed. For example, this question has two favorites, your query only displays one. tex.stackexchange.com/q/468363/138900
    – AndréC
    Commented Jan 12, 2019 at 5:27
  • @AndréC Perhaps the database is not updated yet.
    – Troy
    Commented Jan 12, 2019 at 13:44
  • Perhaps. This question has 2 favorites, only one is displayed : tex.stackexchange.com/q/468363/138900
    – AndréC
    Commented Jan 12, 2019 at 13:54
  • Does this still works? I am trying to use it but does not return anything. Commented Feb 8, 2019 at 0:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .