Normally you can use order by before group by in mysql. Now the question is rise, can you use order by before group ...