I believe that moving _ORDER BY_ clause to the outer query produces invalid SQL statement here. User needs to select columns applied in _ORDER BY_ clause for query to work. We could automatically add missing columns to innermost query, but skip their selection further.