select games.gameid, games.title, games.touched, last.touched from games,
(select gameid, max(touched) as touched from crate group by gameid) as last
where games.gameid = last.gameid and  last.touched > games.touched
order by games.title, games.gameid;
