CSD#O8 - Quarry

SQL

SELECT comment_text, CONCAT("[[Special:redirect/logid/", log_id, "]]"), log_timestamp FROM logging_logindex
JOIN comment ON log_comment_id = comment_id
WHERE log_type = 'delete' AND log_action = 'delete'
AND comment_text  rlike ".*O8.*" and log_timestamp > 20210101000000
ORDER BY log_id DESC;

SELECT comment_text, CONCAT("[[Special:redirect/logid/", log_id, "]]"), log_timestamp FROM logging_logindex
JOIN comment ON log_comment_id = comment_id
WHERE log_type = 'delete' AND log_action = 'delete'
AND comment_text  rlike ".*O7.*" and log_timestamp > 20210101000000
ORDER BY log_id DESC;
SQL

Checking query status...
