The total likes per member over a given time period would be this query, just run this query it in your myphpadmin or adminer
SELECT
lp.id_poster, lp.like_count,
COALESCE(mem.real_name, m.poster_name) AS real_name, mem.posts
FROM (
SELECT
id_poster, COUNT(id_msg) AS like_count, MAX(id_msg) AS id_msg
FROM elkarte_message_likes
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
LIMIT 10
) 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)
LIMIT 10
That 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.
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.