tsk - Quarry

SQL

USE trwiki_p;
SET @N = 100;
SELECT COUNT(*), COUNT(DISTINCT log_user_text), COUNT(DISTINCT log_title)
FROM logging
WHERE log_action = "thank"
AND log_timestamp > DATE_SUBTRACT(NOW(), INTERVAL @N DAY)

SELECT log_user_text, COUNT(*) FROM logging
WHERE log_action = "thank"
AND log_timestamp > DATE_SUBTRACT(NOW(), INTERVAL @N DAY)
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_SUBTRACT(NOW(), INTERVAL @N DAY)
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_SUBTRACT(NOW(), INTERVAL @N DAY)
GROUP BY log_user_text, log_title
ORDER BY COUNT(*) DESC
LIMIT 10;
SQL

Checking query status...
