Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Diego Queiroz
.
Toggle Highlighting
SQL
USE ptwiki_p; SELECT rc_user_text AS USUARIO, 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 USUARIO ORDER BY REVS_E_DESFS DESC;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...