Quota di contributi verificati nella Wikipedia in italiano

Fork of Quota di contributi verificati nella Wikipedia in italiano by Nick31629

This query is marked as a draft This query has been published by Nick31629.

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).

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;

AخA
 
USE itwiki_p;SELECT  GIORNO, CONTRIBUTI, PATROLLED, CONCAT(ROUND(PATROLLED * 100 / CONTRIBUTI), ' %') AS PERCENTUALE, CONCAT(ROUND(ANONIMIPATROLLED * 100 / ANONIMI), ' %') AS SoloNonRegistratiFROM (  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.

SQL

This query has never yet been executed