It's very common to see books in storygraph where the same author appear twice (sometimes more) in the list of authors. I'm not talking about in other roles (contributor, illustrator, etc), which i imagine there may be cases in which it makes sense to have it, but just in the regular list of authors the same author (with same author id) appear twice.

I imagine this is due to some wrong import, but as a librarian i had to fix hundreds of this so far, and everyday i find more.

It would be nice, in order to have better data and to remove some work from librarians, to do a cleanup directly in the DB removing all authors that appear more than once in the same book, and leave only one, so we cleanup the data we already have.

Also it would be nice to have this automatic cleanup every time someone add the same author twice, or if an author gets merged into another author redo it on all their books, in case it appear twice after the merge