[UPHPU] specifying with row is displayed when using MySQL GROUP BY

[Wade Preston Shearer]

I have an ugly join that is producing similar rows. Sometimes I want this? other times I do not. On the times I do not, I can collapse the similar rows into one with GROUP BY. When it collapses them however, it displays the first. I want it to display that last. Is that possible? I have tried sorting but it doesn't affect it because the sort happens after the group.