The Too Localized reason for closing a question seems to general. I'm still not sure why my question was closed: Database Implementations of ORDER BY in a Subquery
Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience.
There are no typos / errors so I can only assume the "not relevant" part, and that implementations of SQL rather than SQL queries should be on SO rather than here?
I added comments and edited the question to try and make it of more use to a general audience, but no further insights as to why it was put on-hold were given prior to closing.