term_taxonomy_table = $term_taxonomy_table_alias ? $term_taxonomy_table_alias : $wpdb->term_taxonomy; } /** * If "display as translated" mode is enabled, we check whether a category has some assigned posts or * its equivalent in the default language. * * @param array $clauses * @param string $default_lang * * @return array */ public function update_count( $clauses, $default_lang ) { $clauses['fields'] = $this->update_count_in_fields( $clauses['fields'], $default_lang ); $clauses['where'] = $this->update_count_in_where( $clauses['where'], $default_lang ); return $clauses; } private function update_count_in_fields( $fields, $default_lang ) { $sql = " tt.*, GREATEST( tt.count, ( SELECT term_taxonomy.count FROM {$this->wpdb->term_taxonomy} term_taxonomy INNER JOIN {$this->wpdb->prefix}icl_translations translations ON translations.element_id = term_taxonomy.term_taxonomy_id WHERE translations.trid = icl_t.trid AND translations.language_code = %s ) ) as `count` "; /** @var string $sql */ $sql = $this->wpdb->prepare( $sql, $default_lang ); return str_replace( 'tt.*', $sql, $fields ); } private function update_count_in_where( $where, $default_lang ) { $sql = " ( tt.count > 0 OR ( SELECT term_taxonomy.count FROM {$this->wpdb->term_taxonomy} term_taxonomy INNER JOIN {$this->wpdb->prefix}icl_translations translations ON translations.element_id = term_taxonomy.term_taxonomy_id WHERE translations.trid = icl_t.trid AND translations.language_code = %s ) > 0 ) "; /** @var string @sql */ $sql = $this->wpdb->prepare( $sql, $default_lang ); return str_replace( 'tt.count > 0', $sql, $where ); } /** * @param array $taxonomies * * @return string */ protected function get_content_types_query( $taxonomies ) { $taxonomies = wpml_prepare_in( $taxonomies ); return "{$this->term_taxonomy_table}.taxonomy IN ( {$taxonomies} )"; } /** * @param string $language * * @return string */ protected function get_query_for_translation_not_published( $language ) { return '0'; } }