Untitled query #88142

SQL

SELECT 
    actor_name AS user,
    COUNT(DISTINCT CONCAT(r.rev_page, '-', r.rev_actor)) AS query_usage_count
FROM 
    revision_userindex r
JOIN 
    actor ON r.rev_actor = actor.actor_id
JOIN 
    page ON r.rev_page = page.page_id
WHERE 
    r.rev_timestamp >= '20240415163410'
    AND r.rev_timestamp <= '20241124102404'
    AND page.page_namespace IN (118, 2, 0)
    AND r.rev_comment_id IN (
        SELECT comment_id 
        FROM comment 
        WHERE comment_text LIKE 'Declining submission:%'
    )
    AND actor.actor_name = 'SafariScribe'
GROUP BY 
    actor_name
ORDER BY 
    query_usage_count DESC;
SQL

Checking query status...
