WP_Tax_Query::get_sql_clauses() WordPress Method
The WordPress Tax Query is a powerful tool that allows you to create complex SQL queries to retrieve data from the WordPress database. The Tax Query can be used to query any taxonomy, including custom taxonomies. The Tax Query can be used to retrieve data from multiple taxonomies, including child and parent taxonomies. The Tax Query can also be used to retrieve data from multiple terms in a taxonomy.
WP_Tax_Query::get_sql_clauses() #
Generate SQL clauses to be appended to a main query.
Description
Called by the public WP_Tax_Query::get_sql(), this method is abstracted out to maintain parity with the other Query classes.
Return
(string[]) Array containing JOIN and WHERE SQL clauses to append to the main query.
- 'join'
(string) SQL fragment to append to the main JOIN clause. - 'where'
(string) SQL fragment to append to the main WHERE clause.
Source
File: wp-includes/class-wp-tax-query.php
protected function get_sql_clauses() { /* * $queries are passed by reference to get_sql_for_query() for recursion. * To keep $this->queries unaltered, pass a copy. */ $queries = $this->queries; $sql = $this->get_sql_for_query( $queries ); if ( ! empty( $sql['where'] ) ) { $sql['where'] = ' AND ' . $sql['where']; } return $sql; }
Expand full source codeCollapse full source codeView on TracView on GitHub
Changelog
Version | Description |
---|---|
4.1.0 | Introduced. |