SQL
AخA
USE commonswiki_p;
SELECT log_user_text, SUM(log_action="move") AS Moves,
SUM(log_action="delete") AS Deletes, COUNT(*)
FROM page, pagelinks, logging_logindex
WHERE page_namespace=2 AND page_title="Dispenser/Double_extension"
AND log_namespace=pl_namespace and log_title=pl_title
AND log_action IN ("move", "delete") AND pl_from=page_id
AND log_timestamp < DATE_FORMAT(NOW(), "%Y%m01")
GROUP BY 1 ORDER BY 2 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.