Favorite data is not exactly confidential; I can go to a user's profile and see everything they have as a favorite. Why isn't there an easy way to see who marked my questions as favorite?


My guess is that you could probably work up a query with some SQL-fu.

This site is usually pretty easy to work with:


Example: users who've marked my questions as favorites on Stack Overflow

For reference:



I'd actually suggest going the other way: make my list of favorited questions private. I don't see why anyone else needs to know which questions I like enough to come back to.

  • 9
    Cause after reading them, they may like them too? – Peter Ajtai Sep 2 '10 at 23:40
  • 3
    I seriously and strongly disagree. Everything on the SE network should be public except in the cases of some negative behavior (which should be removed in the first place). I -1 this on account of it is bad juju. – jcolebrand Jun 12 '11 at 17:28
  • 2
    the question is whether everything should be pubic – Andrew Jan 10 '14 at 18:58
  • 1
    @PeterAjtai Maybe someone favorited Is shaving your pubic hair bad for you? ("for a friend"), but they don't want people to see that? And there's no reason for a user to think that clicking that star icon will be something other users can see? – Kip Oct 4 '17 at 17:26

You could query the database:



There's no way to do this directly (Stack Overflow provides no mechanism to do so), but sometimes you can use Google to find out. As an example, suppose you wanted to find out who marked "Jon Skeet Facts?" as favorite. Just search for

"Jon Skeet Facts?" site:stackoverflow.com inurl:favorites

on Google.

  • repost from here: stackoverflow.com/questions/166109/… – Kyle Cronin Jun 29 '09 at 19:12
  • It wouldn't exactly be a difficult SQL query to write and implement, either. – TheTXI Jun 29 '09 at 19:13
  • 4
    I tested this on a question that has 21 favorites; 4 came up and only 2 actually had it as a favorite. Not a very good success rate. – Paolo Bergantino Jun 29 '09 at 19:13
  • 1
    But it's success nonetheless! – devinb Jun 29 '09 at 19:18
  • 4
    @devinb: The number of result represented less than 20%, and 50% of that were false positives. You have a very low standard for success. I wish you were my boss. "What did you accomplish today, Pesto?" "I added a line of code that only core dumps once in every 5 tries!" "SUCCESS!" – Hilarious Comedy Pesto Jun 29 '09 at 19:22
  • @thetxi Google query vs. SQL query...is there much of a difference any more...? – jjnguy Jun 29 '09 at 19:28
  • Google query - "Did you mean RIGHT OUTER JOIN?" – TheTXI Jun 29 '09 at 19:30
  • Honestly, who didn't mark that question as a favorite? ;) – Bill the Lizard Jun 29 '09 at 19:40
  • 4
    I didn't. In fact, I voted to close it when someone (no names mentioned here) removed the jon-skeet tag (that I have on ignored tags) – Powerlord Jun 29 '09 at 20:53
  • @TheTXI: I wonder what the difference is between write SQL and implement SQL – Vinko Vrsalovic Aug 26 '09 at 1:54

This would allow to find people that have the same problems or interests. Nice feature for networking. Alternative: neighborhood graph based on tags in questions and answers.

  • Heh, interesting idea, that last one. Reminds me of last.fm which (as one of their many data mining features) produces a list of "neighbours" with similar musical taste – Jonik Jul 1 '09 at 9:35

It looks like you may be able to get this from the public data dump now, starting from the July 2009 dump: https://blog.stackoverflow.com/2009/07/creative-commons-data-dump-july-09/

You must log in to answer this question.

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