SELECT ID, LOGIN, EMAIL
FROM DIARIES A
JOIN
( SELECT DIARY_ID AS DI, MAX(ID,ASD, MAX(ASDD)) AS KEK
FROM POSTS P
GROUP BY DIARY_ID ) GG ON A.ID = GG.DI
WHERE EXISTS
( SELECT *
FROM ASD )
ORDER BY GG.KEK DESC