How do I remove duplicates when using the random sort? I have created a view where I am displaying the the node title and a logo (a cck field). In the arguments I have passed the taxonomy term name.

In the result a node is displaying 2 or 3 times; I already checked the distinct checkbox in the Query settings but that also does not work. I have used the random sort, which seems to cause the duplicates; when I remove the random sort, it works fine.

How can I avoid the duplicates without disabling the random sort?
The simple way to achieve distinct values in a view is to make the following:


Go and edit your view
In Advanced » OTHER section click on "Query setting"
Check "Distinct" check-box.