tests - Quarry

SQL

/*
SELECT actor_name, log_type, COUNT(log_action)
FROM logging_userindex
    JOIN actor_logging
        ON log_actor = actor_id
WHERE actor_user IN (
                        SELECT ug_user FROM user_groups WHERE ug_group = 'steward'
                    )
      AND log_type in ('gblblock', 'gblrename')
      AND log_timestamp <= 20221206000000
GROUP BY log_actor, log_type
ORDER BY actor_name
*/
SELECT actor_name as "username",
		SUM(IF((log_type IN ("gblblock", "gblrename")), 1, 0)) AS "action",
		SUM(IF(log_type != '' AND log_action != '', 1, 0)) AS "total"
	FROM logging_userindex
	JOIN actor_logging
    	ON log_actor = actor_id
	WHERE actor_user IN (
							SELECT ug_user FROM user_groups WHERE ug_group = 'steward'
						)
        AND log_type IN ("gblblock", "gblrename")
		AND log_timestamp <= 20221206000000
	GROUP BY actor_name
	ORDER BY log_actor
	HAVING "total" > 0
SQL

Checking query status...
