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


Top ↑

Parameters Parameters

$tax_query

(array) (Required) A compact tax query

$primary_table

(string) (Required)

$primary_id_column

(string) (Required)


Top ↑

Return Return

(array)


Top ↑

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


Top ↑

Changelog Changelog

Changelog
Version Description
3.1.0 Introduced.

Top ↑

User Contributed Notes User Contributed Notes

  1. Skip to note 1 content
    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) )
    )

You must log in before being able to contribute a note or feedback.