[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 ryan):

 It's a back compat break, which sucks, but removing those speeds up our
 queries.

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