[wp-hackers] Getting double/triple posts listed on some blogs
Michael C. Duterte
mhykhh at gmail.com
Wed Feb 7 14:47:46 GMT 2007
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|
More information about the wp-hackers