Untitled query #42312

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

SQL

use fiwiki_p;
select c, user_name, min(fr_timestamp) as min_ts, min(l1.log_timestamp) as min_editor_ts from (select sum(1) c, user_name, user_id from flaggedrevs, user  where user_id=fr_user and  floor(fr_timestamp/1000000) > 20190220 and fr_flags not like "%auto%" group by fr_user) as t, flaggedrevs as fr2, logging_userindex as l1 where l1.log_title=user_name and l1.log_type="rights" and  l1.log_params like "%editor%" and  c>100 and fr2.fr_user=user_id group by user_id;

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...