SQL
x
#DESCRIBE logging;
SELECT log_title
FROM logging
WHERE log_title IN (
SELECT page_title
FROM page
JOIN revision_userindex
ON page_id = rev_page
JOIN user
ON user_name = page_title
WHERE rev_user_text = 'Mike Restivo'
AND page_namespace = 3
)
AND log_type = 'block';
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.