Untitled query #28062

SQL

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;
SELECT user_name FROM user JOIN user_groups ON user_id=ug_user WHERE ug_group='bot';
SELECT user_name FROM user JOIN user_former_groups ON user_id=ufg_user WHERE ufg_group='bot';
SQL

Checking query status...
