Namaste!

Dynamic list with custom query displays this error:

Duplicate key values found in column "Ref".
Unable to display data in a list.

Your query produces result containing records with non-unique value in Ref column.
You should change your query to contain records with unique Refs only.