Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Cryptic
.
For [[Wikipedia:Arbitration/Requests/Case/RHaworth/Workshop#RHaworth frequently makes deletions not clearly explained in the log]]. Omits any deletion whose log comment contains '[[WP:CSD', '[[Wikipedia:CSD', '[[L#|', or '[[L#]]', where L is A, F, R, G, or T and # is a one- or two-digit numeral.
Toggle Highlighting
SQL
SELECT CONCAT('[[', CASE log_namespace WHEN 0 THEN '' WHEN 1 THEN 'Talk:' WHEN 2 THEN 'User:' WHEN 3 THEN 'User talk:' WHEN 4 THEN 'Wikipedia:' WHEN 5 THEN 'Wikipedia talk:' WHEN 6 THEN ':File:' WHEN 7 THEN 'File talk:' WHEN 10 THEN 'Template:' WHEN 11 THEN 'Template talk:' WHEN 14 THEN ':Category:' WHEN 15 THEN 'Category talk:' WHEN 100 THEN 'Portal:' WHEN 118 THEN 'Draft:' WHEN 119 THEN 'Draft talk:' WHEN 828 THEN 'Module:' ELSE CONCAT('{{ns:', log_namespace, '}}:') END, log_title, ']]') AS 'page', DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS 'timestamp', comment_text FROM logging_userindex JOIN actor_logging ON log_actor=actor_id JOIN comment_logging ON comment_id=log_comment_id WHERE log_type = 'delete' AND log_action = 'delete' AND actor_name = 'RHaworth' AND comment_text NOT LIKE '%[[WP:CSD%' AND comment_text NOT LIKE '%[[Wikipedia:CSD%' AND comment_text NOT RLIKE '.*\[\[[AFRGT][1-9][0-9]?(\]\]|\|).*' ORDER BY log_timestamp DESC LIMIT 1000;
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...