Need Nodes to Appear Only Once
You can apply GROUP BY or DISTINCT by enabling views aggregation settings to remove duplicate records.


Go and edit your view
In Advanced » OTHER section by enabling Use aggregation: Yes
In FIELDS or FILTER CRITERIA section, select and apply Aggregation settings for which fields you want to group by or distinct.