Replace the subquery with a 'LIMIT 1'

The 'LIMIT 1' still requires a full sorting so it's as good as the subquery
variant but simpler.