Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
SELECT Posts.Id As [Post Link] FROM Posts INNER JOIN Votes ON Posts.Id = Votes.PostId WHERE Posts.PostTypeId = 1 AND Votes.VoteTypeId = 9 ORDER BY Posts.CreationDate DESC