CSD#O8 - Quarry

SQL

-- 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 ".*O8.*" 
    AND log_timestamp > 20210101000000
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 ".*O7.*" 
    AND log_timestamp > 20210101000000
ORDER BY 
    log_id DESC;
SQL

Checking query status...
