Thanks in trwiki

1) Total number of thanks, users who thanked and who were thanked.
2) Most thanking users
3) Most thanked users
4) Most thanking users by target.
5) Most thanking users to a specific user

SQL

USE trwiki_p;
SELECT COUNT(*), COUNT(DISTINCT log_actor), COUNT(DISTINCT log_title)
FROM logging
WHERE log_action = "thank"
/*AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)*/;

SELECT log_actor, COUNT(*) FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_actor
ORDER BY COUNT(*) DESC
LIMIT 20;

SELECT log_title, COUNT(*) FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_title
ORDER BY COUNT(*) DESC
LIMIT 20;

SELECT log_actor, log_title, COUNT(*) FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_actor, log_title
ORDER BY COUNT(*) DESC
LIMIT 10;

SQL

Checking query status...