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;