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

[Michael C. Duterte]

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?

|SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN 
wp_postmeta AS _plug_join ON wp_posts.ID = _plug_join.post_id AND 
_plug_join.meta_key = '_plug_access' WHERE 1=1 AND (post_type = 'post' 
AND (post_status = 'publish')) AND _plug_join.meta_value != 'P' ORDER BY 
post_date DESC LIMIT 0, 10|


Thanks,
Mike