一天当中评论数量最多的10个用户SQL

select count(*) as num,u.email  from eload_order_info as o 
LEFT JOIN eload_users as u on u.user_id = o.user_id   
GROUP BY o.user_id ORDER BY num desc LIMIT 0,10

select * from (select count(*) as num,u.email  from eload_order_info as o 
LEFT JOIN eload_users as u on u.user_id = o.user_id   
GROUP BY o.user_id ) as temp order by num desc LIMIT 0,10