Number of locks for Spam-only and others

Fork of Number of locks for Spam-only and others by Ladsgroup

This query is marked as a draft This query has been published by Vermont.

SQL

USE metawiki_p;
SELECT
  SUBSTR(log_timestamp, 1, 8) AS day,
  COUNT(log_id) AS Locks
FROM logging_logindex JOIN comment_logging ON log_comment_id = comment_id
WHERE log_timestamp > '20230000'
AND log_action = 'setstatus'
AND comment_text = 'Spam-only account: spambot'
GROUP BY day;

SELECT
  SUBSTR(log_timestamp, 1, 8) AS day,
  COUNT(log_id) AS Locks,
  comment_text
FROM logging_logindex JOIN comment_logging ON log_comment_id = comment_id
WHERE log_timestamp > '20230000'
AND log_action = 'setstatus'
GROUP BY day, comment_text
HAVING Locks > 50;

SQL

Checking query status...