Column aliases should be used in WHERE and ORDER BY clauses. See Also: ColumnNameVariableResolverauthor: Rein Raudjärvsince: 1.1
WHERE
ORDER BY