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 DISTINCT log_action, log_type,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 2675) type_artashes,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 1511) type_Beko,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 14988) type_GeoO,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 11364) type_Lilitik22,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 10514) type_Samo04,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 27182) type_Sigmaam,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 23951) type_Voskanyan,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 152) type_Xelgen,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_type = l2.log_type AND actor_user = 48669) type_ԱշբոտՏՆՂ,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 2675) action_artashes,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 1511) action_Beko,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 14988) action_GeoO,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 11364) action_Lilitik22,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 10514) action_Samo04,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 27182) action_Sigmaam,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 23951) action_Voskanyan,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 152) action_Xelgen,
	(SELECT count(*) FROM AdminLogs AS l1 WHERE l1.log_action = l2.log_action AND actor_user = 48669) action_ԱշբոտՏՆՂ
FROM logging AS l2
HAVING type_artashes+type_beko+type_GeoO+type_Lilitik22+type_Samo04+type_Sigmaam+type_Voskanyan+type_Xelgen+type_ԱշբոտՏՆՂ+
		action_artashes+action_beko+action_GeoO+action_Lilitik22+action_Samo04+action_Sigmaam+action_Voskanyan+action_Xelgen+action_ԱշբոտՏՆՂ> 0;
SQL

Checking query status...
