removed bad order by
hold the phone, we need the order by, but we need mysql to be not so damn picky about capitalization of aliases