Untitled query #59847

SQL

SELECT actor_name AS `username`,
                SUM(IF((log_type IN (delete,delete) AND log_action IN (delete,delete)), 1, 0)) AS delete,
SUM(IF((log_type IN (delete,delete) AND log_action IN (revision,revision)), 1, 0)) AS revision-delete,
SUM(IF((log_type IN (delete,delete) AND log_action IN (event,event)), 1, 0)) AS log-delete,
SUM(IF((log_type IN (delete,delete) AND log_action IN (restore,restore)), 1, 0)) AS restore,
SUM(IF((log_type IN (block,block,block,block) AND log_action IN (block,reblock,block,reblock)), 1, 0)) AS re-block,
SUM(IF((log_type IN (block,block) AND log_action IN (unblock,unblock)), 1, 0)) AS unblock,
SUM(IF((log_type IN (protect,protect,stable,stable,protect,protect,stable,stable) AND log_action IN (protect,modify,config,modify,protect,modify,config,modify)), 1, 0)) AS re-protect,
SUM(IF((log_type IN (protect,protect) AND log_action IN (unprotect,unprotect)), 1, 0)) AS unprotect,
SUM(IF((log_type IN (rights,rights) AND log_action IN (rights,rights)), 1, 0)) AS rights,
SUM(IF((log_type IN (merge,merge) AND log_action IN (merge,merge)), 1, 0)) AS merge,
SUM(IF((log_type IN (import,import,import,import) AND log_action IN (interwiki,upload,interwiki,upload)), 1, 0)) AS import,
SUM(IF((log_type IN (abusefilter,abusefilter,abusefilter,abusefilter) AND log_action IN (modify,create,modify,create)), 1, 0)) AS abusefilter,
SUM(IF((log_type IN (contentmodel,contentmodel,contentmodel,contentmodel) AND log_action IN (change,new,change,new)), 1, 0)) AS contentmodel,

                SUM(IF(log_type != '' AND log_action != '', 1, 0)) AS `total`
            FROM logging
            JOIN actor ON log_actor = actor_id
            WHERE log_type IN (delete,delete,delete,delete,block,block,block,protect,protect,stable,stable,protect,rights,merge,import,import,abusefilter,abusefilter,contentmodel,contentmodel)
                AND log_action IN (delete,revision,event,restore,block,reblock,unblock,protect,modify,config,modify,unprotect,rights,merge,interwiki,upload,modify,create,change,new)
                
            GROUP BY actor_name
            HAVING `total` > 0
SQL

Checking query status...
