select ttuUID, ttTecmoOrder, ttlUID from standings where ttuUID = group by ttlUID order by ttlUID