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 BETWEEN '20241101000000' AND '20241201235946'
    AND r.rev_comment_id IN (
        SELECT comment_id 
        FROM comment 
        WHERE comment_text LIKE '%#NOV24%'
        AND comment_text NOT LIKE '%#NOV24REVIEW%'
    )
    AND actor.actor_name = 'JTtheOG'
GROUP BY 
    actor_name
ORDER BY 
    query_usage_count DESC;
SQL

Checking query status...
