[Simon Lloyd]

Originally Posted by pcalloway

Is there a way of seeing who has accrued the most "thanks" over a period?

Here's a query to get you started, but you will probably have to use JOIN (TABLE NAME) and MIN(COLUMN NAME) and MAX(COLUMN NAME) in order to view the results between a period.

PHP Code:

SELECT `username`,`post_thanks_thanked_times`
FROM `user`
GROUP BY `post_thanks_thanked_times`,`username`
ORDER BY `post_thanks_thanked_times` DESC
LIMIT 0 , 30 


Im not a coder by any means so thats probably the limit of my help