Show users who marked a as "favorites", and which posts they marked for all questions of a certain user
Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
-- Who Favorited My Question? -- Show users who marked a as "favorites", and which posts they marked... select votes.userid as [User Link], posts.id as [Post Link] from votes join posts on posts.id = votes.postid where votetypeid=5 and posts.PostTypeId = 1 and posts.OwnerUserId = ##UserId##