Summary of RHaworth's deletions

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

For [[Wikipedia:Arbitration/Requests/Case/RHaworth/Evidence]]

SQL

SELECT * FROM actor_logging WHERE actor_name = 'RHaworth';

SELECT log_action, LEFT(log_timestamp,4) AS year, COUNT(*)
FROM logging_userindex
WHERE log_type='delete'
  AND log_actor=2933
GROUP BY year, log_action
ORDER BY log_action, year ASC;

​x
 
SELECT * FROM actor_logging WHERE actor_name = 'RHaworth';​SELECT log_action, LEFT(log_timestamp,4) AS year, COUNT(*)FROM logging_userindexWHERE log_type='delete'  AND log_actor=2933GROUP BY year, log_actionORDER BY log_action, year ASC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Query status: complete

Executed in 24.17 seconds as of Fri, 03 Jan 2020 01:08:55 UTC.