Untitled query #88098

SQL

SELECT 
    COUNT(*)
FROM 
    revision_userindex r
JOIN 
    page ON r.rev_page = page_id
INNER JOIN 
    comment com ON r.rev_comment_id = com.comment_id
LEFT JOIN 
    revision_userindex rr ON r.rev_parent_id = rr.rev_id
WHERE 
    r.rev_actor IN (SELECT actor_id FROM actor WHERE actor_name = 'SafariScribe')
    AND r.rev_deleted = 0
    AND (com.comment_text LIKE 'Declining submission:%' OR LOWER(CONVERT(com.comment_text USING utf8mb4)) LIKE 'Declining submission:%')
    AND page_namespace IN (118)
    AND r.rev_timestamp >= '20241101000000'
    AND r.rev_timestamp <= '20241131235959';
SQL

Checking query status...
