Looks like some of the 'order by' statements are pre-union. You should only sort after the unions.