Untitled query #78955

SQL

SELECT  actor_name,  SUM(CASE    WHEN page_namespace = 0 THEN 1    ELSE 0  END) AS article,  SUM(CASE    WHEN page_namespace = 1 THEN 1    ELSE 0  END) AS articletalk,  SUM(CASE    WHEN page_namespace = 2 THEN 1    ELSE 0  END) AS usr,  SUM(CASE    WHEN page_namespace = 3 THEN 1    ELSE 0  END) AS usrtalk,  SUM(CASE    WHEN page_namespace = 4 THEN 1    ELSE 0  END) AS proj,  SUM(CASE    WHEN page_namespace = 5 THEN 1    ELSE 0  END) AS projtalk,  SUM(CASE    WHEN page_namespace = 6 THEN 1    ELSE 0  END) AS file,  SUM(CASE    WHEN page_namespace = 7 THEN 1    ELSE 0  END) AS filetalk,  SUM(CASE    WHEN page_namespace = 8 THEN 1    ELSE 0  END) AS mw,  SUM(CASE    WHEN page_namespace = 89 THEN 1    ELSE 0  END) AS mwtalk,  SUM(CASE    WHEN page_namespace = 10 THEN 1    ELSE 0  END) AS tpl,  SUM(CASE    WHEN page_namespace = 11 THEN 1    ELSE 0  END) AS tpltalk,  SUM(CASE    WHEN page_namespace = 12 THEN 1    ELSE 0  END) AS helppage,  SUM(CASE    WHEN page_namespace = 13 THEN 1    ELSE 0  END) AS helptalk,  SUM(CASE    WHEN page_namespace = 14 THEN 1    ELSE 0  END) AS cat,  SUM(CASE    WHEN page_namespace = 15 THEN 1    ELSE 0  END) AS cattalk,  SUM(CASE    WHEN page_namespace = 100 THEN 1    ELSE 0  END) AS portal,  SUM(CASE    WHEN page_namespace = 101 THEN 1    ELSE 0  END) AS portaltalk,  SUM(CASE    WHEN page_namespace = 828 THEN 1    ELSE 0  END) AS module,  SUM(CASE    WHEN page_namespace = 829 THEN 1    ELSE 0  END) AS moduletalk,  COUNT(*) AS totFROM revisionJOIN actor  ON rev_actor = actor_idJOIN page  ON page_id = rev_pageJOIN user  ON actor_user = user_idLEFT JOIN user_groups  ON actor_user = ug_user  AND ug_group = 'bot'WHERE  actor_user <> 0  AND actor_user <> 374638 /* پیام به کاربر جدید */  AND ug_group IS NULLGROUP BY actor_nameORDER BY tot DESC
SQL

Checking query status...
