Untitled query #65908

SQL

SELECT
   actor_name AS user, log_type AS type, comment_text, COUNT(*) as count
FROM logging
JOIN actor
  ON log_actor=actor_id
JOIN comment
  ON log_comment_id=comment_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 ('protect', 'block', 'delete', 'abusefilter')
AND log_action not in ('move_prot', 'delete_redir')
AND LEFT(log_timestamp, 8) >= REPLACE(CURDATE() - interval 183 day, '-', '')
AND LOWER(comment_text) NOT LIKE '%steward]]%'
AND 'sysop' 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...
