[wp-trac] [WordPress Trac] #12891: Advanced multi-taxonomy WP_Query()s

[WordPress Trac]

#12891: Advanced multi-taxonomy WP_Query()s
----------------------------+-----------------------------------------------
 Reporter:  markjaquith     |       Owner:  markjaquith    
     Type:  task (blessed)  |      Status:  assigned       
 Priority:  normal          |   Milestone:  3.1            
Component:  Query           |     Version:  3.0.1          
 Severity:  normal          |    Keywords:  ongoing-project
----------------------------+-----------------------------------------------

Comment(by foofy):

 The subquery for NOT IN added in r12891 is not quite right as it includes
 posts with the excluded terms so long as the post has other terms that are
 not excluded. I moved the NOT in front of the subquery and MySQL shows
 that either way it scans the same number of rows.

 {{{
 $where .= " AND $primary_table.$primary_id_column NOT IN (
         SELECT object_id
         FROM $wpdb->term_relationships
         WHERE term_taxonomy_id IN ($terms)
 )";
 }}}

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/12891#comment:129>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software