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;