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
Nemo bis
.
Patrolled edits on the Italian Wikipedia, it.wiki, it.wikipedia. Quota giornaliera di modifiche modificate fra le ultime modifiche (30 giorni), sul totale e sulle solo modifiche effettuate da utenti non registrati. Sono escluse modifiche segnate come bot, modifiche fuori dal namespace 0, "finte" ultime modifiche (come quelle per tracciare gli aggiornamenti in Wikidata o l'aggiunta/rimozione da categorie).
Toggle Highlighting
SQL
USE itwiki_p; SELECT GIORNO, CONTRIBUTI, PATROLLED, CONCAT(ROUND(PATROLLED * 100 / CONTRIBUTI), ' %') AS PERCENTUALE, CONCAT(ROUND(ANONIMIPATROLLED * 100 / ANONIMI), ' %') AS SoloNonRegistrati FROM ( SELECT SUBSTR(rc_timestamp, 1, 8) AS GIORNO, SUM(rc_user > -1) AS CONTRIBUTI, SUM(rc_patrolled) AS PATROLLED, SUM(rc_user = 0) AS ANONIMI, SUM(rc_patrolled AND rc_user = 0) AS ANONIMIPATROLLED FROM recentchanges WHERE rc_type < 5 GROUP BY GIORNO ORDER BY rc_id DESC LIMIT 72 ) AS edits;
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...