Untitled query #42316

SQL

use fiwiki_p;
select t.*, min(l1.log_timestamp) as min_editor_ts, min(l2.log_timestamp) as min_autoreview_ts,  datediff(str_to_date(min(l1.log_timestamp), "%Y%m%d%H%i%S"), str_to_date(min(l2.log_timestamp), "%Y%m%d%H%i%S")) 
from ( 
  select c, user_name, min(fr_timestamp) as min_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 where  c>100 and fr2.fr_user=user_id group by user_id
) as t LEFT JOIN logging_userindex as l1 ON l1.log_title=user_name and l1.log_type="rights" and  l1.log_params like "%editor%" LEFT JOIN logging_userindex as l2 on l2.log_title=user_name and l2.log_type="rights" and  l2.log_params like "%autoreview%" group by user_name;
SQL

Checking query status...
