Default behaviour of JOIN and ORDER BY