List users who favorited a question (and their info)

0

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?" (https://superuser.com/q/44106)

Science Fiction and Fantasy Meta

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

SELECT 
  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 userid=u.id
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

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