get_tax_sql( array $tax_query, string $primary_table, string $primary_id_column )
Given a taxonomy query, generates SQL to be appended to a main query.
Description Description
See also See also
Parameters Parameters
- $tax_query
-
(array) (Required) A compact tax query
- $primary_table
-
(string) (Required)
- $primary_id_column
-
(string) (Required)
Return Return
(array)
Source Source
File: wp-includes/taxonomy.php
function get_tax_sql( $tax_query, $primary_table, $primary_id_column ) {
$tax_query_obj = new WP_Tax_Query( $tax_query );
return $tax_query_obj->get_sql( $primary_table, $primary_id_column );
}
Expand full source code Collapse full source code View on Trac
Changelog Changelog
| Version | Description |
|---|---|
| 3.1.0 | Introduced. |
User Contributed Notes User Contributed Notes
You must log in before being able to contribute a note or feedback.
Get SQL query part for taxonomy
$tax_query = array( array( 'taxonomy' => 'category', 'field' => 'slug', 'terms' => array( 'cat-a', 'cat-b' ), ) ); global $wpdb; $tax_sql = get_tax_sql( $tax_query, $wpdb->posts, 'ID' );Output would be something like:
Array ( [join] => INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) [where] => AND ( wp_term_relationships.term_taxonomy_id IN (3,4,10,19,25,95) ) )