[wp-trac] Re: [WordPress Trac] #3681: Lack of forced GROUP BY or DISTINCT in query.php causes duplicate posts when plugins JOIN on wp_posts.ID = wp_post2cat.post_id

[WordPress Trac]

#3681: Lack of forced GROUP BY or DISTINCT in query.php causes duplicate posts
when plugins JOIN on wp_posts.ID = wp_post2cat.post_id
---------------------+------------------------------------------------------
 Reporter:  ajd777   |        Owner:  ryan
     Type:  defect   |       Status:  new 
 Priority:  high     |    Milestone:      
Component:  General  |      Version:  2.1 
 Severity:  major    |   Resolution:      
 Keywords:           |  
---------------------+------------------------------------------------------
Comment (by ajd777):

 I think it should be done automatically in the core, but allow it to be
 removed if needed: mainly because it is rather unexpected for multiple of
 the same posts to show up by default.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3681#comment:3>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software