This query is marked as a draft This query has been published by A smart kitten.

SQL

AخA
 
select DATE_FORMAT(log_timestamp, '<div style="text-align: center;">%Y-%m-%d<br>%H:%i</div>') as 'timestamp', actor_name as 'actor', log_action as 'action', CONCAT('{{namespace name|', log_namespace, '}}', log_title) as page_title, comment_text, CONCAT('{{collapse|<nowiki>', log_params, '</nowiki>}}') as 'log_params'
       from logging
       inner join actor on log_actor = actor_id
       inner join comment_logging on log_comment_id = comment_id
       where log_timestamp > 20240502000000
       and log_type = 'delete'
       and comment_text like '%x3%' collate utf8_general_ci
       order by log_timestamp desc
       limit 50;
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.

Checking query status...