[wp-hackers] Getting double/triple posts listed on some blogs

[Michael C. Duterte]

Knut-Olav Hoven wrote:
> On Wednesday 07 February 2007 15:47, Michael C. Duterte wrote:
>   
>> Hi Guys,
>>
>> Need some help with a sql that is being generated after a plugin adds a
>> join and a where clause. On some systems, the sql below is somehow
>> causing WordPress to list double or triple (duplicate) posts but it
>> works perfectly on most systems. I'm stumped, can somebody give any
>> clues as to why this is happening?
>>     
>
> The same happended to me with WordPress 2.1.
>
> You might use the filter hook 'posts_distinct' and return 'DISTINCT', without 
> quotes, from the callback function.
>
>
>   

That fixed it. Didn't know that hook exists, thanks a lot.