Changeset 10599

Timestamp:

02/19/2009 07:17:22 PM (17 years ago)

Author:

ryan

Message:

Use group by for meta key queries. Props filosofo. fixes #9167 for 2.7

File:

• branches/2.7/wp-includes/query.php (modified) (2 diffs)

branches/2.7/wp-includes/query.php

@@ -1791 +1791 @@
 
         if ( !empty($q['category__in']) ) {
-            $groupby = "{$wpdb->posts}.ID";
-        }
-
-        if ( !empty($q['category__in']) ) {
             $join = " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ";
             $whichcat .= " AND $wpdb->term_taxonomy.taxonomy = 'category' ";
@@ -1870 +1866 @@
         }
 
-        if ( !empty($q['tag__in']) || !empty($q['tag_slug__in']) ) {
+        if ( !empty($q['category__in']) || !empty($q['meta_key']) || !empty($q['tag__in']) || !empty($q['tag_slug__in']) ) {
             $groupby = "{$wpdb->posts}.ID";
         }