SQL
AخA
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 Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.