Replicas browser and optimizer
This query is marked as a draft
This query has been published
For [[Wikipedia talk:Arbitration/Requests/Case/RHaworth/Evidence#Comment on evidence (Ritchie333)]]
SELECT CONCAT('User_talk:',page_title) AS page, CONCAT('Special:Diff/',rev_id) AS diff, DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp, actor_name, comment_text FROM revision_userindex JOIN actor_revision ON rev_actor = actor_id JOIN page ON page_id = rev_page JOIN comment_revision ON rev_comment_id = comment_id WHERE actor_name = 'Cryptic' AND page_namespace = 3 -- User talk: AND (page_title = 'RHaworth' OR page_title LIKE 'RHaworth/%');
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in