RedWarn edits - Quarry

Fork of RedWarn users by AntiCompositeNumber

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

SQL

USE enwiki_p;
SELECT SUM(*)
FROM revision_userindex
JOIN change_tag ON ct_rev_id = rev_id
JOIN actor_revision ON rev_actor = actor_id
JOIN `user` ON actor_user = user_id
LEFT JOIN ipblocks ON user_id = ipb_user
WHERE ct_tag_id = 577 -- RedWarn
GROUP BY actor_name
ORDER BY user_registration DESC

AخA
 
USE enwiki_p;SELECT SUM(*)FROM revision_userindexJOIN change_tag ON ct_rev_id = rev_idJOIN actor_revision ON rev_actor = actor_idJOIN `user` ON actor_user = user_idLEFT JOIN ipblocks ON user_id = ipb_userWHERE ct_tag_id = 577 -- RedWarnGROUP BY actor_nameORDER BY user_registration DESC

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.

Checking query status...