Quote:
Originally Posted by Pigeonherd
SELECT username, count(helpful_post)
FROM ninjette
WHERE user_last_accessed_date =< '01-JAN-2015'
AND helpful_post_date BETWEEN '01-JAN-2015' AND '31-DEC-2015'
ORDER BY count(helpful_post) desc
|
The results of this query was in the "My own helpful answers" place once upon a time when the "like post" function was added to this forum. Maybe Alex will turn it back on. I kept a close eye on it and the posts it listed. After a while, it wasn't what you want. It became a "most popular" posts list. Without some additional filtering/grouping by forum, then it's usefulness is somewhat diminished because of the limit returned without pagination.