Changeset 37184 for trunk/src/wp-includes/class-wp-tax-query.php

Timestamp:

04/12/2016 08:36:31 PM (9 years ago)

Author:

boonebgorges

Message:

Use LEFT JOIN when building WP_Tax_Query SQL.

LEFT JOIN ensures that NOT EXISTS queries will not miss posts that have
no taxonomy data whatsoever.

Props swissspidy, crstauf.
Fixes #36343.

File:

• trunk/src/wp-includes/class-wp-tax-query.php (modified) (1 diff)

trunk/src/wp-includes/class-wp-tax-query.php

@@ -441 +441 @@
                 $clause['alias'] = $alias;
 
-                $join .= " INNER JOIN $wpdb->term_relationships";
+                $join .= " LEFT JOIN $wpdb->term_relationships";
                 $join .= $i ? " AS $alias" : '';
                 $join .= " ON ($this->primary_table.$this->primary_id_column = $alias.object_id)";