Problems with SQL Syntax using Left Join and OR
The answer it appears is to use the GROUP BY statement in my SQL right after the WHERE clauses. So, the following:

GROUP BY rn.entity_id, rn.field_resource_name_value


The returns just one entry for each field resource name.