Change Details

Could you please run this query for me, as I lack privileges to do so: explain select user_id, user_name, reg_time, count(log_id) as moves from (select user_id, user_name, user_registration, now()-str_to_date(user_registrati on, '%Y%m%d%H%i%s') as reg_time from user order by user_id desc limit 10) as user_list, logging where user_id = log_user and log_type='move'; Any suggestions on how to optimize it would also be gratefully received. I'm trying to get the count of page moves for the n most-recently-registered users.