Usuário:Jackgba/Temp

SELECT
 rc_user_text AS USUÁRIO,
 SUM(rev) AS REVS,
 SUM(CASE WHEN rev = 1 AND rc_comment LIKE '%Huggle]])' THEN 1 ELSE 0 END) AS COM_HUGGLE,
 SUM(reveav) AS COM_REV_E_AV,
 SUM(CASE WHEN rev = 1 AND rc_comment NOT LIKE '%Huggle]])' THEN 1 ELSE 0 END) AS SEM_HUG_E_RA,
 SUM(desfeita) AS DESFEITAS,
 SUM(rev + reveav + desfeita) AS REVS_E_DESFS
 FROM (
  SELECT
   rc_user_text,
   rc_comment,
   (CASE WHEN rc_comment LIKE '[[WP:REV|%' THEN 1 ELSE 0 END) AS rev,
   (CASE WHEN rc_comment LIKE 'Desfeita a edição %' THEN 1 ELSE 0 END) AS desfeita,
   (CASE WHEN rc_comment LIKE '%Reversão e avisos]]).' THEN 1 ELSE 0 END) AS reveav
   FROM recentchanges
   WHERE rc_type != 5
   ) AS revedesf
 GROUP BY USUÁRIO
 ORDER BY REVS_E_DESFS DESC
 LIMIT 100;