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 20020101000000 <= rev_timestamp <= 20180601000000) as first_edit,
(select max(rev_timestamp) from revision_userindex where rev_user=user_id and 20020101000000 <= rev_timestamp <= 20180601000000) as last_edit
from user where coalesce(user_registration, 20010101000000) <= 20180601000000 
and \n                coalesce(user_registration, 20010101000000) >= 20020101000000;
SQL

Checking query status...
