See http://meta.stackoverflow.com/questions/94852/what-could-increase-the-upvotes-on-old-answers-i-am-getting/94888#94888
Q&A for community managers, administrators, and moderators
-- Reputation for old questions/answers -- See http://meta.stackoverflow.com/questions/94852/what-could-increase-the-upvotes-on-old-answers-i-am-getting/94888#94888 select p.PostTypeID, v.VoteTypeID, vt.name, p.ID as postID, -- '<a href="http://stackoverflow.com/q/'+ p.Id + '">' + p.Id + '</a>' as postID, p.CreationDate as pDate, v.CreationDate as vDate, Datediff(day, p.CreationDate, v.CreationDate) from votetypes vt join votes v on vt.ID = v.VoteTypeID join posts p on v.PostId = p.Id where p.OwnerUserId = '##userId##' -- and p.CreationDate > NOW()-200 -- group by v.postid order by v.creationDate