Why is there no clause in order in the view subquery? Likewise, one cannot modify / delete a row through a view when:
ORDER BY usually orders a result set (i.e. columns after the first selection before FROM), never subqueries. Subqueries are used to qualify, not order results.