tsk - Quarry

SQL

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

SELECT log_user_text, COUNT(*) FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_user_text
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_user_text, log_title, COUNT(*) FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_user_text, log_title
ORDER BY COUNT(*) DESC
LIMIT 10;
SQL

Checking query status...
