Order by after concatenating columns
It is possible to ORDER BY using the ordinal value of selected fields (even a calculated value) instead of using the field name. It is hard to tell from the query above, but a generic example:

SELECT field1,field2,function(field1) FROM table ORDER BY 3;