Grab latest entry from database

grab_latest.sql

SELECT *
FROM Summary t1
INNER JOIN (
    SELECT system_id, MAX(ID) as max_id
    FROM Summary
    WHERE facility = 'MAC'
    GROUP BY system_id
) t2 ON t1.system_id = t2.system_id AND t1.ID = t2.max_id
WHERE t1.facility = 'MAC'
ORDER BY T1.id