Thanks in cswiki

SQL

USE cswiki_p;
SELECT log_user_text, COUNT(*) FROM logging
WHERE log_action = "thank"
GROUP BY log_user_text
ORDER BY COUNT(*) DESC
LIMIT 20;
SELECT log_title, COUNT(*) FROM logging
WHERE log_action = "thank"
GROUP BY log_title
ORDER BY COUNT(*) DESC
LIMIT 20;
SELECT log_user_text, log_title, COUNT(*) FROM logging 
WHERE log_action = "thank"
GROUP BY log_user_text, log_title
ORDER BY COUNT(*) DESC
LIMIT 10;

SELECT user_name, COUNT(thx1.log_user_text) + COUNT(thx2.log_title) AS total FROM user
	LEFT JOIN (SELECT * FROM logging WHERE log_action = "thank") AS thx1
		ON thx1.log_title = user_name
	LEFT JOIN (SELECT * FROM logging WHERE log_action = "thank") AS thx2
		ON thx2.log_user_text = user_name
GROUP BY user_name
ORDER BY total DESC
LIMIT 10;
SQL

Checking query status...
