帆软用户eQQ2GKiTwJ(提问者)select distinct username,ip,tname,todate(time),displayName,type
from fine_record_execute a
left join fine_record_execute b
on a.username =b.username
where username != \'admin(admin)\'
and username is not null
and todate(time) >= \'${start1}\'
and todate(time) <= \'${end1}\'
and username!=\'test(test)\'
and username!=\'TEST(TEST)\'
order by time desc