Stats on page move users in fawiki

SQL

use fawiki_p;

select log_id, log_timestamp, log_user, log_user_text, log_title, log_comment, log_page, page_namespace,
  case when ug_group = 'bot' then 1 else 0 end as user_is_bot,
  (select count(*) from revision_userindex where rev_user = log_user and rev_timestamp < log_timestamp) as rev_count_before_move
from logging
join page
  on page_id = log_page
left join user_groups
  on log_user = ug_user
  and ug_group = 'bot'
where log_action = 'move'
and log_timestamp > '20170101000000'
and rev_user_text = 'Huji'
limit 10

SQL

Checking query status...