Select * from alojamientos where alojamientos.habilitado order by alojamientos.nombre
[Microsoft][SQL Native Client][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near 'order'.