It's because you can not use ORDER BY in a view in versions before 8.1