Show users who marked a as "favorites", and which posts they marked
for all questions of a certain user
Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
-- 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]
join posts on posts.id = votes.postid
posts.PostTypeId = 1 and
posts.OwnerUserId = ##UserId##