Due to this one should not manually order the output if you are expecting to be able to replay the SQL directly from the VIEW query result. It is still possible to order if you filter out the FOREIGN ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results