>No, it should not cause the optimization problem - it is just a bad habit for SQL Server. That's why I noted it as unrelated observation.

The new queries, since a while, are using a naming convention for the ordering instead of the numeric representation.