Question

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

---

参数

$tax_query

(array) (Required) A compact tax query

$primary_table

(string) (Required)

$primary_id_column

(string) (Required)

---

返回值

(array)

---

源代码

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 );
}

---

更新日志

Version	description
3.1.0	Introduced.

---

相关函数

Uses

• wp-includes/class-wp-tax-query.php: WP_Tax_Query::__construct()

---

User Contributed Notes

1. Skip to note content You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note Contributed by Codex

   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) )
   )