Fork of
Edits by user and edit summary regex
by Cryptic
This query is marked as a draft
This query has been published
by Qwerfjkl.
SQL
AخA
SELECT rev_id,
,
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
JOIN comment_revision ON comment_id = rev_comment_id
LEFT JOIN page ON page_id = rev_page
WHERE actor_name = 'Qwerfjkl (bot)'
AND comment_text RLIKE 'removed: \\\[\\\[Category:.*\\\]\\\]\\\s*\\\([2-7]\\\)';
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.