CSD#O8 - Quarry

SQL

set @start_date = "20210401000000";
-- O8
SELECT 
    comment_text, 
    CONCAT("[[Special:Redirect/logid/", log_id, "]]") AS log_link, 
    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 ".*[Oo]8.*" 
    AND log_timestamp > @start_date
ORDER BY 
    log_id DESC;

-- O7
SELECT 
    comment_text, 
    CONCAT("[[Special:Redirect/logid/", log_id, "]]") AS log_link, 
    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 ".*[Oo]7.*" 
    AND log_timestamp > @start_date
ORDER BY 
    log_id DESC;
SQL

Checking query status...
