[wp-trac] [WordPress Trac] #14765: SQL Error filtering posts by category from admin (edit.php)

[WordPress Trac]

#14765: SQL Error filtering posts by category from admin (edit.php)
------------------------------+---------------------------------------------
 Reporter:  EduardRoccatello  |       Owner:                      
     Type:  defect (bug)      |      Status:  new                 
 Priority:  normal            |   Milestone:  Awaiting Review     
Component:  Query             |     Version:  3.0.1               
 Severity:  major             |    Keywords:  query,category,posts
------------------------------+---------------------------------------------
 Hello,

 I'm facing this issue with WP 3.0.1.
 I've no plugins installed but I've custom post types.

 SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN
 wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
 INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id =
 wp_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND wp_term_taxonomy.taxonomy
 = 'category' AND wp_term_taxonomy.term_id IN ('5') AND wp_posts.post_type
 = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status =
 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status =
 'pending' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER
 BY wp_posts.post_date DESC LIMIT 0, 20

 Removing GROUP BY wp_posts.ID the query works in PhpMyAdmin.
 Any hint?

 Feel free to ask me for details if needed!!!
 Thanks!

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14765>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software