Ah, I found it. It turns out if you include nonaggregated columns it will just pick one value from the group arbitrarily.

https://dev.mysql.com/doc/refman/5.5/en/group-by-handling.ht...