写了条sql语句， 大家看看有神马要改进的么？

[weixin_38051859]

SELECT o.id, o.user, COUNT(DISTINCT t.user) AS user_count ,o.memo,o.create_time FROM (SELECT id, `user`, parent_id FROM osc_opt_logs WHERE obj_type = 101 AND `group` = 0 AND date(create_time)='2014-7-16' ORDER BY id DESC ) t JOIN osc_opt_logs o ON o.obj_type = 100 AND o.`group` = 0 AND o.id = t.parent_id AND date(create_time)='2014-7-16' GROUP BY o.id ORDER BY user_count DESC LIMIT 10