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
Are you 100% sure thatclient9301_db2
is a XF 1.5 database?
We use essential cookies to make this site work, and optional cookies to enhance your experience.