Untitled query #32980

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

SQL

USE ukwiki_p;

select count(t1.rev_user_text) from 
(SELECT  r1.rev_user_text, count(*) as Gt0 
from revision r1 
 join user on user.user_id = r1.rev_user 
WHERE 
    		20171212 * 1000000 <= r1.rev_timestamp  
AND 
            NOT EXISTS (SELECT 1 FROM user_groups WHERE
            	user_groups.ug_user = user.user_id AND
            	user_groups.ug_group = 'bot') 
 -- AND     		r1.rev_timestamp < 20170401 * 1000000 
            group by r1.rev_user_text
            having Gt0 > 0) t1

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

Checking query status...