Fork of
Global proxy blocks by month
by AntiCompositeNumber
This query is marked as a draft
This query has been published
by AntiCompositeNumber.
SQL
AخA
SELECT LEFT(log_timestamp, 6), COUNT(*)
FROM logging_logindex
JOIN comment_logging ON log_comment_id = comment_id
WHERE
log_type = "block"
AND log_action LIKE "block"
AND comment_text LIKE "%proxy%"
GROUP BY 1
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.