Worst comments per user

3

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

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 postid as [Post Link], max(text), sum(500+round((datediff(day, comments.creationDate, current_timestamp)*1.0)/datediff(day, users.creationdate, current_timestamp)*1000.0,0) + score * -1000) as commentScore 
from comments join users on (comments.userid = users.id)
where comments.userid = ##UserID##
group by postid
order by commentScore desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results