As far as I can see, this can't be done with a simple GROUP BY: you would need logic like "from all records with the same sequence id which have an authorship_change field set, select the one with the latest timestamp". In SQL dialects supporting windowed/analytical expressions this is not bad, but in MySQL it would require some sort of self-join, I think.