Comment by Exuma

Also just let me reference the damn alias in a group by, FUCK