Someone
public sql v1 · immutableSELECT u.first AS FirstName, u.last AS LastName, MAX(a.time) AS LastLoginDate FROM user AS u LEFT JOIN audit AS a ON u.id=a.uid LEFT JOIN access AS c ON u.id=c.uid WHERE c.level = '1' AND u.active = '1' GROUP BY FirstName, LastName ORDER BY LastLoginDate ASC LIMIT 999