Untitled query #34599

SQL

select 'ar' as lang, user_id, user_name, user_registration, edit_count as live_edit_count
(select min(rev_timestamp) from revision_userindex where rev_user=user_id and rev_timestamp >= 20020101000000 and rev_timestamp <= 20180601000000) as first_edit,
(select max(rev_timestamp) from revision_userindex where rev_user=user_id and rev_timestamp >= 20020101000000 and rev_timestamp <= 20180601000000) as last_edit
from user where coalesce(user_registration, 20010101000000) <= 20180601000000 
and 
coalesce(user_registration, 20010101000000) >= 20020101000000;
SQL

Checking query status...
