SQL
AخA
SELECT LEFT(log_timestamp, 4), COUNT(*)
FROM logging_userindex
JOIN actor_logging ON actor_id = log_actor
JOIN comment_logging ON comment_id = log_comment_id
WHERE actor_name = 'Pathoschild'
AND log_type = 'delete'
AND log_action = 'delete'
AND comment_text LIKE '%Synchbot%'
GROUP BY LEFT(log_timestamp, 4);
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.