Authors are duplicated in author_sort
When I downloaded metadata for my library, one of the sources, I believe B&N, added each author (and editor, translator, etc) twice in the same book's authors field. I deleted these manually before saving them.
I hoped the author_sort field would update accordingly after saving. It did not. I have many titles with the same author listed twice in author_sort (but not in author). Thes authors are entered twice in each single book.
How can I batch remove these, and ideally prevent this from happening again? Thank you.
|