Numero di modifiche e creazioni nel namespace 0 in un dato giorno.

SQL

USE itwiki_p;
SELECT COUNT(*) AS 'Totale modifiche'
FROM recentchanges
WHERE rc_timestamp LIKE '20160223%'
AND rc_bot = 0
AND rc_namespace = 0
AND rc_type IN(0, 1);

SELECT COUNT(*) as 'Modifiche verificate (comprese le verificate automaticamente)'
FROM recentchanges
WHERE rc_timestamp LIKE '20160223%'
AND rc_bot = 0
AND rc_namespace = 0
AND rc_type IN(0,1)
AND rc_patrolled = 1;

SELECT COUNT(*) AS 'Modifiche non verificate'
FROM recentchanges
WHERE rc_timestamp LIKE '20160223%'
AND rc_bot = 0
AND rc_namespace = 0
AND rc_type IN(0,1)
AND rc_patrolled = 0;

SQL

Checking query status...