SQL
AخA
USE fawiki_p;
SELECT user_name, COUNT(log_id) cnt
FROM user JOIN logging ON log_user = user_id LEFT JOIN user_groups ON log_user = ug_user AND ug_group = 'bot'
WHERE log_type ='patrol'
AND log_action='patrol'
AND (
log_params LIKE '%auto";i:0;}'
OR log_params LIKE '%0'
)
AND ug_group IS NULL
AND log_timestamp > '20171019000000'
AND log_timestamp < '20171020000000'
GROUP BY user_name
ORDER BY cnt DESC;
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.