Mine

select radiusLogs.ID from radiusLogs left join radiusLogs AS t2 on radiusLogs.ID != t2.ID WHERE radiusLogs.username = t2.username AND radiusLogs.AcctSessionID = t2.AcctSessionID AND radiusLogs.NASIPAddress = t2.NASIPAddress and t2.ID < radiusLogs.ID group by radiusLogs.ID;