Untitled query #28062

SQL

/*SELECT * from user_groups where ug_group='bot' limit 10;
SELECT * from user_former_groups where ufg_group='bot' limit 10;
SELECT * from user where user_name='AkBot';
SELECT * from actor where actor_user=6868;*/
SELECT COUNT(*) AS 'liczba',SUBSTR(rev_timestamp,1,8) AS 'data' FROM revision GROUP BY SUBSTR(rev_timestamp,1,8) ORDER BY 1 DESC LIMIT 10;
SELECT COUNT(*) AS 'liczba bez edycji botów',SUBSTR(rev_timestamp,1,8) AS 'data' FROM revision WHERE rev_actor NOT IN (SELECT actor_id FROM actor JOIN user_groups ON ug_user=actor_user WHERE ug_group='bot') AND rev_actor NOT IN (SELECT actor_id FROM actor JOIN user_former_groups ON ufg_user=actor_user WHERE ufg_group='bot') GROUP BY SUBSTR(rev_timestamp,1,8) ORDER BY 1 DESC LIMIT 10;
SQL

Checking query status...
