Untitled query #11737

SQL

select user_name, user_id, user_registration, min(rev_timestamp) as first_edit_timestamp, 
       min(ar_timestamp) as first_deleted_edit_timestamp, min(block.log_timestamp) as first_block, min(promote.log_timestamp) as sysop_date from enwiki_p.user 
left join revision_userindex on rev_user = user_id
left join archive_userindex on ar_user = user_id
left join logging_userindex as block on block.log_title = user_name
left join logging_userindex as promote on promote.log_title = user_name
where user_registration BETWEEN 20140801000000 and 20140801001000
      and block.log_action = "block" and block.log_type = "block"
      and promote.log_action = "rights" and promote.log_params LIKE "%sysop%"
group by user_id;
SQL

Checking query status...
