Untitled query #6214

SQL

USE itwiki_p;
SELECT GIORNO, CONTRIBUTI, PATROLLED, CONCAT(ROUND(PATROLLED * 100 / CONTRIBUTI), ' %') AS PERCENTUALE, ANONIMI, 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_bot = 0
  AND rc_namespace = 0
  AND rc_type IN(0, 1)
  GROUP BY GIORNO
  ORDER BY rc_id DESC
) AS edits;
SQL

Checking query status...
