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

[Knut-Olav Hoven]

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.


-- 
Knut-Olav Hoven
Linpro AS                    http://www.linpro.no/