Fork of
g9
by Amorymeltzer
This query is marked as a draft
This query has been published
by Amorymeltzer.
SQL
AخA
SELECT
rc_timestamp AS `time`,
actor_name AS `user`,
rc_namespace AS `namespace`,
rc_title AS `page`,
comment_text AS `comment`
FROM
recentchanges_userindex
LEFT JOIN actor_logging ON actor_id = rc_actor
JOIN comment_logging ON comment_id = rc_comment_id
WHERE
rc_timestamp > 20250310234817
AND rc_log_type = 'delete'
AND comment_text RLIKE "G10"
ORDER BY
rc_timestamp DESC
LIMIT
0;
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.