My Comments, ordered by Score 2
Q&A for researchers, developers, students, teachers, and end users interested in bioinformatics
-- My Comments ordered by score DECLARE @UserId int = ##UserId## SELECT Comments.Score, Text, CASE WHEN Q.Id is not NULL THEN Q.Title ELSE Posts.Title END as QTitle, PostId, Posts.ParentId, Comments.CreationDate FROM Comments join Posts on Comments.PostId = Posts.Id left join Posts as Q on Posts.ParentId = Q.Id WHERE UserId = @UserId and Comments.Score > 0 ORDER BY Comments.Score DESC