Fork of
Thanks in cswiki
by Matěj Suchánek
This query is marked as a draft
This query has been published
by Anerka.
SQL
x
USE trwiki_p;
SELECT COUNT(*), COUNT(DISTINCT log_actor), COUNT(DISTINCT log_title)
FROM logging
WHERE log_action = "thank"
/*AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)*/;
SELECT log_actor, COUNT(*) FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_actor
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_actor, log_title, COUNT(*) FROM logging
WHERE log_action = "thank"
#AND log_timestamp > DATE_ADD(NOW(), INTERVAL -1 MONTH)
GROUP BY log_actor, log_title
ORDER BY COUNT(*) DESC
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.