The following should work to bring back a single ID for each. Would recommend indexes on parentCode + internalReference and internalReference if not already present.

SELECT MIN(c.ID) AS ID,

...

Have you tried the DENSE_RANK() function? It's called exactly the same way as ROW_NUMBER() and should sort your problem.