Current active Wikipedia user

SQL

select actor_name,
CONCAT(substr(rev_timestamp,1,4),"-",substr(rev_timestamp,5,2), "-",substr(rev_timestamp,7,2)," ",substr(rev_timestamp,9,2)+7,":",substr(rev_timestamp,11,2)) as 'Last Edit',
CONCAT(substr(log_timestamp,1,4),"-",substr(log_timestamp,5,2), "-",substr(log_timestamp,7,2)," ",mod(substr(log_timestamp,9,2)+7,24),":",substr(log_timestamp,11,2)) as 'Last Log'
from `user`
join actor on actor_user = user_id
join revision_userindex
on rev_id = (select rev_id from revision_userindex where actor_id = rev_actor order by rev_timestamp desc limit 1)
join logging_userindex
on log_id = (select log_id from logging_userindex where actor_id = rev_actor order by log_timestamp desc limit 1)
limit 10;
/*select * from revision_userindex limit 1;*/
SQL

Checking query status...
