Untitled query #65908

SQL

SELECT
   actor_name, log_type, actor_user, count(*)
FROM logging
JOIN actor
  ON log_actor=actor_id
WHERE actor_name in ('1234qwer1234qwer4', 'Amire80', 'Atcovi', 'Billinghurst',
                    'Biplab Anand', 'CptViraj', 'DARIO SEVERI', 'Daniuu', 'DannyS712',
                    'Iluvatar', 'Infinite0694', 'MF-Warburg', 'Minorax', 'Mtarch11',
                    'NahidSultan', 'Praxidicae', 'Samuele2002', 'Savh', 'Shanmugamp7',
                     'Superpes15', 'Turkmen', 'Uncitoyen', 'WhitePhosphorus', 'WikiBayer')
AND log_type in ('delete', 'abusefilter', 'block', 'protect')
AND log_timestamp > 20210101000000
AND 'closer' not in (SELECT ug_group FROM user_groups WHERE ug_user=actor_user)
GROUP BY actor_name, log_type
ORDER BY actor_name DESC
LIMIT 500000;
SQL

Checking query status...
