« Return to Thread: Getting double/triple posts listed on some blogs

Re: Getting double/triple posts listed on some blogs

by Michael C. Duterte :: Rate this Message:

Reply to Author | View in Thread

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.
_______________________________________________
wp-hackers mailing list
wp-hackers@...
http://lists.automattic.com/mailman/listinfo/wp-hackers

 « Return to Thread: Getting double/triple posts listed on some blogs