[wp-trac] [WordPress Trac] #16703: Post permalinks that include %category% should not query the category

[WordPress Trac]

#16703: Post permalinks that include %category% should not query the category
--------------------------+--------------------
 Reporter:  ryan          |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  3.1.1
Component:  Query         |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+--------------------

Comment (by ryan):

 3.0 query when resolving /%category%/%postname%/:

 {{{
 SELECT wp_30_posts.* FROM wp_30_posts WHERE 1=1 AND wp_30_posts.post_name
 = 'an-event' AND wp_30_posts.post_type = 'post' ORDER BY
 wp_30_posts.post_date DESC
 }}}

 3.1 query:

 {{{
 SELECT wp_trunk_posts.* FROM wp_trunk_posts INNER JOIN
 wp_trunk_term_relationships ON (wp_trunk_posts.ID =
 wp_trunk_term_relationships.object_id) WHERE 1=1 AND
 wp_trunk_posts.post_name = 'an-event' AND (
 wp_trunk_term_relationships.term_taxonomy_id IN (3) ) AND
 wp_trunk_posts.post_type = 'post' GROUP BY wp_trunk_posts.ID ORDER BY
 wp_trunk_posts.post_date DESC
 }}}

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