mer_id = %d",
				array(
					$deleted_text,
					$deleted_text,
					$deleted_text,
					'deleted@site.invalid',
					$deleted_text,
					$deleted_text,
					$deleted_text,
					$customer_id,
				)
			)
		);
		// If the customer row was anonymized, flush the cache.
		if ( $updated ) {
			ReportsCache::invalidate();
		}
	}

	/**
	 * Build location filter SQL clause for includes or excludes.
	 *
	 * @since 10.5.0
	 * @param string $locations_string Comma-separated list of locations (e.g., "US:CA,US:NY,GB").
	 * @param bool   $is_include       True for IN clause, false for NOT IN clause.
	 * @return string SQL WHERE clause condition.
	 */
	protected function build_location_filter_clause( $locations_string, $is_include = true ) {
		$customer_lookup_table = self::get_db_table_name();
		$locations_array       = explode( ',', $locations_string );
		$country_state_pairs   = array();
		$countries             = array();

		foreach ( $locations_array as $location ) {
			$location = trim( $location );
			if ( empty( $location ) ) {
				continue;
			}

			if ( false !== strpos( $location, ':' ) ) {
				$parts = explode( ':', $location );
				if ( 2 === count( $parts ) ) {
					$country_state_pairs[] = array(
						'country' => esc_sql( $parts[0] ),
						'state'   => esc_sql( $parts[1] ),
					);
				}
			} else {
				$countries[] = esc_sql( $location );
			}
		}

		$conditions = array();

		// Build country:state pair conditions.
		if ( ! empty( $country_state_pairs ) ) {
			$pair_conditions = array();
			foreach ( $country_state_pairs as $pair ) {
				if ( $is_include ) {
					$pair_conditions[] = "({$customer_lookup_table}.country = '{$pair['country']}' AND {$customer_lookup_table}.state = '{$pair['state']}')";
				} else {
					$pair_conditions[] = "({$customer_lookup_table}.country != '{$pair['country']}' OR {$customer_lookup_table}.state != '{$pair['state']}')";
				}
			}
			$pair_connector = $is_include ? ' OR ' : ' AND ';
			$conditions[]   = '(' . implode( $pair_connector, $pair_conditions ) . ')';
		}

		// Build country-only conditions.
		if ( ! empty( $countries ) ) {
			$operator     = $is_include ? 'IN' : 'NOT IN';
			$conditions[] = "{$customer_lookup_table}.country {$operator} ('" . implode( "','", $countries ) . "')";
		}

		if ( empty( $conditions ) ) {
			return '';
		}

		// Combine conditions with OR for includes, AND for excludes.
		$connector = $is_include ? ' OR ' : ' AND ';

		return '(' . implode( $connector, $conditions ) . ')';
	}

	/**
	 * Initialize query objects.
	 */
	protected function initialize_queries() {
		$this->clear_all_clauses();
		$table_name     = self::get_db_table_name();
		$this->subquery = new SqlQuery( $this->context . '_subquery' );
		$this->subquery->add_sql_clause( 'from', $table_name );
		$this->subquery->add_sql_clause( 'select', "{$table_name}.customer_id" );
		$this->subquery->add_sql_clause( 'group_by', "{$table_name}.customer_id" );
	}
}