Reversões na Wikipédia Lusófona em 2014 (por usuário)

SQL

USE ptwiki_p;
SELECT
 rev_user_text AS USUARIO,
 SUM(rev + reveav) AS REVS,
 SUM(rev = 1 AND rev_comment LIKE '%Huggle]])') AS COM_HUGGLE,
 SUM(reveav) AS COM_REV_E_AV,
 SUM(rev = 1 AND rev_comment NOT LIKE '%Huggle]])') AS SEM_HUG_E_RA,
 SUM(desfeita) AS DESFEITAS,
 SUM(rev + reveav + desfeita) AS REVS_E_DESFS
 FROM (SELECT
   rev_user_text,
   rev_comment,
   (rev_comment LIKE 'Foram [[WP:REV|%') AS rev,
   (rev_comment LIKE 'Desfeita a edição %') AS desfeita,
   (rev_comment LIKE 'Reversão de uma ou mais edições de%') AS reveav
   FROM revision
     WHERE rev_timestamp LIKE '2014%'
--    WHERE rc_type != 5
 ) AS revedesf
GROUP BY USUARIO;
-- ORDER BY REVS_E_DESFS DESC;

SQL

Checking query status...