老大的sql很精练。 无 select distinct(u.id) from osc_opt_logs l, osc_users u where l.user=u.id and l.obj_type=100 and u.role 100 and date(l.create_time) = '2013-2-xx' order by rand() limit 2
老大的sql很精练。 select distinct(u.id) from osc_opt_logs l, osc_users u where l.user=u.id and l.obj_type=100 and u.role < 100 and date(l.create_time) = '2013-2-xx' order by rand() limit 2