Untitled query #5854

SQL

WITH Admins AS
  (SELECT user_name,
          user_id
   FROM user
   JOIN user_groups ON user_id = ug_user
   WHERE ug_group = 'sysop'),
     AdminLogs AS
  (SELECT log_type,
          log_action,
          actor_user
   FROM logging
   JOIN actor ON actor_id = log_actor
   WHERE actor_user IN
       (SELECT admins.user_id
        FROM Admins AS admins)
   AND log_timestamp >= DATE_FORMAT(CURDATE() - INTERVAL 6 MONTH, '%Y%m%d%H%i%S'))
SELECT log_action, log_type,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 2675) artashes,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 1511) Beko,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 14988) GeoO,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 11364) Lilitik22,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 10514) Samo04,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 27182) Sigmaam,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 23951) Voskanyan,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 152) Xelgen,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 48669) ԱշբոտՏՆՂ,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 2675) artashes,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 1511) Beko,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 14988) GeoO,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 11364) Lilitik22,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 10514) Samo04,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 27182) Sigmaam,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 23951) Voskanyan,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 152) Xelgen,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 48669) ԱշբոտՏՆՂ
FROM logging AS l2
HAVING artashes+beko+GeoO+Lilitik22+Samo04+Sigmaam+Voskanyan+Xelgen+ԱշբոտՏՆՂ > 0;
SQL

Checking query status...
