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_ADD(NOW(), INTERVAL @N DAY);

SELECT log_user_text, COUNT(*) FROM logging
WHERE log_action = "thank"
AND log_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY)
GROUP BY log_user_text
having count(*) > 10
ORDER BY COUNT(*) DESC
LIMIT 100;

SELECT log_title, COUNT(*) FROM logging
WHERE log_action = "thank"
AND log_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY)
GROUP BY log_title
having count(*) > 10
ORDER BY COUNT(*) DESC
LIMIT 100;

SELECT log_user_text, log_title, COUNT(*) FROM logging
WHERE log_action = "thank"
AND log_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY)
GROUP BY log_user_text, log_title
having count(*) > 5
ORDER BY COUNT(*) DESC
LIMIT 100;
SQL

Checking query status...
