XF 1.5 Create query "how much likes in 2019 per user"?

[vFranky]

Hello,

our community wants to have the information how much "likes" each users got in 2019.
Is there a simple way to get theses numbers? Perhaps an addon?

Thank you in advance!

Kind regards,
Frank

 

[Kirby]

For 2019 in UTC+1:

SELECT COUNT(*) AS likes, xf_user.user_id, xf_user.username
FROM xf_liked_content
INNER JOIN xf_user ON (xf_user.user_id = xf_liked_content.content_user_id)
WHERE xf_liked_content.like_date > 1546297200
GROUP BY xf_user.user_id
ORDER BY likes DESC

 

[vFranky]

Thank you, but get an error in PHPmyAdmin => #1146 - Table 'client9301_db2.xf_liked_content' doesn't exist
The wrong tool?

 

[Kirby]

Are you 100% sure that client9301_db2 is a XF 1.5 database?

Edit
Just to be extra safe (though this was unnecessary) I've tested this in 6 different XF 1.5 DBs - no problems

 

[vFranky]

Are you 100% sure that client9301_db2 is a XF 1.5 database?

You are right, wrong database. Sorry.
Now it works! Thank you!