Build a MySQL query

Given a sample list of utf8 string values of a table, through an efficient MySQL query, I'd like to obtain the distinct records that repeat the combination of some fields while having a different combination of other fields.
Must see the attachment for more details.
Bid only if you are really good at building efficient SQL queries.