Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games
select 'site://posts/comments/' + cast(min(comments.id) as varchar) + '|' + coalesce(parents.title, posts.title) as [Comment Link], max(text) as Text, sum(500+round((datediff(day, comments.creationDate, current_timestamp)*1.0)/datediff(day, users.creationdate, current_timestamp)*1000.0,0) + comments.score * -1000) as commentScore from comments join users on (comments.userid = users.id) join posts on (comments.postid = posts.id) left join posts as parents on (posts.parentid = parents.id) where comments.userid = ##UserID## group by postid, posts.title, parents.title order by commentScore desc