EFH at EFFP audit

SQL

SET @granted = '20231115135600';
SELECT 'EggRoll97' AS 'User',
SUM(r.rev_timestamp < @granted) AS 'Ct before EFH',
SUM(r.rev_timestamp >= @granted) AS 'Ct after EFH',
SUM(r.rev_timestamp < @granted) / DATEDIFF(@granted, MIN(r.rev_timestamp)) AS 'Avg daily before EFH',
SUM(r.rev_timestamp >= @granted) / DATEDIFF(NOW(), @granted) AS 'Avg daily after EFH'
FROM user u
INNER JOIN actor_user a ON u.user_id = a.actor_user
INNER JOIN revision_userindex r ON a.actor_id = r.rev_actor
INNER JOIN page p ON r.rev_page = p.page_id AND p.page_namespace = 4
WHERE u.user_name = 'EggRoll97'
AND p.page_title = 'Edit_filter/False_positives/Reports'
UNION ALL
SET @granted = '20231117002400';
SELECT 'Illusion Flame' AS 'User',
SUM(r.rev_timestamp < @granted) AS 'Ct before EFH',
SUM(r.rev_timestamp >= @granted) AS 'Ct after EFH',
SUM(r.rev_timestamp < @granted) / DATEDIFF(@granted, MIN(r.rev_timestamp)) AS 'Avg daily before EFH',
SUM(r.rev_timestamp >= @granted) / DATEDIFF(NOW(), @granted) AS 'Avg daily after EFH'
FROM user u
INNER JOIN actor_user a ON u.user_id = a.actor_user
INNER JOIN revision_userindex r ON a.actor_id = r.rev_actor
INNER JOIN page p ON r.rev_page = p.page_id AND p.page_namespace = 4
WHERE u.user_name = 'Illusion Flame'
AND p.page_title = 'Edit_filter/False_positives/Reports'
SQL

Checking query status...
