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

 get_tax_sql() does this:

 {{{
 SELECT object_id
 FROM wp_trunk_term_relationships
 INNER JOIN wp_trunk_term_taxonomy USING (term_taxonomy_id)
 WHERE taxonomy IN ('category')
 AND term_id NOT IN (21072,37613,4533907)
 }}}

 That query is unlimited despite the original request being for only 15
 posts.  This won't scale.

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