Untitled query #65908

SQL

SELECT
   actor_name, log_type, log_action, 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_action in  ('contentmodel/change', 'abusefilter/modify', 'block/block',
#                   'block/unblock', 'delete/delete', 'delete/delete_redir',
 #                  'delete/delete_redir2', 'delete/event', 'delete/flow-delete-post',
#                   'delete/flow-delete-topic', 'delete/flow-restore-post',
#                   'delete/flow-restore-topic', 'delete/restore', 'delete/revision',
 #                  'protect/modify', 'protect/protect', 'protect/unprotect')
AND log_type="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;
SQL

Checking query status...
