SELECT max(date) as m, ... WHERE date = m;