listIdentities lists identities multiple times with credential_identifier set

[jonas-jonas]

Preflight checklist

• I could not find a solution in the existing issues, docs, nor discussions.
• I agree to follow this project's Code of Conduct.
• I have read and am following this repository's Contribution Guidelines.
• This issue affects my Ory Network project.
• I have joined the Ory Community Slack.
• I am signed up to the Ory Security Patch Newsletter.

Describe the bug

When having identities with multiple credential types, the listIdentities endpoint lists identities once per credential type they have set up.

Reproducing the bug

1. Create an identity with a password and setup webauthn
2. Call /admin/identities?credentials_identifier={email_of_the_account}
3. See the same identity listed twice

Relevant log output

No response

Relevant configuration

No response

Version

master

On which operating system are you observing this issue?

None

In which environment are you deploying?

None

Additional Context

[aeneasr]

A select distinct should fix this