Untitled query #89009

SQL

SET @since = CURDATE() - INTERVAL 30 DAY;
SET @actor_name = 'Hey man im josh';

SELECT
    creator.actor_name AS page_creator,
    COUNT(DISTINCT page.page_id) AS n_articles_patrolled,
    CASE 
        WHEN EXISTS (
            SELECT 1
            FROM user_groups
            INNER JOIN user ON user_id = ug_user
            WHERE user.user_name = creator.actor_name AND ug_group = 'autoreviewer'
        ) THEN 'Yes'
        ELSE 'No'
    END AS is_autopatrolled
FROM logging_userindex AS patrol_log
JOIN actor_logging AS patroller ON patrol_log.log_actor = patroller.actor_id
JOIN page ON patrol_log.log_title = page.page_title AND patrol_log.log_namespace = page.page_namespace
JOIN logging_userindex AS create_log ON create_log.log_title = page.page_title AND create_log.log_namespace = page.page_namespace AND create_log.log_type = 'create'
JOIN actor_logging AS creator ON create_log.log_actor = creator.actor_id
WHERE patrol_log.log_action = 'reviewed'
  AND patrol_log.log_type = 'pagetriage-curation'
  AND patrol_log.log_timestamp > @since
  AND patroller.actor_name = @actor_name
GROUP BY creator.actor_name
ORDER BY n_articles_patrolled DESC;
SQL

Checking query status...
