Q&A for designers and implementers of computer programming languages
-- Getting list of answers for a user by question view SELECT a.Id as [Post Link], a.Score as "Answer Score", q.ViewCount as "Views", q.Score AS "Question Score" FROM Posts a JOIN Posts q ON a.ParentId = q.Id WHERE a.OwnerUserId = ##UserId## AND a.PostTypeId = 2 ORDER BY "Views" DESC