SQL Duplicate Email Address on Site > Communication > Contacts

Hi, we have a problem with how our Custom Invoice Print (basically RAXINV) deals with duplicate emails in the Communications tab.

Basically it doesn't.

Our AR team know not to duplicate email addresses but they continue to add them

I need some SQL to locate these

I have tried to write some but it was not great & I ended up dumping it in excel and wtriting if statements against it

Does someone have anyting up their sleeves they could pass on?

Would be really grateful

There is an example of one of the problem customers in the attached

Thanks in advance, David