Edit File by line

$sql['join'] = implode( ' ', array_unique( $sql_chunks['join'] ) );

[500] Fix | Delete

}

[501] Fix | Delete

[502] Fix | Delete

// Generate a single WHERE clause with proper brackets and indentation.

[503] Fix | Delete

if ( ! empty( $sql_chunks['where'] ) ) {

[504] Fix | Delete

$sql['where'] = '( ' . "\n " . $indent . implode( ' ' . "\n " . $indent . $relation . ' ' . "\n " . $indent, $sql_chunks['where'] ) . "\n" . $indent . ')';

[505] Fix | Delete

}

[506] Fix | Delete

[507] Fix | Delete

return $sql;

[508] Fix | Delete

}

[509] Fix | Delete

[510] Fix | Delete

/**

[511] Fix | Delete

* Generates SQL JOIN and WHERE clauses for a first-order query clause.

[512] Fix | Delete

[513] Fix | Delete

* "First-order" means that it's an array with a 'key' or 'value'.

[514] Fix | Delete

[515] Fix | Delete

* @since 4.1.0

[516] Fix | Delete

[517] Fix | Delete

* @global wpdb $wpdb WordPress database abstraction object.

[518] Fix | Delete

[519] Fix | Delete

* @param array $clause Query clause (passed by reference).

[520] Fix | Delete

* @param array $parent_query Parent query array.

[521] Fix | Delete

* @param string $clause_key Optional. The array key used to name the clause in the original `$meta_query`

[522] Fix | Delete

* parameters. If not provided, a key will be generated automatically.

[523] Fix | Delete

* Default empty string.

[524] Fix | Delete

* @return array {

[525] Fix | Delete

* Array containing JOIN and WHERE SQL clauses to append to a first-order query.

[526] Fix | Delete

[527] Fix | Delete

* @type string[] $join Array of SQL fragments to append to the main JOIN clause.

[528] Fix | Delete

* @type string[] $where Array of SQL fragments to append to the main WHERE clause.

[529] Fix | Delete

* }

[530] Fix | Delete

[531] Fix | Delete

public function get_sql_for_clause( &$clause, $parent_query, $clause_key = '' ) {

[532] Fix | Delete

global $wpdb;

[533] Fix | Delete

[534] Fix | Delete

$sql_chunks = array(

[535] Fix | Delete

'where' => array(),

[536] Fix | Delete

'join' => array(),

[537] Fix | Delete

);

[538] Fix | Delete

[539] Fix | Delete

if ( isset( $clause['compare'] ) ) {

[540] Fix | Delete

$clause['compare'] = strtoupper( $clause['compare'] );

[541] Fix | Delete

} else {

[542] Fix | Delete

$clause['compare'] = isset( $clause['value'] ) && is_array( $clause['value'] ) ? 'IN' : '=';

[543] Fix | Delete

}

[544] Fix | Delete

[545] Fix | Delete

$non_numeric_operators = array(

[546] Fix | Delete

'=',

[547] Fix | Delete

'!=',

[548] Fix | Delete

'LIKE',

[549] Fix | Delete

'NOT LIKE',

[550] Fix | Delete

'IN',

[551] Fix | Delete

'NOT IN',

[552] Fix | Delete

'EXISTS',

[553] Fix | Delete

'NOT EXISTS',

[554] Fix | Delete

'RLIKE',

[555] Fix | Delete

'REGEXP',

[556] Fix | Delete

'NOT REGEXP',

[557] Fix | Delete

);

[558] Fix | Delete

[559] Fix | Delete

$numeric_operators = array(

[560] Fix | Delete

'>',

[561] Fix | Delete

'>=',

[562] Fix | Delete

'<',

[563] Fix | Delete

'<=',

[564] Fix | Delete

'BETWEEN',

[565] Fix | Delete

'NOT BETWEEN',

[566] Fix | Delete

);

[567] Fix | Delete

[568] Fix | Delete

if ( ! in_array( $clause['compare'], $non_numeric_operators, true ) && ! in_array( $clause['compare'], $numeric_operators, true ) ) {

[569] Fix | Delete

$clause['compare'] = '=';

[570] Fix | Delete

}

[571] Fix | Delete

[572] Fix | Delete

if ( isset( $clause['compare_key'] ) ) {

[573] Fix | Delete

$clause['compare_key'] = strtoupper( $clause['compare_key'] );

[574] Fix | Delete

} else {

[575] Fix | Delete

$clause['compare_key'] = isset( $clause['key'] ) && is_array( $clause['key'] ) ? 'IN' : '=';

[576] Fix | Delete

}

[577] Fix | Delete

[578] Fix | Delete

if ( ! in_array( $clause['compare_key'], $non_numeric_operators, true ) ) {

[579] Fix | Delete

$clause['compare_key'] = '=';

[580] Fix | Delete

}

[581] Fix | Delete

[582] Fix | Delete

$meta_compare = $clause['compare'];

[583] Fix | Delete

$meta_compare_key = $clause['compare_key'];

[584] Fix | Delete

[585] Fix | Delete

// First build the JOIN clause, if one is required.

[586] Fix | Delete

$join = '';

[587] Fix | Delete

[588] Fix | Delete

// We prefer to avoid joins if possible. Look for an existing join compatible with this clause.

[589] Fix | Delete

$alias = $this->find_compatible_table_alias( $clause, $parent_query );

[590] Fix | Delete

if ( false === $alias ) {

[591] Fix | Delete

$i = count( $this->table_aliases );

[592] Fix | Delete

$alias = $i ? 'mt' . $i : $this->meta_table;

[593] Fix | Delete

[594] Fix | Delete

// JOIN clauses for NOT EXISTS have their own syntax.

[595] Fix | Delete

if ( 'NOT EXISTS' === $meta_compare ) {

[596] Fix | Delete

$join .= " LEFT JOIN $this->meta_table";

[597] Fix | Delete

$join .= $i ? " AS $alias" : '';

[598] Fix | Delete

[599] Fix | Delete

if ( 'LIKE' === $meta_compare_key ) {

[600] Fix | Delete

$join .= $wpdb->prepare( " ON ( $this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column AND $alias.meta_key LIKE %s )", '%' . $wpdb->esc_like( $clause['key'] ) . '%' );

[601] Fix | Delete

} else {

[602] Fix | Delete

$join .= $wpdb->prepare( " ON ( $this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column AND $alias.meta_key = %s )", $clause['key'] );

[603] Fix | Delete

}

[604] Fix | Delete

[605] Fix | Delete

// All other JOIN clauses.

[606] Fix | Delete

} else {

[607] Fix | Delete

$join .= " INNER JOIN $this->meta_table";

[608] Fix | Delete

$join .= $i ? " AS $alias" : '';

[609] Fix | Delete

$join .= " ON ( $this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column )";

[610] Fix | Delete

}

[611] Fix | Delete

[612] Fix | Delete

$this->table_aliases[] = $alias;

[613] Fix | Delete

$sql_chunks['join'][] = $join;

[614] Fix | Delete

}

[615] Fix | Delete

[616] Fix | Delete

// Save the alias to this clause, for future siblings to find.

[617] Fix | Delete

$clause['alias'] = $alias;

[618] Fix | Delete

[619] Fix | Delete

// Determine the data type.

[620] Fix | Delete

$_meta_type = isset( $clause['type'] ) ? $clause['type'] : '';

[621] Fix | Delete

$meta_type = $this->get_cast_for_type( $_meta_type );

[622] Fix | Delete

$clause['cast'] = $meta_type;

[623] Fix | Delete

[624] Fix | Delete

// Fallback for clause keys is the table alias. Key must be a string.

[625] Fix | Delete

if ( is_int( $clause_key ) || ! $clause_key ) {

[626] Fix | Delete

$clause_key = $clause['alias'];

[627] Fix | Delete

}

[628] Fix | Delete

[629] Fix | Delete

// Ensure unique clause keys, so none are overwritten.

[630] Fix | Delete

$iterator = 1;

[631] Fix | Delete

$clause_key_base = $clause_key;

[632] Fix | Delete

while ( isset( $this->clauses[ $clause_key ] ) ) {

[633] Fix | Delete

$clause_key = $clause_key_base . '-' . $iterator;

[634] Fix | Delete

++$iterator;

[635] Fix | Delete

}

[636] Fix | Delete

[637] Fix | Delete

// Store the clause in our flat array.

[638] Fix | Delete

$this->clauses[ $clause_key ] =& $clause;

[639] Fix | Delete

[640] Fix | Delete

// Next, build the WHERE clause.

[641] Fix | Delete

[642] Fix | Delete

// meta_key.

[643] Fix | Delete

if ( array_key_exists( 'key', $clause ) ) {

[644] Fix | Delete

if ( 'NOT EXISTS' === $meta_compare ) {

[645] Fix | Delete

$sql_chunks['where'][] = $alias . '.' . $this->meta_id_column . ' IS NULL';

[646] Fix | Delete

} else {

[647] Fix | Delete

/**

[648] Fix | Delete

* In joined clauses negative operators have to be nested into a

[649] Fix | Delete

* NOT EXISTS clause and flipped, to avoid returning records with

[650] Fix | Delete

* matching post IDs but different meta keys. Here we prepare the

[651] Fix | Delete

* nested clause.

[652] Fix | Delete

[653] Fix | Delete

if ( in_array( $meta_compare_key, array( '!=', 'NOT IN', 'NOT LIKE', 'NOT EXISTS', 'NOT REGEXP' ), true ) ) {

[654] Fix | Delete

// Negative clauses may be reused.

[655] Fix | Delete

$i = count( $this->table_aliases );

[656] Fix | Delete

$subquery_alias = $i ? 'mt' . $i : $this->meta_table;

[657] Fix | Delete

$this->table_aliases[] = $subquery_alias;

[658] Fix | Delete

[659] Fix | Delete

$meta_compare_string_start = 'NOT EXISTS (';

[660] Fix | Delete

$meta_compare_string_start .= "SELECT 1 FROM $wpdb->postmeta $subquery_alias ";

[661] Fix | Delete

$meta_compare_string_start .= "WHERE $subquery_alias.post_ID = $alias.post_ID ";

[662] Fix | Delete

$meta_compare_string_end = 'LIMIT 1';

[663] Fix | Delete

$meta_compare_string_end .= ')';

[664] Fix | Delete

}

[665] Fix | Delete

[666] Fix | Delete

switch ( $meta_compare_key ) {

[667] Fix | Delete

case '=':

[668] Fix | Delete

case 'EXISTS':

[669] Fix | Delete

$where = $wpdb->prepare( "$alias.meta_key = %s", trim( $clause['key'] ) ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[670] Fix | Delete

break;

[671] Fix | Delete

case 'LIKE':

[672] Fix | Delete

$meta_compare_value = '%' . $wpdb->esc_like( trim( $clause['key'] ) ) . '%';

[673] Fix | Delete

$where = $wpdb->prepare( "$alias.meta_key LIKE %s", $meta_compare_value ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[674] Fix | Delete

break;

[675] Fix | Delete

case 'IN':

[676] Fix | Delete

$meta_compare_string = "$alias.meta_key IN (" . substr( str_repeat( ',%s', count( $clause['key'] ) ), 1 ) . ')';

[677] Fix | Delete

$where = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[678] Fix | Delete

break;

[679] Fix | Delete

case 'RLIKE':

[680] Fix | Delete

case 'REGEXP':

[681] Fix | Delete

$operator = $meta_compare_key;

[682] Fix | Delete

if ( isset( $clause['type_key'] ) && 'BINARY' === strtoupper( $clause['type_key'] ) ) {

[683] Fix | Delete

$cast = 'BINARY';

[684] Fix | Delete

$meta_key = "CAST($alias.meta_key AS BINARY)";

[685] Fix | Delete

} else {

[686] Fix | Delete

$cast = '';

[687] Fix | Delete

$meta_key = "$alias.meta_key";

[688] Fix | Delete

}

[689] Fix | Delete

$where = $wpdb->prepare( "$meta_key $operator $cast %s", trim( $clause['key'] ) ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared

[690] Fix | Delete

break;

[691] Fix | Delete

[692] Fix | Delete

case '!=':

[693] Fix | Delete

case 'NOT EXISTS':

[694] Fix | Delete

$meta_compare_string = $meta_compare_string_start . "AND $subquery_alias.meta_key = %s " . $meta_compare_string_end;

[695] Fix | Delete

$where = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[696] Fix | Delete

break;

[697] Fix | Delete

case 'NOT LIKE':

[698] Fix | Delete

$meta_compare_string = $meta_compare_string_start . "AND $subquery_alias.meta_key LIKE %s " . $meta_compare_string_end;

[699] Fix | Delete

[700] Fix | Delete

$meta_compare_value = '%' . $wpdb->esc_like( trim( $clause['key'] ) ) . '%';

[701] Fix | Delete

$where = $wpdb->prepare( $meta_compare_string, $meta_compare_value ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[702] Fix | Delete

break;

[703] Fix | Delete

case 'NOT IN':

[704] Fix | Delete

$array_subclause = '(' . substr( str_repeat( ',%s', count( $clause['key'] ) ), 1 ) . ') ';

[705] Fix | Delete

$meta_compare_string = $meta_compare_string_start . "AND $subquery_alias.meta_key IN " . $array_subclause . $meta_compare_string_end;

[706] Fix | Delete

$where = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[707] Fix | Delete

break;

[708] Fix | Delete

case 'NOT REGEXP':

[709] Fix | Delete

$operator = $meta_compare_key;

[710] Fix | Delete

if ( isset( $clause['type_key'] ) && 'BINARY' === strtoupper( $clause['type_key'] ) ) {

[711] Fix | Delete

$cast = 'BINARY';

[712] Fix | Delete

$meta_key = "CAST($subquery_alias.meta_key AS BINARY)";

[713] Fix | Delete

} else {

[714] Fix | Delete

$cast = '';

[715] Fix | Delete

$meta_key = "$subquery_alias.meta_key";

[716] Fix | Delete

}

[717] Fix | Delete

[718] Fix | Delete

$meta_compare_string = $meta_compare_string_start . "AND $meta_key REGEXP $cast %s " . $meta_compare_string_end;

[719] Fix | Delete

$where = $wpdb->prepare( $meta_compare_string, $clause['key'] ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared

[720] Fix | Delete

break;

[721] Fix | Delete

}

[722] Fix | Delete

[723] Fix | Delete

$sql_chunks['where'][] = $where;

[724] Fix | Delete

}

[725] Fix | Delete

}

[726] Fix | Delete

[727] Fix | Delete

// meta_value.

[728] Fix | Delete

if ( array_key_exists( 'value', $clause ) ) {

[729] Fix | Delete

$meta_value = $clause['value'];

[730] Fix | Delete

[731] Fix | Delete

if ( in_array( $meta_compare, array( 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' ), true ) ) {

[732] Fix | Delete

if ( ! is_array( $meta_value ) ) {

[733] Fix | Delete

$meta_value = preg_split( '/[,\s]+/', $meta_value );

[734] Fix | Delete

}

[735] Fix | Delete

} elseif ( is_string( $meta_value ) ) {

[736] Fix | Delete

$meta_value = trim( $meta_value );

[737] Fix | Delete

}

[738] Fix | Delete

[739] Fix | Delete

switch ( $meta_compare ) {

[740] Fix | Delete

case 'IN':

[741] Fix | Delete

case 'NOT IN':

[742] Fix | Delete

$meta_compare_string = '(' . substr( str_repeat( ',%s', count( $meta_value ) ), 1 ) . ')';

[743] Fix | Delete

$where = $wpdb->prepare( $meta_compare_string, $meta_value );

[744] Fix | Delete

break;

[745] Fix | Delete

[746] Fix | Delete

case 'BETWEEN':

[747] Fix | Delete

case 'NOT BETWEEN':

[748] Fix | Delete

$where = $wpdb->prepare( '%s AND %s', $meta_value[0], $meta_value[1] );

[749] Fix | Delete

break;

[750] Fix | Delete

[751] Fix | Delete

case 'LIKE':

[752] Fix | Delete

case 'NOT LIKE':

[753] Fix | Delete

$meta_value = '%' . $wpdb->esc_like( $meta_value ) . '%';

[754] Fix | Delete

$where = $wpdb->prepare( '%s', $meta_value );

[755] Fix | Delete

break;

[756] Fix | Delete

[757] Fix | Delete

// EXISTS with a value is interpreted as '='.

[758] Fix | Delete

case 'EXISTS':

[759] Fix | Delete

$meta_compare = '=';

[760] Fix | Delete

$where = $wpdb->prepare( '%s', $meta_value );

[761] Fix | Delete

break;

[762] Fix | Delete

[763] Fix | Delete

// 'value' is ignored for NOT EXISTS.

[764] Fix | Delete

case 'NOT EXISTS':

[765] Fix | Delete

$where = '';

[766] Fix | Delete

break;

[767] Fix | Delete

[768] Fix | Delete

default:

[769] Fix | Delete

$where = $wpdb->prepare( '%s', $meta_value );

[770] Fix | Delete

break;

[771] Fix | Delete

[772] Fix | Delete

}

[773] Fix | Delete

[774] Fix | Delete

if ( $where ) {

[775] Fix | Delete

if ( 'CHAR' === $meta_type ) {

[776] Fix | Delete

$sql_chunks['where'][] = "$alias.meta_value {$meta_compare} {$where}";

[777] Fix | Delete

} else {

[778] Fix | Delete

$sql_chunks['where'][] = "CAST($alias.meta_value AS {$meta_type}) {$meta_compare} {$where}";

[779] Fix | Delete

}

[780] Fix | Delete

}

[781] Fix | Delete

}

[782] Fix | Delete

[783] Fix | Delete

[784] Fix | Delete

* Multiple WHERE clauses (for meta_key and meta_value) should

[785] Fix | Delete

* be joined in parentheses.

[786] Fix | Delete

[787] Fix | Delete

if ( 1 < count( $sql_chunks['where'] ) ) {

[788] Fix | Delete

$sql_chunks['where'] = array( '( ' . implode( ' AND ', $sql_chunks['where'] ) . ' )' );

[789] Fix | Delete

}

[790] Fix | Delete

[791] Fix | Delete

return $sql_chunks;

[792] Fix | Delete

}

[793] Fix | Delete

[794] Fix | Delete

/**

[795] Fix | Delete

* Gets a flattened list of sanitized meta clauses.

[796] Fix | Delete

[797] Fix | Delete

* This array should be used for clause lookup, as when the table alias and CAST type must be determined for

[798] Fix | Delete

* a value of 'orderby' corresponding to a meta clause.

[799] Fix | Delete

[800] Fix | Delete

* @since 4.2.0

[801] Fix | Delete

[802] Fix | Delete

* @return array Meta clauses.

[803] Fix | Delete

[804] Fix | Delete

public function get_clauses() {

[805] Fix | Delete

return $this->clauses;

[806] Fix | Delete

}

[807] Fix | Delete

[808] Fix | Delete

/**

[809] Fix | Delete

* Identifies an existing table alias that is compatible with the current

[810] Fix | Delete

* query clause.

[811] Fix | Delete

[812] Fix | Delete

* We avoid unnecessary table joins by allowing each clause to look for

[813] Fix | Delete

* an existing table alias that is compatible with the query that it

[814] Fix | Delete

* needs to perform.

[815] Fix | Delete

[816] Fix | Delete

* An existing alias is compatible if (a) it is a sibling of `$clause`

[817] Fix | Delete

* (ie, it's under the scope of the same relation), and (b) the combination

[818] Fix | Delete

* of operator and relation between the clauses allows for a shared table join.

[819] Fix | Delete

* In the case of WP_Meta_Query, this only applies to 'IN' clauses that are

[820] Fix | Delete

* connected by the relation 'OR'.

[821] Fix | Delete

[822] Fix | Delete

* @since 4.1.0

[823] Fix | Delete

[824] Fix | Delete

* @param array $clause Query clause.

[825] Fix | Delete

* @param array $parent_query Parent query of $clause.

[826] Fix | Delete

* @return string|false Table alias if found, otherwise false.

[827] Fix | Delete

[828] Fix | Delete

protected function find_compatible_table_alias( $clause, $parent_query ) {

[829] Fix | Delete

$alias = false;

[830] Fix | Delete

[831] Fix | Delete

foreach ( $parent_query as $sibling ) {

[832] Fix | Delete

// If the sibling has no alias yet, there's nothing to check.

[833] Fix | Delete

if ( empty( $sibling['alias'] ) ) {

[834] Fix | Delete

continue;

[835] Fix | Delete

}

[836] Fix | Delete

[837] Fix | Delete

// We're only interested in siblings that are first-order clauses.

[838] Fix | Delete

if ( ! is_array( $sibling ) || ! $this->is_first_order_clause( $sibling ) ) {

[839] Fix | Delete

continue;

[840] Fix | Delete

}

[841] Fix | Delete

[842] Fix | Delete

$compatible_compares = array();

[843] Fix | Delete

[844] Fix | Delete

// Clauses connected by OR can share joins as long as they have "positive" operators.

[845] Fix | Delete

if ( 'OR' === $parent_query['relation'] ) {

[846] Fix | Delete

$compatible_compares = array( '=', 'IN', 'BETWEEN', 'LIKE', 'REGEXP', 'RLIKE', '>', '>=', '<', '<=' );

[847] Fix | Delete

[848] Fix | Delete

// Clauses joined by AND with "negative" operators share a join only if they also share a key.

[849] Fix | Delete

} elseif ( isset( $sibling['key'] ) && isset( $clause['key'] ) && $sibling['key'] === $clause['key'] ) {

[850] Fix | Delete

$compatible_compares = array( '!=', 'NOT IN', 'NOT LIKE' );

[851] Fix | Delete

}

[852] Fix | Delete

[853] Fix | Delete

$clause_compare = strtoupper( $clause['compare'] );

[854] Fix | Delete

$sibling_compare = strtoupper( $sibling['compare'] );

[855] Fix | Delete

if ( in_array( $clause_compare, $compatible_compares, true ) && in_array( $sibling_compare, $compatible_compares, true ) ) {

[856] Fix | Delete

$alias = preg_replace( '/\W/', '_', $sibling['alias'] );

[857] Fix | Delete

break;

[858] Fix | Delete

}

[859] Fix | Delete

}

[860] Fix | Delete

[861] Fix | Delete

/**

[862] Fix | Delete

* Filters the table alias identified as compatible with the current clause.

[863] Fix | Delete

[864] Fix | Delete

* @since 4.1.0

[865] Fix | Delete

[866] Fix | Delete

* @param string|false $alias Table alias, or false if none was found.

[867] Fix | Delete

* @param array $clause First-order query clause.

[868] Fix | Delete

* @param array $parent_query Parent of $clause.

[869] Fix | Delete

* @param WP_Meta_Query $query WP_Meta_Query object.

[870] Fix | Delete

[871] Fix | Delete

return apply_filters( 'meta_query_find_compatible_table_alias', $alias, $clause, $parent_query, $this );

[872] Fix | Delete

}

[873] Fix | Delete

[874] Fix | Delete

/**

[875] Fix | Delete

* Checks whether the current query has any OR relations.

[876] Fix | Delete

[877] Fix | Delete

* In some cases, the presence of an OR relation somewhere in the query will require

[878] Fix | Delete

* the use of a `DISTINCT` or `GROUP BY` keyword in the `SELECT` clause. The current

[879] Fix | Delete

* method can be used in these cases to determine whether such a clause is necessary.

[880] Fix | Delete

[881] Fix | Delete

* @since 4.3.0

[882] Fix | Delete

[883] Fix | Delete

* @return bool True if the query contains any `OR` relations, otherwise false.

[884] Fix | Delete

[885] Fix | Delete

public function has_or_relation() {

[886] Fix | Delete

return $this->has_or_relation;

[887] Fix | Delete

}

[888] Fix | Delete

}

[889] Fix | Delete

[890] Fix | Delete