select c,a,b from table where something;