Currently, some entities have a relationship of a to the wrong type of entities. An example:
https://beta.bookbrainz.org/work/3fb95f66-3083-44cb-b64d-0f3c84024443 has 5 "Edition contains Work" relationships (type 10) to 5 Edition Group entities.

This can cause some weird issues with fetching the related entity, and ends up malformed on the front-end. Front-end code should be reliant in case this happens, but the relationships should also be fixed.

An SQL query can be constructed to fetch all relationships with a mismatch of entity type on either end, and perhaps even to fix said relationships automatically. However, how do you choose which relationship replacement to choose?
ie: for a relationship type 10 ('Edition contains Work') that points to an Edition Group, what EditionGroup <-> Work relationship do you select as a replacement. Perhaps they are better fixed manually.