List users who favorited a question (and their info)


Please login or register to vote for this query.

(click on this box to dismiss)

Default question: "How can I can I setup auto-login, AND make it public knowledge that I do stuff like that with my logins?" (

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

  userid As [User Link], 
  format(b.creationdate,'MMM d, yyyy') As [📅 ⭐], 
  format(lastaccessdate,'MMM d, yyyy') as [📅 🏃],
  reputation as [🏆],
  location as [🌎  📌],
  websiteurl as [🏠  💻] 
FROM votes b left join users u on
WHERE b.votetypeid = 5 
  AND postid = ##PostID?15617512##
  ORDER BY isnull(len(location),0)+isnull(len(websiteurl),0) DESC, REPUTATION

-- PostID: Enter a question's Post ID:
--                                    ...sry, needed to extend my break 😜

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results