The total likes per member over a given time period would be this query, just run this query it in your myphpadmin or adminer
SELECTThat will give the top ten for the month defined, in this case December. That just a pure count of likes, so can be gigged e.g. two members simply post reply's and like each others messages.
COALESCE(mem.real_name, m.poster_name) AS real_name, mem.posts
id_poster, COUNT(id_msg) AS like_count, MAX(id_msg) AS id_msg
WHERE id_poster != 0
AND like_timestamp BETWEEN UNIX_TIMESTAMP("2022/12/01") AND UNIX_TIMESTAMP("2022/12/31 23:59:59")
GROUP BY id_poster
ORDER BY like_count DESC
) AS lp
INNER JOIN elkarte_messages AS m ON (m.id_msg = lp.id_msg)
INNER JOIN elkarte_members AS mem ON (mem.id_member = m.id_member)
You could also do a by unique likers on a topic in a given period, so if one member likes every post in a topic of another member, it would only count as one. If you want that query let me know.