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/

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.html https://dev.mysql.com/doc/refman/5.5/en/group-by-handling.ht...