Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT Comments.Id AS [Comment Link], Comments.Score, Comments.Text FROM Posts LEFT JOIN Comments ON Posts.Id = Comments.PostId WHERE UserId = ##UserId:int## ORDER BY Score DESC