SELECT
d.device_uuid
FROM
device_alerm_tbl AS a
LEFT JOIN device_tbl d ON d.device_id=a.device_id
WHERE
NOT EXISTS (
SELECT
*
FROM
device_alerm_tbl
WHERE
device_id = a.device_id
AND a.alert_end_time < alert_end_time
)
AND alerm_info=321
ORDER BY alert_end_time DESC LIMIT 0,10