fix order_by syntax
sort promotion by name desc