[ Index ]

PHP Cross Reference of WordPress Trunk (Updated Daily)

Search

title

Body

[close]

/wp-includes/ -> class-wp-query.php (source)

   1  <?php
   2  /**
   3   * Query API: WP_Query class
   4   *
   5   * @package WordPress
   6   * @subpackage Query
   7   * @since 4.7.0
   8   */
   9  
  10  /**
  11   * The WordPress Query class.
  12   *
  13   * @link https://developer.wordpress.org/reference/classes/wp_query/
  14   *
  15   * @since 1.5.0
  16   * @since 4.5.0 Removed the `$comments_popup` property.
  17   */
  18  #[AllowDynamicProperties]
  19  class WP_Query {
  20  
  21      /**
  22       * Query vars set by the user.
  23       *
  24       * @since 1.5.0
  25       * @var array
  26       */
  27      public $query;
  28  
  29      /**
  30       * Query vars, after parsing.
  31       *
  32       * @since 1.5.0
  33       * @var array
  34       */
  35      public $query_vars = array();
  36  
  37      /**
  38       * Taxonomy query, as passed to get_tax_sql().
  39       *
  40       * @since 3.1.0
  41       * @var WP_Tax_Query|null A taxonomy query instance.
  42       */
  43      public $tax_query;
  44  
  45      /**
  46       * Metadata query container.
  47       *
  48       * @since 3.2.0
  49       * @var WP_Meta_Query A meta query instance.
  50       */
  51      public $meta_query = false;
  52  
  53      /**
  54       * Date query container.
  55       *
  56       * @since 3.7.0
  57       * @var WP_Date_Query A date query instance.
  58       */
  59      public $date_query = false;
  60  
  61      /**
  62       * Holds the data for a single object that is queried.
  63       *
  64       * Holds the contents of a post, page, category, attachment.
  65       *
  66       * @since 1.5.0
  67       * @var WP_Term|WP_Post_Type|WP_Post|WP_User|null
  68       */
  69      public $queried_object;
  70  
  71      /**
  72       * The ID of the queried object.
  73       *
  74       * @since 1.5.0
  75       * @var int
  76       */
  77      public $queried_object_id;
  78  
  79      /**
  80       * SQL for the database query.
  81       *
  82       * @since 2.0.1
  83       * @var string
  84       */
  85      public $request;
  86  
  87      /**
  88       * Array of post objects or post IDs.
  89       *
  90       * @since 1.5.0
  91       * @var WP_Post[]|int[]
  92       */
  93      public $posts;
  94  
  95      /**
  96       * The number of posts for the current query.
  97       *
  98       * @since 1.5.0
  99       * @var int
 100       */
 101      public $post_count = 0;
 102  
 103      /**
 104       * Index of the current item in the loop.
 105       *
 106       * @since 1.5.0
 107       * @var int
 108       */
 109      public $current_post = -1;
 110  
 111      /**
 112       * Whether the caller is before the loop.
 113       *
 114       * @since 6.3.0
 115       * @var bool
 116       */
 117      public $before_loop = true;
 118  
 119      /**
 120       * Whether the loop has started and the caller is in the loop.
 121       *
 122       * @since 2.0.0
 123       * @var bool
 124       */
 125      public $in_the_loop = false;
 126  
 127      /**
 128       * The current post.
 129       *
 130       * This property does not get populated when the `fields` argument is set to
 131       * `ids` or `id=>parent`.
 132       *
 133       * @since 1.5.0
 134       * @var WP_Post|null
 135       */
 136      public $post;
 137  
 138      /**
 139       * The list of comments for current post.
 140       *
 141       * @since 2.2.0
 142       * @var WP_Comment[]
 143       */
 144      public $comments;
 145  
 146      /**
 147       * The number of comments for the posts.
 148       *
 149       * @since 2.2.0
 150       * @var int
 151       */
 152      public $comment_count = 0;
 153  
 154      /**
 155       * The index of the comment in the comment loop.
 156       *
 157       * @since 2.2.0
 158       * @var int
 159       */
 160      public $current_comment = -1;
 161  
 162      /**
 163       * Current comment object.
 164       *
 165       * @since 2.2.0
 166       * @var WP_Comment
 167       */
 168      public $comment;
 169  
 170      /**
 171       * The number of found posts for the current query.
 172       *
 173       * If limit clause was not used, equals $post_count.
 174       *
 175       * @since 2.1.0
 176       * @var int
 177       */
 178      public $found_posts = 0;
 179  
 180      /**
 181       * The number of pages.
 182       *
 183       * @since 2.1.0
 184       * @var int
 185       */
 186      public $max_num_pages = 0;
 187  
 188      /**
 189       * The number of comment pages.
 190       *
 191       * @since 2.7.0
 192       * @var int
 193       */
 194      public $max_num_comment_pages = 0;
 195  
 196      /**
 197       * Signifies whether the current query is for a single post.
 198       *
 199       * @since 1.5.0
 200       * @var bool
 201       */
 202      public $is_single = false;
 203  
 204      /**
 205       * Signifies whether the current query is for a preview.
 206       *
 207       * @since 2.0.0
 208       * @var bool
 209       */
 210      public $is_preview = false;
 211  
 212      /**
 213       * Signifies whether the current query is for a page.
 214       *
 215       * @since 1.5.0
 216       * @var bool
 217       */
 218      public $is_page = false;
 219  
 220      /**
 221       * Signifies whether the current query is for an archive.
 222       *
 223       * @since 1.5.0
 224       * @var bool
 225       */
 226      public $is_archive = false;
 227  
 228      /**
 229       * Signifies whether the current query is for a date archive.
 230       *
 231       * @since 1.5.0
 232       * @var bool
 233       */
 234      public $is_date = false;
 235  
 236      /**
 237       * Signifies whether the current query is for a year archive.
 238       *
 239       * @since 1.5.0
 240       * @var bool
 241       */
 242      public $is_year = false;
 243  
 244      /**
 245       * Signifies whether the current query is for a month archive.
 246       *
 247       * @since 1.5.0
 248       * @var bool
 249       */
 250      public $is_month = false;
 251  
 252      /**
 253       * Signifies whether the current query is for a day archive.
 254       *
 255       * @since 1.5.0
 256       * @var bool
 257       */
 258      public $is_day = false;
 259  
 260      /**
 261       * Signifies whether the current query is for a specific time.
 262       *
 263       * @since 1.5.0
 264       * @var bool
 265       */
 266      public $is_time = false;
 267  
 268      /**
 269       * Signifies whether the current query is for an author archive.
 270       *
 271       * @since 1.5.0
 272       * @var bool
 273       */
 274      public $is_author = false;
 275  
 276      /**
 277       * Signifies whether the current query is for a category archive.
 278       *
 279       * @since 1.5.0
 280       * @var bool
 281       */
 282      public $is_category = false;
 283  
 284      /**
 285       * Signifies whether the current query is for a tag archive.
 286       *
 287       * @since 2.3.0
 288       * @var bool
 289       */
 290      public $is_tag = false;
 291  
 292      /**
 293       * Signifies whether the current query is for a taxonomy archive.
 294       *
 295       * @since 2.5.0
 296       * @var bool
 297       */
 298      public $is_tax = false;
 299  
 300      /**
 301       * Signifies whether the current query is for a search.
 302       *
 303       * @since 1.5.0
 304       * @var bool
 305       */
 306      public $is_search = false;
 307  
 308      /**
 309       * Signifies whether the current query is for a feed.
 310       *
 311       * @since 1.5.0
 312       * @var bool
 313       */
 314      public $is_feed = false;
 315  
 316      /**
 317       * Signifies whether the current query is for a comment feed.
 318       *
 319       * @since 2.2.0
 320       * @var bool
 321       */
 322      public $is_comment_feed = false;
 323  
 324      /**
 325       * Signifies whether the current query is for trackback endpoint call.
 326       *
 327       * @since 1.5.0
 328       * @var bool
 329       */
 330      public $is_trackback = false;
 331  
 332      /**
 333       * Signifies whether the current query is for the site homepage.
 334       *
 335       * @since 1.5.0
 336       * @var bool
 337       */
 338      public $is_home = false;
 339  
 340      /**
 341       * Signifies whether the current query is for the Privacy Policy page.
 342       *
 343       * @since 5.2.0
 344       * @var bool
 345       */
 346      public $is_privacy_policy = false;
 347  
 348      /**
 349       * Signifies whether the current query couldn't find anything.
 350       *
 351       * @since 1.5.0
 352       * @var bool
 353       */
 354      public $is_404 = false;
 355  
 356      /**
 357       * Signifies whether the current query is for an embed.
 358       *
 359       * @since 4.4.0
 360       * @var bool
 361       */
 362      public $is_embed = false;
 363  
 364      /**
 365       * Signifies whether the current query is for a paged result and not for the first page.
 366       *
 367       * @since 1.5.0
 368       * @var bool
 369       */
 370      public $is_paged = false;
 371  
 372      /**
 373       * Signifies whether the current query is for an administrative interface page.
 374       *
 375       * @since 1.5.0
 376       * @var bool
 377       */
 378      public $is_admin = false;
 379  
 380      /**
 381       * Signifies whether the current query is for an attachment page.
 382       *
 383       * @since 2.0.0
 384       * @var bool
 385       */
 386      public $is_attachment = false;
 387  
 388      /**
 389       * Signifies whether the current query is for an existing single post of any post type
 390       * (post, attachment, page, custom post types).
 391       *
 392       * @since 2.1.0
 393       * @var bool
 394       */
 395      public $is_singular = false;
 396  
 397      /**
 398       * Signifies whether the current query is for the robots.txt file.
 399       *
 400       * @since 2.1.0
 401       * @var bool
 402       */
 403      public $is_robots = false;
 404  
 405      /**
 406       * Signifies whether the current query is for the favicon.ico file.
 407       *
 408       * @since 5.4.0
 409       * @var bool
 410       */
 411      public $is_favicon = false;
 412  
 413      /**
 414       * Signifies whether the current query is for the page_for_posts page.
 415       *
 416       * Basically, the homepage if the option isn't set for the static homepage.
 417       *
 418       * @since 2.1.0
 419       * @var bool
 420       */
 421      public $is_posts_page = false;
 422  
 423      /**
 424       * Signifies whether the current query is for a post type archive.
 425       *
 426       * @since 3.1.0
 427       * @var bool
 428       */
 429      public $is_post_type_archive = false;
 430  
 431      /**
 432       * Stores the ->query_vars state like md5(serialize( $this->query_vars ) ) so we know
 433       * whether we have to re-parse because something has changed
 434       *
 435       * @since 3.1.0
 436       * @var bool|string
 437       */
 438      private $query_vars_hash = false;
 439  
 440      /**
 441       * Whether query vars have changed since the initial parse_query() call. Used to catch modifications to query vars made
 442       * via pre_get_posts hooks.
 443       *
 444       * @since 3.1.1
 445       * @var bool
 446       */
 447      private $query_vars_changed = true;
 448  
 449      /**
 450       * Set if post thumbnails are cached
 451       *
 452       * @since 3.2.0
 453       * @var bool
 454       */
 455      public $thumbnails_cached = false;
 456  
 457      /**
 458       * Controls whether an attachment query should include filenames or not.
 459       *
 460       * @since 6.0.3
 461       * @var bool
 462       */
 463      protected $allow_query_attachment_by_filename = false;
 464  
 465      /**
 466       * Cached list of search stopwords.
 467       *
 468       * @since 3.7.0
 469       * @var array
 470       */
 471      private $stopwords;
 472  
 473      private $compat_fields = array( 'query_vars_hash', 'query_vars_changed' );
 474  
 475      private $compat_methods = array( 'init_query_flags', 'parse_tax_query' );
 476  
 477      /**
 478       * The cache key generated by the query.
 479       *
 480       * The cache key is generated by the method ::generate_cache_key() after the
 481       * query has been normalized.
 482       *
 483       * @since 6.8.0
 484       * @var string
 485       */
 486      private $query_cache_key = '';
 487  
 488      /**
 489       * Resets query flags to false.
 490       *
 491       * The query flags are what page info WordPress was able to figure out.
 492       *
 493       * @since 2.0.0
 494       */
 495  	private function init_query_flags() {
 496          $this->is_single            = false;
 497          $this->is_preview           = false;
 498          $this->is_page              = false;
 499          $this->is_archive           = false;
 500          $this->is_date              = false;
 501          $this->is_year              = false;
 502          $this->is_month             = false;
 503          $this->is_day               = false;
 504          $this->is_time              = false;
 505          $this->is_author            = false;
 506          $this->is_category          = false;
 507          $this->is_tag               = false;
 508          $this->is_tax               = false;
 509          $this->is_search            = false;
 510          $this->is_feed              = false;
 511          $this->is_comment_feed      = false;
 512          $this->is_trackback         = false;
 513          $this->is_home              = false;
 514          $this->is_privacy_policy    = false;
 515          $this->is_404               = false;
 516          $this->is_paged             = false;
 517          $this->is_admin             = false;
 518          $this->is_attachment        = false;
 519          $this->is_singular          = false;
 520          $this->is_robots            = false;
 521          $this->is_favicon           = false;
 522          $this->is_posts_page        = false;
 523          $this->is_post_type_archive = false;
 524      }
 525  
 526      /**
 527       * Initiates object properties and sets default values.
 528       *
 529       * @since 1.5.0
 530       */
 531  	public function init() {
 532          unset( $this->posts );
 533          unset( $this->query );
 534          $this->query_vars = array();
 535          unset( $this->queried_object );
 536          unset( $this->queried_object_id );
 537          $this->post_count   = 0;
 538          $this->current_post = -1;
 539          $this->in_the_loop  = false;
 540          $this->before_loop  = true;
 541          unset( $this->request );
 542          unset( $this->post );
 543          unset( $this->comments );
 544          unset( $this->comment );
 545          $this->comment_count         = 0;
 546          $this->current_comment       = -1;
 547          $this->found_posts           = 0;
 548          $this->max_num_pages         = 0;
 549          $this->max_num_comment_pages = 0;
 550  
 551          $this->init_query_flags();
 552      }
 553  
 554      /**
 555       * Reparses the query vars.
 556       *
 557       * @since 1.5.0
 558       */
 559  	public function parse_query_vars() {
 560          $this->parse_query();
 561      }
 562  
 563      /**
 564       * Fills in the query variables, which do not exist within the parameter.
 565       *
 566       * @since 2.1.0
 567       * @since 4.5.0 Removed the `comments_popup` public query variable.
 568       *
 569       * @param array $query_vars Defined query variables.
 570       * @return array Complete query variables with undefined ones filled in empty.
 571       */
 572  	public function fill_query_vars( $query_vars ) {
 573          $keys = array(
 574              'error',
 575              'm',
 576              'p',
 577              'post_parent',
 578              'subpost',
 579              'subpost_id',
 580              'attachment',
 581              'attachment_id',
 582              'name',
 583              'pagename',
 584              'page_id',
 585              'second',
 586              'minute',
 587              'hour',
 588              'day',
 589              'monthnum',
 590              'year',
 591              'w',
 592              'category_name',
 593              'tag',
 594              'cat',
 595              'tag_id',
 596              'author',
 597              'author_name',
 598              'feed',
 599              'tb',
 600              'paged',
 601              'meta_key',
 602              'meta_value',
 603              'preview',
 604              's',
 605              'sentence',
 606              'title',
 607              'fields',
 608              'menu_order',
 609              'embed',
 610          );
 611  
 612          foreach ( $keys as $key ) {
 613              if ( ! isset( $query_vars[ $key ] ) ) {
 614                  $query_vars[ $key ] = '';
 615              }
 616          }
 617  
 618          $array_keys = array(
 619              'category__in',
 620              'category__not_in',
 621              'category__and',
 622              'post__in',
 623              'post__not_in',
 624              'post_name__in',
 625              'tag__in',
 626              'tag__not_in',
 627              'tag__and',
 628              'tag_slug__in',
 629              'tag_slug__and',
 630              'post_parent__in',
 631              'post_parent__not_in',
 632              'author__in',
 633              'author__not_in',
 634              'search_columns',
 635          );
 636  
 637          foreach ( $array_keys as $key ) {
 638              if ( ! isset( $query_vars[ $key ] ) ) {
 639                  $query_vars[ $key ] = array();
 640              }
 641          }
 642  
 643          return $query_vars;
 644      }
 645  
 646      /**
 647       * Parses a query string and sets query type booleans.
 648       *
 649       * @since 1.5.0
 650       * @since 4.2.0 Introduced the ability to order by specific clauses of a `$meta_query`, by passing the clause's
 651       *              array key to `$orderby`.
 652       * @since 4.4.0 Introduced `$post_name__in` and `$title` parameters. `$s` was updated to support excluded
 653       *              search terms, by prepending a hyphen.
 654       * @since 4.5.0 Removed the `$comments_popup` parameter.
 655       *              Introduced the `$comment_status` and `$ping_status` parameters.
 656       *              Introduced `RAND(x)` syntax for `$orderby`, which allows an integer seed value to random sorts.
 657       * @since 4.6.0 Added 'post_name__in' support for `$orderby`. Introduced the `$lazy_load_term_meta` argument.
 658       * @since 4.9.0 Introduced the `$comment_count` parameter.
 659       * @since 5.1.0 Introduced the `$meta_compare_key` parameter.
 660       * @since 5.3.0 Introduced the `$meta_type_key` parameter.
 661       * @since 6.1.0 Introduced the `$update_menu_item_cache` parameter.
 662       * @since 6.2.0 Introduced the `$search_columns` parameter.
 663       *
 664       * @param string|array $query {
 665       *     Optional. Array or string of Query parameters.
 666       *
 667       *     @type int             $attachment_id          Attachment post ID. Used for 'attachment' post_type.
 668       *     @type int|string      $author                 Author ID, or comma-separated list of IDs.
 669       *     @type string          $author_name            User 'user_nicename'.
 670       *     @type int[]           $author__in             An array of author IDs to query from.
 671       *     @type int[]           $author__not_in         An array of author IDs not to query from.
 672       *     @type bool            $cache_results          Whether to cache post information. Default true.
 673       *     @type int|string      $cat                    Category ID or comma-separated list of IDs (this or any children).
 674       *     @type int[]           $category__and          An array of category IDs (AND in).
 675       *     @type int[]           $category__in           An array of category IDs (OR in, no children).
 676       *     @type int[]           $category__not_in       An array of category IDs (NOT in).
 677       *     @type string          $category_name          Use category slug (not name, this or any children).
 678       *     @type array|int       $comment_count          Filter results by comment count. Provide an integer to match
 679       *                                                   comment count exactly. Provide an array with integer 'value'
 680       *                                                   and 'compare' operator ('=', '!=', '>', '>=', '<', '<=' ) to
 681       *                                                   compare against comment_count in a specific way.
 682       *     @type string          $comment_status         Comment status.
 683       *     @type int             $comments_per_page      The number of comments to return per page.
 684       *                                                   Default 'comments_per_page' option.
 685       *     @type array           $date_query             An associative array of WP_Date_Query arguments.
 686       *                                                   See WP_Date_Query::__construct().
 687       *     @type int             $day                    Day of the month. Default empty. Accepts numbers 1-31.
 688       *     @type bool            $exact                  Whether to search by exact keyword. Default false.
 689       *     @type string          $fields                 Post fields to query for. Accepts:
 690       *                                                   - '' Returns an array of complete post objects (`WP_Post[]`).
 691       *                                                   - 'ids' Returns an array of post IDs (`int[]`).
 692       *                                                   - 'id=>parent' Returns an associative array of parent post IDs,
 693       *                                                     keyed by post ID (`int[]`).
 694       *                                                   Default ''.
 695       *     @type int             $hour                   Hour of the day. Default empty. Accepts numbers 0-23.
 696       *     @type int|bool        $ignore_sticky_posts    Whether to ignore sticky posts or not. Setting this to false
 697       *                                                   excludes stickies from 'post__in'. Accepts 1|true, 0|false.
 698       *                                                   Default false.
 699       *     @type int             $m                      Combination YearMonth. Accepts any four-digit year and month
 700       *                                                   numbers 01-12. Default empty.
 701       *     @type string|string[] $meta_key               Meta key or keys to filter by.
 702       *     @type string|string[] $meta_value             Meta value or values to filter by.
 703       *     @type string          $meta_compare           MySQL operator used for comparing the meta value.
 704       *                                                   See WP_Meta_Query::__construct() for accepted values and default value.
 705       *     @type string          $meta_compare_key       MySQL operator used for comparing the meta key.
 706       *                                                   See WP_Meta_Query::__construct() for accepted values and default value.
 707       *     @type string          $meta_type              MySQL data type that the meta_value column will be CAST to for comparisons.
 708       *                                                   See WP_Meta_Query::__construct() for accepted values and default value.
 709       *     @type string          $meta_type_key          MySQL data type that the meta_key column will be CAST to for comparisons.
 710       *                                                   See WP_Meta_Query::__construct() for accepted values and default value.
 711       *     @type array           $meta_query             An associative array of WP_Meta_Query arguments.
 712       *                                                   See WP_Meta_Query::__construct() for accepted values.
 713       *     @type int             $menu_order             The menu order of the posts.
 714       *     @type int             $minute                 Minute of the hour. Default empty. Accepts numbers 0-59.
 715       *     @type int             $monthnum               The two-digit month. Default empty. Accepts numbers 1-12.
 716       *     @type string          $name                   Post slug.
 717       *     @type bool            $nopaging               Show all posts (true) or paginate (false). Default false.
 718       *     @type bool            $no_found_rows          Whether to skip counting the total rows found. Enabling can improve
 719       *                                                   performance. Default false.
 720       *     @type int             $offset                 The number of posts to offset before retrieval.
 721       *     @type string          $order                  Designates ascending or descending order of posts. Default 'DESC'.
 722       *                                                   Accepts 'ASC', 'DESC'.
 723       *     @type string|array    $orderby                Sort retrieved posts by parameter. One or more options may be passed.
 724       *                                                   To use 'meta_value', or 'meta_value_num', 'meta_key=keyname' must be
 725       *                                                   also be defined. To sort by a specific `$meta_query` clause, use that
 726       *                                                   clause's array key. Accepts:
 727       *                                                   - 'none'
 728       *                                                   - 'name'
 729       *                                                   - 'author'
 730       *                                                   - 'date'
 731       *                                                   - 'title'
 732       *                                                   - 'modified'
 733       *                                                   - 'menu_order'
 734       *                                                   - 'parent'
 735       *                                                   - 'ID'
 736       *                                                   - 'rand'
 737       *                                                   - 'relevance'
 738       *                                                   - 'RAND(x)' (where 'x' is an integer seed value)
 739       *                                                   - 'comment_count'
 740       *                                                   - 'meta_value'
 741       *                                                   - 'meta_value_num'
 742       *                                                   - 'post__in'
 743       *                                                   - 'post_name__in'
 744       *                                                   - 'post_parent__in'
 745       *                                                   - The array keys of `$meta_query`.
 746       *                                                   Default is 'date', except when a search is being performed, when
 747       *                                                   the default is 'relevance'.
 748       *     @type int             $p                      Post ID.
 749       *     @type int             $page                   Show the number of posts that would show up on page X of a
 750       *                                                   static front page.
 751       *     @type int             $paged                  The number of the current page.
 752       *     @type int             $page_id                Page ID.
 753       *     @type string          $pagename               Page slug.
 754       *     @type string          $perm                   Show posts if user has the appropriate capability.
 755       *     @type string          $ping_status            Ping status.
 756       *     @type int[]           $post__in               An array of post IDs to retrieve, sticky posts will be included.
 757       *     @type int[]           $post__not_in           An array of post IDs not to retrieve. Note: a string of comma-
 758       *                                                   separated IDs will NOT work.
 759       *     @type string          $post_mime_type         The mime type of the post. Used for 'attachment' post_type.
 760       *     @type string[]        $post_name__in          An array of post slugs that results must match.
 761       *     @type int             $post_parent            Page ID to retrieve child pages for. Use 0 to only retrieve
 762       *                                                   top-level pages.
 763       *     @type int[]           $post_parent__in        An array containing parent page IDs to query child pages from.
 764       *     @type int[]           $post_parent__not_in    An array containing parent page IDs not to query child pages from.
 765       *     @type string|string[] $post_type              A post type slug (string) or array of post type slugs.
 766       *                                                   Default 'any' if using 'tax_query'.
 767       *     @type string|string[] $post_status            A post status (string) or array of post statuses.
 768       *     @type int             $posts_per_page         The number of posts to query for. Use -1 to request all posts.
 769       *     @type int             $posts_per_archive_page The number of posts to query for by archive page. Overrides
 770       *                                                   'posts_per_page' when is_archive(), or is_search() are true.
 771       *     @type string          $s                      Search keyword(s). Prepending a term with a hyphen will
 772       *                                                   exclude posts matching that term. Eg, 'pillow -sofa' will
 773       *                                                   return posts containing 'pillow' but not 'sofa'. The
 774       *                                                   character used for exclusion can be modified using the
 775       *                                                   the 'wp_query_search_exclusion_prefix' filter.
 776       *     @type string[]        $search_columns         Array of column names to be searched. Accepts 'post_title',
 777       *                                                   'post_excerpt' and 'post_content'. Default empty array.
 778       *     @type int             $second                 Second of the minute. Default empty. Accepts numbers 0-59.
 779       *     @type bool            $sentence               Whether to search by phrase. Default false.
 780       *     @type bool            $suppress_filters       Whether to suppress filters. Default false.
 781       *     @type string          $tag                    Tag slug. Comma-separated (either), Plus-separated (all).
 782       *     @type int[]           $tag__and               An array of tag IDs (AND in).
 783       *     @type int[]           $tag__in                An array of tag IDs (OR in).
 784       *     @type int[]           $tag__not_in            An array of tag IDs (NOT in).
 785       *     @type int             $tag_id                 Tag id or comma-separated list of IDs.
 786       *     @type string[]        $tag_slug__and          An array of tag slugs (AND in).
 787       *     @type string[]        $tag_slug__in           An array of tag slugs (OR in). unless 'ignore_sticky_posts' is
 788       *                                                   true. Note: a string of comma-separated IDs will NOT work.
 789       *     @type array           $tax_query              An associative array of WP_Tax_Query arguments.
 790       *                                                   See WP_Tax_Query::__construct().
 791       *     @type string          $title                  Post title.
 792       *     @type bool            $update_post_meta_cache Whether to update the post meta cache. Default true.
 793       *     @type bool            $update_post_term_cache Whether to update the post term cache. Default true.
 794       *     @type bool            $update_menu_item_cache Whether to update the menu item cache. Default false.
 795       *     @type bool            $lazy_load_term_meta    Whether to lazy-load term meta. Setting to false will
 796       *                                                   disable cache priming for term meta, so that each
 797       *                                                   get_term_meta() call will hit the database.
 798       *                                                   Defaults to the value of `$update_post_term_cache`.
 799       *     @type int             $w                      The week number of the year. Default empty. Accepts numbers 0-53.
 800       *     @type int             $year                   The four-digit year. Default empty. Accepts any four-digit year.
 801       * }
 802       */
 803  	public function parse_query( $query = '' ) {
 804          if ( ! empty( $query ) ) {
 805              $this->init();
 806              $this->query      = wp_parse_args( $query );
 807              $this->query_vars = $this->query;
 808          } elseif ( ! isset( $this->query ) ) {
 809              $this->query = $this->query_vars;
 810          }
 811  
 812          $this->query_vars         = $this->fill_query_vars( $this->query_vars );
 813          $qv                       = &$this->query_vars;
 814          $this->query_vars_changed = true;
 815  
 816          if ( ! empty( $qv['robots'] ) ) {
 817              $this->is_robots = true;
 818          } elseif ( ! empty( $qv['favicon'] ) ) {
 819              $this->is_favicon = true;
 820          }
 821  
 822          if ( ! is_scalar( $qv['p'] ) || (int) $qv['p'] < 0 ) {
 823              $qv['p']     = 0;
 824              $qv['error'] = '404';
 825          } else {
 826              $qv['p'] = (int) $qv['p'];
 827          }
 828  
 829          $qv['page_id']  = is_scalar( $qv['page_id'] ) ? absint( $qv['page_id'] ) : 0;
 830          $qv['year']     = is_scalar( $qv['year'] ) ? absint( $qv['year'] ) : 0;
 831          $qv['monthnum'] = is_scalar( $qv['monthnum'] ) ? absint( $qv['monthnum'] ) : 0;
 832          $qv['day']      = is_scalar( $qv['day'] ) ? absint( $qv['day'] ) : 0;
 833          $qv['w']        = is_scalar( $qv['w'] ) ? absint( $qv['w'] ) : 0;
 834          $qv['m']        = is_scalar( $qv['m'] ) ? preg_replace( '|[^0-9]|', '', $qv['m'] ) : '';
 835          $qv['paged']    = is_scalar( $qv['paged'] ) ? absint( $qv['paged'] ) : 0;
 836          $qv['cat']      = preg_replace( '|[^0-9,-]|', '', $qv['cat'] ); // Array or comma-separated list of positive or negative integers.
 837          $qv['author']   = is_scalar( $qv['author'] ) ? preg_replace( '|[^0-9,-]|', '', $qv['author'] ) : ''; // Comma-separated list of positive or negative integers.
 838          $qv['pagename'] = is_scalar( $qv['pagename'] ) ? trim( $qv['pagename'] ) : '';
 839          $qv['name']     = is_scalar( $qv['name'] ) ? trim( $qv['name'] ) : '';
 840          $qv['title']    = is_scalar( $qv['title'] ) ? trim( $qv['title'] ) : '';
 841  
 842          if ( is_scalar( $qv['hour'] ) && '' !== $qv['hour'] ) {
 843              $qv['hour'] = absint( $qv['hour'] );
 844          } else {
 845              $qv['hour'] = '';
 846          }
 847  
 848          if ( is_scalar( $qv['minute'] ) && '' !== $qv['minute'] ) {
 849              $qv['minute'] = absint( $qv['minute'] );
 850          } else {
 851              $qv['minute'] = '';
 852          }
 853  
 854          if ( is_scalar( $qv['second'] ) && '' !== $qv['second'] ) {
 855              $qv['second'] = absint( $qv['second'] );
 856          } else {
 857              $qv['second'] = '';
 858          }
 859  
 860          if ( is_scalar( $qv['menu_order'] ) && '' !== $qv['menu_order'] ) {
 861              $qv['menu_order'] = absint( $qv['menu_order'] );
 862          } else {
 863              $qv['menu_order'] = '';
 864          }
 865  
 866          // Fairly large, potentially too large, upper bound for search string lengths.
 867          if ( ! is_scalar( $qv['s'] ) || ( ! empty( $qv['s'] ) && strlen( $qv['s'] ) > 1600 ) ) {
 868              $qv['s'] = '';
 869          }
 870  
 871          // Compat. Map subpost to attachment.
 872          if ( is_scalar( $qv['subpost'] ) && '' != $qv['subpost'] ) {
 873              $qv['attachment'] = $qv['subpost'];
 874          }
 875          if ( is_scalar( $qv['subpost_id'] ) && '' != $qv['subpost_id'] ) {
 876              $qv['attachment_id'] = $qv['subpost_id'];
 877          }
 878  
 879          $qv['attachment_id'] = is_scalar( $qv['attachment_id'] ) ? absint( $qv['attachment_id'] ) : 0;
 880  
 881          if ( ( '' !== $qv['attachment'] ) || ! empty( $qv['attachment_id'] ) ) {
 882              $this->is_single     = true;
 883              $this->is_attachment = true;
 884          } elseif ( '' !== $qv['name'] ) {
 885              $this->is_single = true;
 886          } elseif ( $qv['p'] ) {
 887              $this->is_single = true;
 888          } elseif ( '' !== $qv['pagename'] || ! empty( $qv['page_id'] ) ) {
 889              $this->is_page   = true;
 890              $this->is_single = false;
 891          } else {
 892              // Look for archive queries. Dates, categories, authors, search, post type archives.
 893  
 894              if ( isset( $this->query['s'] ) ) {
 895                  $this->is_search = true;
 896              }
 897  
 898              if ( '' !== $qv['second'] ) {
 899                  $this->is_time = true;
 900                  $this->is_date = true;
 901              }
 902  
 903              if ( '' !== $qv['minute'] ) {
 904                  $this->is_time = true;
 905                  $this->is_date = true;
 906              }
 907  
 908              if ( '' !== $qv['hour'] ) {
 909                  $this->is_time = true;
 910                  $this->is_date = true;
 911              }
 912  
 913              if ( $qv['day'] ) {
 914                  if ( ! $this->is_date ) {
 915                      $date = sprintf( '%04d-%02d-%02d', $qv['year'], $qv['monthnum'], $qv['day'] );
 916                      if ( $qv['monthnum'] && $qv['year'] && ! wp_checkdate( $qv['monthnum'], $qv['day'], $qv['year'], $date ) ) {
 917                          $qv['error'] = '404';
 918                      } else {
 919                          $this->is_day  = true;
 920                          $this->is_date = true;
 921                      }
 922                  }
 923              }
 924  
 925              if ( $qv['monthnum'] ) {
 926                  if ( ! $this->is_date ) {
 927                      if ( 12 < $qv['monthnum'] ) {
 928                          $qv['error'] = '404';
 929                      } else {
 930                          $this->is_month = true;
 931                          $this->is_date  = true;
 932                      }
 933                  }
 934              }
 935  
 936              if ( $qv['year'] ) {
 937                  if ( ! $this->is_date ) {
 938                      $this->is_year = true;
 939                      $this->is_date = true;
 940                  }
 941              }
 942  
 943              if ( $qv['m'] ) {
 944                  $this->is_date = true;
 945                  if ( strlen( $qv['m'] ) > 9 ) {
 946                      $this->is_time = true;
 947                  } elseif ( strlen( $qv['m'] ) > 7 ) {
 948                      $this->is_day = true;
 949                  } elseif ( strlen( $qv['m'] ) > 5 ) {
 950                      $this->is_month = true;
 951                  } else {
 952                      $this->is_year = true;
 953                  }
 954              }
 955  
 956              if ( $qv['w'] ) {
 957                  $this->is_date = true;
 958              }
 959  
 960              $this->query_vars_hash = false;
 961              $this->parse_tax_query( $qv );
 962  
 963              foreach ( $this->tax_query->queries as $tax_query ) {
 964                  if ( ! is_array( $tax_query ) ) {
 965                      continue;
 966                  }
 967  
 968                  if ( isset( $tax_query['operator'] ) && 'NOT IN' !== $tax_query['operator'] ) {
 969                      switch ( $tax_query['taxonomy'] ) {
 970                          case 'category':
 971                              $this->is_category = true;
 972                              break;
 973                          case 'post_tag':
 974                              $this->is_tag = true;
 975                              break;
 976                          default:
 977                              $this->is_tax = true;
 978                      }
 979                  }
 980              }
 981              unset( $tax_query );
 982  
 983              if ( empty( $qv['author'] ) || ( '0' == $qv['author'] ) ) {
 984                  $this->is_author = false;
 985              } else {
 986                  $this->is_author = true;
 987              }
 988  
 989              if ( '' !== $qv['author_name'] ) {
 990                  $this->is_author = true;
 991              }
 992  
 993              if ( ! empty( $qv['post_type'] ) && ! is_array( $qv['post_type'] ) ) {
 994                  $post_type_obj = get_post_type_object( $qv['post_type'] );
 995                  if ( ! empty( $post_type_obj->has_archive ) ) {
 996                      $this->is_post_type_archive = true;
 997                  }
 998              }
 999  
1000              if ( $this->is_post_type_archive || $this->is_date || $this->is_author || $this->is_category || $this->is_tag || $this->is_tax ) {
1001                  $this->is_archive = true;
1002              }
1003          }
1004  
1005          if ( '' != $qv['feed'] ) {
1006              $this->is_feed = true;
1007          }
1008  
1009          if ( '' != $qv['embed'] ) {
1010              $this->is_embed = true;
1011          }
1012  
1013          if ( '' != $qv['tb'] ) {
1014              $this->is_trackback = true;
1015          }
1016  
1017          if ( '' != $qv['paged'] && ( (int) $qv['paged'] > 1 ) ) {
1018              $this->is_paged = true;
1019          }
1020  
1021          // If we're previewing inside the write screen.
1022          if ( '' != $qv['preview'] ) {
1023              $this->is_preview = true;
1024          }
1025  
1026          if ( is_admin() ) {
1027              $this->is_admin = true;
1028          }
1029  
1030          if ( str_contains( $qv['feed'], 'comments-' ) ) {
1031              $qv['feed']         = str_replace( 'comments-', '', $qv['feed'] );
1032              $qv['withcomments'] = 1;
1033          }
1034  
1035          $this->is_singular = $this->is_single || $this->is_page || $this->is_attachment;
1036  
1037          if ( $this->is_feed && ( ! empty( $qv['withcomments'] ) || ( empty( $qv['withoutcomments'] ) && $this->is_singular ) ) ) {
1038              $this->is_comment_feed = true;
1039          }
1040  
1041          if ( ! ( $this->is_singular || $this->is_archive || $this->is_search || $this->is_feed
1042                  || ( wp_is_serving_rest_request() && $this->is_main_query() )
1043                  || $this->is_trackback || $this->is_404 || $this->is_admin || $this->is_robots || $this->is_favicon ) ) {
1044              $this->is_home = true;
1045          }
1046  
1047          // Correct `is_*` for 'page_on_front' and 'page_for_posts'.
1048          if ( $this->is_home && 'page' === get_option( 'show_on_front' ) && get_option( 'page_on_front' ) ) {
1049              $_query = wp_parse_args( $this->query );
1050              // 'pagename' can be set and empty depending on matched rewrite rules. Ignore an empty 'pagename'.
1051              if ( isset( $_query['pagename'] ) && '' === $_query['pagename'] ) {
1052                  unset( $_query['pagename'] );
1053              }
1054  
1055              unset( $_query['embed'] );
1056  
1057              if ( empty( $_query ) || ! array_diff( array_keys( $_query ), array( 'preview', 'page', 'paged', 'cpage' ) ) ) {
1058                  $this->is_page = true;
1059                  $this->is_home = false;
1060                  $qv['page_id'] = get_option( 'page_on_front' );
1061                  // Correct <!--nextpage--> for 'page_on_front'.
1062                  if ( ! empty( $qv['paged'] ) ) {
1063                      $qv['page'] = $qv['paged'];
1064                      unset( $qv['paged'] );
1065                  }
1066              }
1067          }
1068  
1069          if ( '' !== $qv['pagename'] ) {
1070              $this->queried_object = get_page_by_path( $qv['pagename'] );
1071  
1072              if ( $this->queried_object && 'attachment' === $this->queried_object->post_type ) {
1073                  if ( preg_match( '/^[^%]*%(?:postname)%/', get_option( 'permalink_structure' ) ) ) {
1074                      // See if we also have a post with the same slug.
1075                      $post = get_page_by_path( $qv['pagename'], OBJECT, 'post' );
1076                      if ( $post ) {
1077                          $this->queried_object = $post;
1078                          $this->is_page        = false;
1079                          $this->is_single      = true;
1080                      }
1081                  }
1082              }
1083  
1084              if ( ! empty( $this->queried_object ) ) {
1085                  $this->queried_object_id = (int) $this->queried_object->ID;
1086              } else {
1087                  unset( $this->queried_object );
1088              }
1089  
1090              if ( 'page' === get_option( 'show_on_front' ) && isset( $this->queried_object_id ) && get_option( 'page_for_posts' ) == $this->queried_object_id ) {
1091                  $this->is_page       = false;
1092                  $this->is_home       = true;
1093                  $this->is_posts_page = true;
1094              }
1095  
1096              if ( isset( $this->queried_object_id ) && get_option( 'wp_page_for_privacy_policy' ) == $this->queried_object_id ) {
1097                  $this->is_privacy_policy = true;
1098              }
1099          }
1100  
1101          if ( $qv['page_id'] ) {
1102              if ( 'page' === get_option( 'show_on_front' ) && get_option( 'page_for_posts' ) == $qv['page_id'] ) {
1103                  $this->is_page       = false;
1104                  $this->is_home       = true;
1105                  $this->is_posts_page = true;
1106              }
1107  
1108              if ( get_option( 'wp_page_for_privacy_policy' ) == $qv['page_id'] ) {
1109                  $this->is_privacy_policy = true;
1110              }
1111          }
1112  
1113          if ( ! empty( $qv['post_type'] ) ) {
1114              if ( is_array( $qv['post_type'] ) ) {
1115                  $qv['post_type'] = array_map( 'sanitize_key', array_unique( $qv['post_type'] ) );
1116                  sort( $qv['post_type'] );
1117              } else {
1118                  $qv['post_type'] = sanitize_key( $qv['post_type'] );
1119              }
1120          }
1121  
1122          if ( ! empty( $qv['post_status'] ) ) {
1123              if ( is_array( $qv['post_status'] ) ) {
1124                  $qv['post_status'] = array_map( 'sanitize_key', array_unique( $qv['post_status'] ) );
1125                  sort( $qv['post_status'] );
1126              } else {
1127                  $qv['post_status'] = preg_replace( '|[^a-z0-9_,-]|', '', $qv['post_status'] );
1128              }
1129          }
1130  
1131          if ( $this->is_posts_page && ( ! isset( $qv['withcomments'] ) || ! $qv['withcomments'] ) ) {
1132              $this->is_comment_feed = false;
1133          }
1134  
1135          $this->is_singular = $this->is_single || $this->is_page || $this->is_attachment;
1136          // Done correcting `is_*` for 'page_on_front' and 'page_for_posts'.
1137  
1138          if ( '404' == $qv['error'] ) {
1139              $this->set_404();
1140          }
1141  
1142          $this->is_embed = $this->is_embed && ( $this->is_singular || $this->is_404 );
1143  
1144          $this->query_vars_hash    = md5( serialize( $this->query_vars ) );
1145          $this->query_vars_changed = false;
1146  
1147          /**
1148           * Fires after the main query vars have been parsed.
1149           *
1150           * @since 1.5.0
1151           *
1152           * @param WP_Query $query The WP_Query instance (passed by reference).
1153           */
1154          do_action_ref_array( 'parse_query', array( &$this ) );
1155      }
1156  
1157      /**
1158       * Parses various taxonomy related query vars.
1159       *
1160       * For BC, this method is not marked as protected. See [28987].
1161       *
1162       * @since 3.1.0
1163       *
1164       * @param array $q The query variables. Passed by reference.
1165       */
1166  	public function parse_tax_query( &$q ) {
1167          if ( ! empty( $q['tax_query'] ) && is_array( $q['tax_query'] ) ) {
1168              $tax_query = $q['tax_query'];
1169          } else {
1170              $tax_query = array();
1171          }
1172  
1173          if ( ! empty( $q['taxonomy'] ) && ! empty( $q['term'] ) ) {
1174              $tax_query[] = array(
1175                  'taxonomy' => $q['taxonomy'],
1176                  'terms'    => array( $q['term'] ),
1177                  'field'    => 'slug',
1178              );
1179          }
1180  
1181          foreach ( get_taxonomies( array(), 'objects' ) as $taxonomy => $t ) {
1182              if ( 'post_tag' === $taxonomy ) {
1183                  continue; // Handled further down in the $q['tag'] block.
1184              }
1185  
1186              if ( $t->query_var && ! empty( $q[ $t->query_var ] ) ) {
1187                  $tax_query_defaults = array(
1188                      'taxonomy' => $taxonomy,
1189                      'field'    => 'slug',
1190                  );
1191  
1192                  if ( ! empty( $t->rewrite['hierarchical'] ) ) {
1193                      $q[ $t->query_var ] = wp_basename( $q[ $t->query_var ] );
1194                  }
1195  
1196                  $term = $q[ $t->query_var ];
1197  
1198                  if ( ! is_array( $term ) ) {
1199                      $term = explode( ',', $term );
1200                      $term = array_map( 'trim', $term );
1201                  }
1202                  sort( $term );
1203                  $term = implode( ',', $term );
1204  
1205                  if ( str_contains( $term, '+' ) ) {
1206                      $terms = preg_split( '/[+]+/', $term );
1207                      foreach ( $terms as $term ) {
1208                          $tax_query[] = array_merge(
1209                              $tax_query_defaults,
1210                              array(
1211                                  'terms' => array( $term ),
1212                              )
1213                          );
1214                      }
1215                  } else {
1216                      $tax_query[] = array_merge(
1217                          $tax_query_defaults,
1218                          array(
1219                              'terms' => preg_split( '/[,]+/', $term ),
1220                          )
1221                      );
1222                  }
1223              }
1224          }
1225  
1226          // If query string 'cat' is an array, implode it.
1227          if ( is_array( $q['cat'] ) ) {
1228              $q['cat'] = implode( ',', $q['cat'] );
1229          }
1230  
1231          // Category stuff.
1232  
1233          if ( ! empty( $q['cat'] ) && ! $this->is_singular ) {
1234              $cat_in     = array();
1235              $cat_not_in = array();
1236  
1237              $cat_array = preg_split( '/[,\s]+/', urldecode( $q['cat'] ) );
1238              $cat_array = array_map( 'intval', $cat_array );
1239              sort( $cat_array );
1240              $q['cat'] = implode( ',', $cat_array );
1241  
1242              foreach ( $cat_array as $cat ) {
1243                  if ( $cat > 0 ) {
1244                      $cat_in[] = $cat;
1245                  } elseif ( $cat < 0 ) {
1246                      $cat_not_in[] = abs( $cat );
1247                  }
1248              }
1249  
1250              if ( ! empty( $cat_in ) ) {
1251                  $tax_query[] = array(
1252                      'taxonomy'         => 'category',
1253                      'terms'            => $cat_in,
1254                      'field'            => 'term_id',
1255                      'include_children' => true,
1256                  );
1257              }
1258  
1259              if ( ! empty( $cat_not_in ) ) {
1260                  $tax_query[] = array(
1261                      'taxonomy'         => 'category',
1262                      'terms'            => $cat_not_in,
1263                      'field'            => 'term_id',
1264                      'operator'         => 'NOT IN',
1265                      'include_children' => true,
1266                  );
1267              }
1268              unset( $cat_array, $cat_in, $cat_not_in );
1269          }
1270  
1271          if ( ! empty( $q['category__and'] ) && 1 === count( (array) $q['category__and'] ) ) {
1272              $q['category__and'] = (array) $q['category__and'];
1273              if ( ! isset( $q['category__in'] ) ) {
1274                  $q['category__in'] = array();
1275              }
1276              $q['category__in'][] = absint( reset( $q['category__and'] ) );
1277              unset( $q['category__and'] );
1278          }
1279  
1280          if ( ! empty( $q['category__in'] ) ) {
1281              $q['category__in'] = array_map( 'absint', array_unique( (array) $q['category__in'] ) );
1282              sort( $q['category__in'] );
1283              $tax_query[] = array(
1284                  'taxonomy'         => 'category',
1285                  'terms'            => $q['category__in'],
1286                  'field'            => 'term_id',
1287                  'include_children' => false,
1288              );
1289          }
1290  
1291          if ( ! empty( $q['category__not_in'] ) ) {
1292              $q['category__not_in'] = array_map( 'absint', array_unique( (array) $q['category__not_in'] ) );
1293              sort( $q['category__not_in'] );
1294              $tax_query[]           = array(
1295                  'taxonomy'         => 'category',
1296                  'terms'            => $q['category__not_in'],
1297                  'operator'         => 'NOT IN',
1298                  'include_children' => false,
1299              );
1300          }
1301  
1302          if ( ! empty( $q['category__and'] ) ) {
1303              $q['category__and'] = array_map( 'absint', array_unique( (array) $q['category__and'] ) );
1304              sort( $q['category__and'] );
1305              $tax_query[] = array(
1306                  'taxonomy'         => 'category',
1307                  'terms'            => $q['category__and'],
1308                  'field'            => 'term_id',
1309                  'operator'         => 'AND',
1310                  'include_children' => false,
1311              );
1312          }
1313  
1314          // If query string 'tag' is array, implode it.
1315          if ( is_array( $q['tag'] ) ) {
1316              $q['tag'] = implode( ',', $q['tag'] );
1317          }
1318  
1319          // Tag stuff.
1320  
1321          if ( '' !== $q['tag'] && ! $this->is_singular && $this->query_vars_changed ) {
1322              if ( str_contains( $q['tag'], ',' ) ) {
1323                  // @todo Handle normalizing `tag` query string.
1324                  $tags = preg_split( '/[,\r\n\t ]+/', $q['tag'] );
1325                  foreach ( (array) $tags as $tag ) {
1326                      $tag                 = sanitize_term_field( 'slug', $tag, 0, 'post_tag', 'db' );
1327                      $q['tag_slug__in'][] = $tag;
1328                      sort( $q['tag_slug__in'] );
1329                  }
1330              } elseif ( preg_match( '/[+\r\n\t ]+/', $q['tag'] ) || ! empty( $q['cat'] ) ) {
1331                  $tags = preg_split( '/[+\r\n\t ]+/', $q['tag'] );
1332                  foreach ( (array) $tags as $tag ) {
1333                      $tag                  = sanitize_term_field( 'slug', $tag, 0, 'post_tag', 'db' );
1334                      $q['tag_slug__and'][] = $tag;
1335                  }
1336              } else {
1337                  $q['tag']            = sanitize_term_field( 'slug', $q['tag'], 0, 'post_tag', 'db' );
1338                  $q['tag_slug__in'][] = $q['tag'];
1339                  sort( $q['tag_slug__in'] );
1340              }
1341          }
1342  
1343          if ( ! empty( $q['tag_id'] ) ) {
1344              $q['tag_id'] = absint( $q['tag_id'] );
1345              $tax_query[] = array(
1346                  'taxonomy' => 'post_tag',
1347                  'terms'    => $q['tag_id'],
1348              );
1349          }
1350  
1351          if ( ! empty( $q['tag__in'] ) ) {
1352              $q['tag__in'] = array_map( 'absint', array_unique( (array) $q['tag__in'] ) );
1353              sort( $q['tag__in'] );
1354              $tax_query[] = array(
1355                  'taxonomy' => 'post_tag',
1356                  'terms'    => $q['tag__in'],
1357              );
1358          }
1359  
1360          if ( ! empty( $q['tag__not_in'] ) ) {
1361              $q['tag__not_in'] = array_map( 'absint', array_unique( (array) $q['tag__not_in'] ) );
1362              sort( $q['tag__not_in'] );
1363              $tax_query[]      = array(
1364                  'taxonomy' => 'post_tag',
1365                  'terms'    => $q['tag__not_in'],
1366                  'operator' => 'NOT IN',
1367              );
1368          }
1369  
1370          if ( ! empty( $q['tag__and'] ) ) {
1371              $q['tag__and'] = array_map( 'absint', array_unique( (array) $q['tag__and'] ) );
1372              sort( $q['tag__and'] );
1373              $tax_query[] = array(
1374                  'taxonomy' => 'post_tag',
1375                  'terms'    => $q['tag__and'],
1376                  'operator' => 'AND',
1377              );
1378          }
1379  
1380          if ( ! empty( $q['tag_slug__in'] ) ) {
1381              $q['tag_slug__in'] = array_map( 'sanitize_title_for_query', array_unique( (array) $q['tag_slug__in'] ) );
1382              sort( $q['tag_slug__in'] );
1383              $tax_query[] = array(
1384                  'taxonomy' => 'post_tag',
1385                  'terms'    => $q['tag_slug__in'],
1386                  'field'    => 'slug',
1387              );
1388          }
1389  
1390          if ( ! empty( $q['tag_slug__and'] ) ) {
1391              $q['tag_slug__and'] = array_map( 'sanitize_title_for_query', array_unique( (array) $q['tag_slug__and'] ) );
1392              sort( $q['tag_slug__and'] );
1393              $tax_query[] = array(
1394                  'taxonomy' => 'post_tag',
1395                  'terms'    => $q['tag_slug__and'],
1396                  'field'    => 'slug',
1397                  'operator' => 'AND',
1398              );
1399          }
1400  
1401          $this->tax_query = new WP_Tax_Query( $tax_query );
1402  
1403          /**
1404           * Fires after taxonomy-related query vars have been parsed.
1405           *
1406           * @since 3.7.0
1407           *
1408           * @param WP_Query $query The WP_Query instance.
1409           */
1410          do_action( 'parse_tax_query', $this );
1411      }
1412  
1413      /**
1414       * Generates SQL for the WHERE clause based on passed search terms.
1415       *
1416       * @since 3.7.0
1417       *
1418       * @global wpdb $wpdb WordPress database abstraction object.
1419       *
1420       * @param array $q Query variables.
1421       * @return string WHERE clause.
1422       */
1423  	protected function parse_search( &$q ) {
1424          global $wpdb;
1425  
1426          $search = '';
1427  
1428          // Added slashes screw with quote grouping when done early, so done later.
1429          $q['s'] = stripslashes( $q['s'] );
1430          if ( empty( $_GET['s'] ) && $this->is_main_query() ) {
1431              $q['s'] = urldecode( $q['s'] );
1432          }
1433          // There are no line breaks in <input /> fields.
1434          $q['s']                  = str_replace( array( "\r", "\n" ), '', $q['s'] );
1435          $q['search_terms_count'] = 1;
1436          if ( ! empty( $q['sentence'] ) ) {
1437              $q['search_terms'] = array( $q['s'] );
1438          } else {
1439              if ( preg_match_all( '/".*?("|$)|((?<=[\t ",+])|^)[^\t ",+]+/', $q['s'], $matches ) ) {
1440                  $q['search_terms_count'] = count( $matches[0] );
1441                  $q['search_terms']       = $this->parse_search_terms( $matches[0] );
1442                  // If the search string has only short terms or stopwords, or is 10+ terms long, match it as sentence.
1443                  if ( empty( $q['search_terms'] ) || count( $q['search_terms'] ) > 9 ) {
1444                      $q['search_terms'] = array( $q['s'] );
1445                  }
1446              } else {
1447                  $q['search_terms'] = array( $q['s'] );
1448              }
1449          }
1450  
1451          $n                         = ! empty( $q['exact'] ) ? '' : '%';
1452          $searchand                 = '';
1453          $q['search_orderby_title'] = array();
1454  
1455          $default_search_columns = array( 'post_title', 'post_excerpt', 'post_content' );
1456          $search_columns         = ! empty( $q['search_columns'] ) ? $q['search_columns'] : $default_search_columns;
1457          if ( ! is_array( $search_columns ) ) {
1458              $search_columns = array( $search_columns );
1459          }
1460  
1461          /**
1462           * Filters the columns to search in a WP_Query search.
1463           *
1464           * The supported columns are `post_title`, `post_excerpt` and `post_content`.
1465           * They are all included by default.
1466           *
1467           * @since 6.2.0
1468           *
1469           * @param string[] $search_columns Array of column names to be searched.
1470           * @param string   $search         Text being searched.
1471           * @param WP_Query $query          The current WP_Query instance.
1472           */
1473          $search_columns = (array) apply_filters( 'post_search_columns', $search_columns, $q['s'], $this );
1474  
1475          // Use only supported search columns.
1476          $search_columns = array_intersect( $search_columns, $default_search_columns );
1477          if ( empty( $search_columns ) ) {
1478              $search_columns = $default_search_columns;
1479          }
1480  
1481          /**
1482           * Filters the prefix that indicates that a search term should be excluded from results.
1483           *
1484           * @since 4.7.0
1485           *
1486           * @param string $exclusion_prefix The prefix. Default '-'. Returning
1487           *                                 an empty value disables exclusions.
1488           */
1489          $exclusion_prefix = apply_filters( 'wp_query_search_exclusion_prefix', '-' );
1490  
1491          foreach ( $q['search_terms'] as $term ) {
1492              // If there is an $exclusion_prefix, terms prefixed with it should be excluded.
1493              $exclude = $exclusion_prefix && str_starts_with( $term, $exclusion_prefix );
1494              if ( $exclude ) {
1495                  $like_op  = 'NOT LIKE';
1496                  $andor_op = 'AND';
1497                  $term     = substr( $term, 1 );
1498              } else {
1499                  $like_op  = 'LIKE';
1500                  $andor_op = 'OR';
1501              }
1502  
1503              if ( $n && ! $exclude ) {
1504                  $like                        = '%' . $wpdb->esc_like( $term ) . '%';
1505                  $q['search_orderby_title'][] = $wpdb->prepare( "{$wpdb->posts}.post_title LIKE %s", $like );
1506              }
1507  
1508              $like = $n . $wpdb->esc_like( $term ) . $n;
1509  
1510              $search_columns_parts = array();
1511              foreach ( $search_columns as $search_column ) {
1512                  $search_columns_parts[ $search_column ] = $wpdb->prepare( "({$wpdb->posts}.$search_column $like_op %s)", $like );
1513              }
1514  
1515              if ( ! empty( $this->allow_query_attachment_by_filename ) ) {
1516                  $search_columns_parts['attachment'] = $wpdb->prepare( "(sq1.meta_value $like_op %s)", $like );
1517              }
1518  
1519              $search .= "$searchand(" . implode( " $andor_op ", $search_columns_parts ) . ')';
1520  
1521              $searchand = ' AND ';
1522          }
1523  
1524          if ( ! empty( $search ) ) {
1525              $search = " AND ({$search}) ";
1526              if ( ! is_user_logged_in() ) {
1527                  $search .= " AND ({$wpdb->posts}.post_password = '') ";
1528              }
1529          }
1530  
1531          return $search;
1532      }
1533  
1534      /**
1535       * Checks if the terms are suitable for searching.
1536       *
1537       * Uses an array of stopwords (terms) that are excluded from the separate
1538       * term matching when searching for posts. The list of English stopwords is
1539       * the approximate search engines list, and is translatable.
1540       *
1541       * @since 3.7.0
1542       *
1543       * @param string[] $terms Array of terms to check.
1544       * @return string[] Terms that are not stopwords.
1545       */
1546  	protected function parse_search_terms( $terms ) {
1547          $strtolower = function_exists( 'mb_strtolower' ) ? 'mb_strtolower' : 'strtolower';
1548          $checked    = array();
1549  
1550          $stopwords = $this->get_search_stopwords();
1551  
1552          foreach ( $terms as $term ) {
1553              // Keep before/after spaces when term is for exact match.
1554              if ( preg_match( '/^".+"$/', $term ) ) {
1555                  $term = trim( $term, "\"'" );
1556              } else {
1557                  $term = trim( $term, "\"' " );
1558              }
1559  
1560              // Avoid single A-Z and single dashes.
1561              if ( ! $term || ( 1 === strlen( $term ) && preg_match( '/^[a-z\-]$/i', $term ) ) ) {
1562                  continue;
1563              }
1564  
1565              if ( in_array( call_user_func( $strtolower, $term ), $stopwords, true ) ) {
1566                  continue;
1567              }
1568  
1569              $checked[] = $term;
1570          }
1571  
1572          return $checked;
1573      }
1574  
1575      /**
1576       * Retrieves stopwords used when parsing search terms.
1577       *
1578       * @since 3.7.0
1579       *
1580       * @return string[] Stopwords.
1581       */
1582  	protected function get_search_stopwords() {
1583          if ( isset( $this->stopwords ) ) {
1584              return $this->stopwords;
1585          }
1586  
1587          /*
1588           * translators: This is a comma-separated list of very common words that should be excluded from a search,
1589           * like a, an, and the. These are usually called "stopwords". You should not simply translate these individual
1590           * words into your language. Instead, look for and provide commonly accepted stopwords in your language.
1591           */
1592          $words = explode(
1593              ',',
1594              _x(
1595                  'about,an,are,as,at,be,by,com,for,from,how,in,is,it,of,on,or,that,the,this,to,was,what,when,where,who,will,with,www',
1596                  'Comma-separated list of search stopwords in your language'
1597              )
1598          );
1599  
1600          $stopwords = array();
1601          foreach ( $words as $word ) {
1602              $word = trim( $word, "\r\n\t " );
1603              if ( $word ) {
1604                  $stopwords[] = $word;
1605              }
1606          }
1607  
1608          /**
1609           * Filters stopwords used when parsing search terms.
1610           *
1611           * @since 3.7.0
1612           *
1613           * @param string[] $stopwords Array of stopwords.
1614           */
1615          $this->stopwords = apply_filters( 'wp_search_stopwords', $stopwords );
1616          return $this->stopwords;
1617      }
1618  
1619      /**
1620       * Generates SQL for the ORDER BY condition based on passed search terms.
1621       *
1622       * @since 3.7.0
1623       *
1624       * @global wpdb $wpdb WordPress database abstraction object.
1625       *
1626       * @param array $q Query variables.
1627       * @return string ORDER BY clause.
1628       */
1629  	protected function parse_search_order( &$q ) {
1630          global $wpdb;
1631  
1632          if ( $q['search_terms_count'] > 1 ) {
1633              $num_terms = count( $q['search_orderby_title'] );
1634  
1635              // If the search terms contain negative queries, don't bother ordering by sentence matches.
1636              $like = '';
1637              if ( ! preg_match( '/(?:\s|^)\-/', $q['s'] ) ) {
1638                  $like = '%' . $wpdb->esc_like( $q['s'] ) . '%';
1639              }
1640  
1641              $search_orderby = '';
1642  
1643              // Sentence match in 'post_title'.
1644              if ( $like ) {
1645                  $search_orderby .= $wpdb->prepare( "WHEN {$wpdb->posts}.post_title LIKE %s THEN 1 ", $like );
1646              }
1647  
1648              /*
1649               * Sanity limit, sort as sentence when more than 6 terms
1650               * (few searches are longer than 6 terms and most titles are not).
1651               */
1652              if ( $num_terms < 7 ) {
1653                  // All words in title.
1654                  $search_orderby .= 'WHEN ' . implode( ' AND ', $q['search_orderby_title'] ) . ' THEN 2 ';
1655                  // Any word in title, not needed when $num_terms == 1.
1656                  if ( $num_terms > 1 ) {
1657                      $search_orderby .= 'WHEN ' . implode( ' OR ', $q['search_orderby_title'] ) . ' THEN 3 ';
1658                  }
1659              }
1660  
1661              // Sentence match in 'post_content' and 'post_excerpt'.
1662              if ( $like ) {
1663                  $search_orderby .= $wpdb->prepare( "WHEN {$wpdb->posts}.post_excerpt LIKE %s THEN 4 ", $like );
1664                  $search_orderby .= $wpdb->prepare( "WHEN {$wpdb->posts}.post_content LIKE %s THEN 5 ", $like );
1665              }
1666  
1667              if ( $search_orderby ) {
1668                  $search_orderby = '(CASE ' . $search_orderby . 'ELSE 6 END)';
1669              }
1670          } else {
1671              // Single word or sentence search.
1672              $search_orderby = reset( $q['search_orderby_title'] ) . ' DESC';
1673          }
1674  
1675          return $search_orderby;
1676      }
1677  
1678      /**
1679       * Converts the given orderby alias (if allowed) to a properly-prefixed value.
1680       *
1681       * @since 4.0.0
1682       *
1683       * @global wpdb $wpdb WordPress database abstraction object.
1684       *
1685       * @param string $orderby Alias for the field to order by.
1686       * @return string|false Table-prefixed value to used in the ORDER clause. False otherwise.
1687       */
1688  	protected function parse_orderby( $orderby ) {
1689          global $wpdb;
1690  
1691          // Used to filter values.
1692          $allowed_keys = array(
1693              'post_name',
1694              'post_author',
1695              'post_date',
1696              'post_title',
1697              'post_modified',
1698              'post_parent',
1699              'post_type',
1700              'name',
1701              'author',
1702              'date',
1703              'title',
1704              'modified',
1705              'parent',
1706              'type',
1707              'ID',
1708              'menu_order',
1709              'comment_count',
1710              'rand',
1711              'post__in',
1712              'post_parent__in',
1713              'post_name__in',
1714          );
1715  
1716          $primary_meta_key   = '';
1717          $primary_meta_query = false;
1718          $meta_clauses       = $this->meta_query->get_clauses();
1719          if ( ! empty( $meta_clauses ) ) {
1720              $primary_meta_query = reset( $meta_clauses );
1721  
1722              if ( ! empty( $primary_meta_query['key'] ) ) {
1723                  $primary_meta_key = $primary_meta_query['key'];
1724                  $allowed_keys[]   = $primary_meta_key;
1725              }
1726  
1727              $allowed_keys[] = 'meta_value';
1728              $allowed_keys[] = 'meta_value_num';
1729              $allowed_keys   = array_merge( $allowed_keys, array_keys( $meta_clauses ) );
1730          }
1731  
1732          // If RAND() contains a seed value, sanitize and add to allowed keys.
1733          $rand_with_seed = false;
1734          if ( preg_match( '/RAND\(([0-9]+)\)/i', $orderby, $matches ) ) {
1735              $orderby        = sprintf( 'RAND(%s)', (int) $matches[1] );
1736              $allowed_keys[] = $orderby;
1737              $rand_with_seed = true;
1738          }
1739  
1740          if ( ! in_array( $orderby, $allowed_keys, true ) ) {
1741              return false;
1742          }
1743  
1744          $orderby_clause = '';
1745  
1746          switch ( $orderby ) {
1747              case 'post_name':
1748              case 'post_author':
1749              case 'post_date':
1750              case 'post_title':
1751              case 'post_modified':
1752              case 'post_parent':
1753              case 'post_type':
1754              case 'ID':
1755              case 'menu_order':
1756              case 'comment_count':
1757                  $orderby_clause = "{$wpdb->posts}.{$orderby}";
1758                  break;
1759              case 'rand':
1760                  $orderby_clause = 'RAND()';
1761                  break;
1762              case $primary_meta_key:
1763              case 'meta_value':
1764                  if ( ! empty( $primary_meta_query['type'] ) ) {
1765                      $orderby_clause = "CAST({$primary_meta_query['alias']}.meta_value AS {$primary_meta_query['cast']})";
1766                  } else {
1767                      $orderby_clause = "{$primary_meta_query['alias']}.meta_value";
1768                  }
1769                  break;
1770              case 'meta_value_num':
1771                  $orderby_clause = "{$primary_meta_query['alias']}.meta_value+0";
1772                  break;
1773              case 'post__in':
1774                  if ( ! empty( $this->query_vars['post__in'] ) ) {
1775                      $orderby_clause = "FIELD({$wpdb->posts}.ID," . implode( ',', array_map( 'absint', $this->query_vars['post__in'] ) ) . ')';
1776                  }
1777                  break;
1778              case 'post_parent__in':
1779                  if ( ! empty( $this->query_vars['post_parent__in'] ) ) {
1780                      $orderby_clause = "FIELD( {$wpdb->posts}.post_parent," . implode( ', ', array_map( 'absint', $this->query_vars['post_parent__in'] ) ) . ' )';
1781                  }
1782                  break;
1783              case 'post_name__in':
1784                  if ( ! empty( $this->query_vars['post_name__in'] ) ) {
1785                      $post_name__in        = array_map( 'sanitize_title_for_query', $this->query_vars['post_name__in'] );
1786                      $post_name__in_string = "'" . implode( "','", $post_name__in ) . "'";
1787                      $orderby_clause       = "FIELD( {$wpdb->posts}.post_name," . $post_name__in_string . ' )';
1788                  }
1789                  break;
1790              default:
1791                  if ( array_key_exists( $orderby, $meta_clauses ) ) {
1792                      // $orderby corresponds to a meta_query clause.
1793                      $meta_clause    = $meta_clauses[ $orderby ];
1794                      $orderby_clause = "CAST({$meta_clause['alias']}.meta_value AS {$meta_clause['cast']})";
1795                  } elseif ( $rand_with_seed ) {
1796                      $orderby_clause = $orderby;
1797                  } else {
1798                      // Default: order by post field.
1799                      $orderby_clause = "{$wpdb->posts}.post_" . sanitize_key( $orderby );
1800                  }
1801  
1802                  break;
1803          }
1804  
1805          return $orderby_clause;
1806      }
1807  
1808      /**
1809       * Parse an 'order' query variable and cast it to ASC or DESC as necessary.
1810       *
1811       * @since 4.0.0
1812       *
1813       * @param string $order The 'order' query variable.
1814       * @return string The sanitized 'order' query variable.
1815       */
1816  	protected function parse_order( $order ) {
1817          if ( ! is_string( $order ) || empty( $order ) ) {
1818              return 'DESC';
1819          }
1820  
1821          if ( 'ASC' === strtoupper( $order ) ) {
1822              return 'ASC';
1823          } else {
1824              return 'DESC';
1825          }
1826      }
1827  
1828      /**
1829       * Sets the 404 property and saves whether query is feed.
1830       *
1831       * @since 2.0.0
1832       */
1833  	public function set_404() {
1834          $is_feed = $this->is_feed;
1835  
1836          $this->init_query_flags();
1837          $this->is_404 = true;
1838  
1839          $this->is_feed = $is_feed;
1840  
1841          /**
1842           * Fires after a 404 is triggered.
1843           *
1844           * @since 5.5.0
1845           *
1846           * @param WP_Query $query The WP_Query instance (passed by reference).
1847           */
1848          do_action_ref_array( 'set_404', array( $this ) );
1849      }
1850  
1851      /**
1852       * Retrieves the value of a query variable.
1853       *
1854       * @since 1.5.0
1855       * @since 3.9.0 The `$default_value` argument was introduced.
1856       *
1857       * @param string $query_var     Query variable key.
1858       * @param mixed  $default_value Optional. Value to return if the query variable is not set.
1859       *                              Default empty string.
1860       * @return mixed Contents of the query variable.
1861       */
1862  	public function get( $query_var, $default_value = '' ) {
1863          if ( isset( $this->query_vars[ $query_var ] ) ) {
1864              return $this->query_vars[ $query_var ];
1865          }
1866  
1867          return $default_value;
1868      }
1869  
1870      /**
1871       * Sets the value of a query variable.
1872       *
1873       * @since 1.5.0
1874       *
1875       * @param string $query_var Query variable key.
1876       * @param mixed  $value     Query variable value.
1877       */
1878  	public function set( $query_var, $value ) {
1879          $this->query_vars[ $query_var ] = $value;
1880      }
1881  
1882      /**
1883       * Retrieves an array of posts based on query variables.
1884       *
1885       * There are a few filters and actions that can be used to modify the post
1886       * database query.
1887       *
1888       * @since 1.5.0
1889       *
1890       * @global wpdb $wpdb WordPress database abstraction object.
1891       *
1892       * @return WP_Post[]|int[] Array of post objects or post IDs.
1893       */
1894  	public function get_posts() {
1895          global $wpdb;
1896  
1897          $this->parse_query();
1898  
1899          /**
1900           * Fires after the query variable object is created, but before the actual query is run.
1901           *
1902           * Note: If using conditional tags, use the method versions within the passed instance
1903           * (e.g. $this->is_main_query() instead of is_main_query()). This is because the functions
1904           * like is_main_query() test against the global $wp_query instance, not the passed one.
1905           *
1906           * @since 2.0.0
1907           *
1908           * @param WP_Query $query The WP_Query instance (passed by reference).
1909           */
1910          do_action_ref_array( 'pre_get_posts', array( &$this ) );
1911  
1912          // Shorthand.
1913          $q = &$this->query_vars;
1914  
1915          // Fill again in case 'pre_get_posts' unset some vars.
1916          $q = $this->fill_query_vars( $q );
1917  
1918          /**
1919           * Filters whether an attachment query should include filenames or not.
1920           *
1921           * @since 6.0.3
1922           *
1923           * @param bool $allow_query_attachment_by_filename Whether or not to include filenames.
1924           */
1925          $this->allow_query_attachment_by_filename = apply_filters( 'wp_allow_query_attachment_by_filename', false );
1926          remove_all_filters( 'wp_allow_query_attachment_by_filename' );
1927  
1928          // Parse meta query.
1929          $this->meta_query = new WP_Meta_Query();
1930          $this->meta_query->parse_query_vars( $q );
1931  
1932          // Set a flag if a 'pre_get_posts' hook changed the query vars.
1933          $hash = md5( serialize( $this->query_vars ) );
1934          if ( $hash != $this->query_vars_hash ) {
1935              $this->query_vars_changed = true;
1936              $this->query_vars_hash    = $hash;
1937          }
1938          unset( $hash );
1939  
1940          // First let's clear some variables.
1941          $distinct         = '';
1942          $whichauthor      = '';
1943          $whichmimetype    = '';
1944          $where            = '';
1945          $limits           = '';
1946          $join             = '';
1947          $search           = '';
1948          $groupby          = '';
1949          $post_status_join = false;
1950          $page             = 1;
1951  
1952          if ( isset( $q['caller_get_posts'] ) ) {
1953              _deprecated_argument(
1954                  'WP_Query',
1955                  '3.1.0',
1956                  sprintf(
1957                      /* translators: 1: caller_get_posts, 2: ignore_sticky_posts */
1958                      __( '%1$s is deprecated. Use %2$s instead.' ),
1959                      '<code>caller_get_posts</code>',
1960                      '<code>ignore_sticky_posts</code>'
1961                  )
1962              );
1963  
1964              if ( ! isset( $q['ignore_sticky_posts'] ) ) {
1965                  $q['ignore_sticky_posts'] = $q['caller_get_posts'];
1966              }
1967          }
1968  
1969          if ( ! isset( $q['ignore_sticky_posts'] ) ) {
1970              $q['ignore_sticky_posts'] = false;
1971          }
1972  
1973          if ( ! isset( $q['suppress_filters'] ) ) {
1974              $q['suppress_filters'] = false;
1975          }
1976  
1977          if ( ! isset( $q['cache_results'] ) ) {
1978              $q['cache_results'] = true;
1979          }
1980  
1981          if ( ! isset( $q['update_post_term_cache'] ) ) {
1982              $q['update_post_term_cache'] = true;
1983          }
1984  
1985          if ( ! isset( $q['update_menu_item_cache'] ) ) {
1986              $q['update_menu_item_cache'] = false;
1987          }
1988  
1989          if ( ! isset( $q['lazy_load_term_meta'] ) ) {
1990              $q['lazy_load_term_meta'] = $q['update_post_term_cache'];
1991          } elseif ( $q['lazy_load_term_meta'] ) { // Lazy loading term meta only works if term caches are primed.
1992              $q['update_post_term_cache'] = true;
1993          }
1994  
1995          if ( ! isset( $q['update_post_meta_cache'] ) ) {
1996              $q['update_post_meta_cache'] = true;
1997          }
1998  
1999          if ( ! isset( $q['post_type'] ) ) {
2000              if ( $this->is_search ) {
2001                  $q['post_type'] = 'any';
2002              } else {
2003                  $q['post_type'] = '';
2004              }
2005          }
2006          $post_type = $q['post_type'];
2007          if ( empty( $q['posts_per_page'] ) ) {
2008              $q['posts_per_page'] = get_option( 'posts_per_page' );
2009          }
2010          if ( isset( $q['showposts'] ) && $q['showposts'] ) {
2011              $q['showposts']      = (int) $q['showposts'];
2012              $q['posts_per_page'] = $q['showposts'];
2013          }
2014          if ( ( isset( $q['posts_per_archive_page'] ) && 0 != $q['posts_per_archive_page'] ) && ( $this->is_archive || $this->is_search ) ) {
2015              $q['posts_per_page'] = $q['posts_per_archive_page'];
2016          }
2017          if ( ! isset( $q['nopaging'] ) ) {
2018              if ( -1 == $q['posts_per_page'] ) {
2019                  $q['nopaging'] = true;
2020              } else {
2021                  $q['nopaging'] = false;
2022              }
2023          }
2024  
2025          if ( $this->is_feed ) {
2026              // This overrides 'posts_per_page'.
2027              if ( ! empty( $q['posts_per_rss'] ) ) {
2028                  $q['posts_per_page'] = $q['posts_per_rss'];
2029              } else {
2030                  $q['posts_per_page'] = get_option( 'posts_per_rss' );
2031              }
2032              $q['nopaging'] = false;
2033          }
2034          $q['posts_per_page'] = (int) $q['posts_per_page'];
2035          if ( $q['posts_per_page'] < -1 ) {
2036              $q['posts_per_page'] = abs( $q['posts_per_page'] );
2037          } elseif ( 0 == $q['posts_per_page'] ) {
2038              $q['posts_per_page'] = 1;
2039          }
2040  
2041          if ( ! isset( $q['comments_per_page'] ) || 0 == $q['comments_per_page'] ) {
2042              $q['comments_per_page'] = get_option( 'comments_per_page' );
2043          }
2044  
2045          if ( $this->is_home && ( empty( $this->query ) || 'true' === $q['preview'] ) && ( 'page' === get_option( 'show_on_front' ) ) && get_option( 'page_on_front' ) ) {
2046              $this->is_page = true;
2047              $this->is_home = false;
2048              $q['page_id']  = get_option( 'page_on_front' );
2049          }
2050  
2051          if ( isset( $q['page'] ) ) {
2052              $q['page'] = is_scalar( $q['page'] ) ? absint( trim( $q['page'], '/' ) ) : 0;
2053          }
2054  
2055          // If true, forcibly turns off SQL_CALC_FOUND_ROWS even when limits are present.
2056          if ( isset( $q['no_found_rows'] ) ) {
2057              $q['no_found_rows'] = (bool) $q['no_found_rows'];
2058          } else {
2059              $q['no_found_rows'] = false;
2060          }
2061  
2062          switch ( $q['fields'] ) {
2063              case 'ids':
2064                  $fields = "{$wpdb->posts}.ID";
2065                  break;
2066              case 'id=>parent':
2067                  $fields = "{$wpdb->posts}.ID, {$wpdb->posts}.post_parent";
2068                  break;
2069              default:
2070                  $fields = "{$wpdb->posts}.*";
2071          }
2072  
2073          if ( '' !== $q['menu_order'] ) {
2074              $where .= " AND {$wpdb->posts}.menu_order = " . $q['menu_order'];
2075          }
2076          // The "m" parameter is meant for months but accepts datetimes of varying specificity.
2077          if ( $q['m'] ) {
2078              $where .= " AND YEAR({$wpdb->posts}.post_date)=" . substr( $q['m'], 0, 4 );
2079              if ( strlen( $q['m'] ) > 5 ) {
2080                  $where .= " AND MONTH({$wpdb->posts}.post_date)=" . substr( $q['m'], 4, 2 );
2081              }
2082              if ( strlen( $q['m'] ) > 7 ) {
2083                  $where .= " AND DAYOFMONTH({$wpdb->posts}.post_date)=" . substr( $q['m'], 6, 2 );
2084              }
2085              if ( strlen( $q['m'] ) > 9 ) {
2086                  $where .= " AND HOUR({$wpdb->posts}.post_date)=" . substr( $q['m'], 8, 2 );
2087              }
2088              if ( strlen( $q['m'] ) > 11 ) {
2089                  $where .= " AND MINUTE({$wpdb->posts}.post_date)=" . substr( $q['m'], 10, 2 );
2090              }
2091              if ( strlen( $q['m'] ) > 13 ) {
2092                  $where .= " AND SECOND({$wpdb->posts}.post_date)=" . substr( $q['m'], 12, 2 );
2093              }
2094          }
2095  
2096          // Handle the other individual date parameters.
2097          $date_parameters = array();
2098  
2099          if ( '' !== $q['hour'] ) {
2100              $date_parameters['hour'] = $q['hour'];
2101          }
2102  
2103          if ( '' !== $q['minute'] ) {
2104              $date_parameters['minute'] = $q['minute'];
2105          }
2106  
2107          if ( '' !== $q['second'] ) {
2108              $date_parameters['second'] = $q['second'];
2109          }
2110  
2111          if ( $q['year'] ) {
2112              $date_parameters['year'] = $q['year'];
2113          }
2114  
2115          if ( $q['monthnum'] ) {
2116              $date_parameters['monthnum'] = $q['monthnum'];
2117          }
2118  
2119          if ( $q['w'] ) {
2120              $date_parameters['week'] = $q['w'];
2121          }
2122  
2123          if ( $q['day'] ) {
2124              $date_parameters['day'] = $q['day'];
2125          }
2126  
2127          if ( $date_parameters ) {
2128              $date_query = new WP_Date_Query( array( $date_parameters ) );
2129              $where     .= $date_query->get_sql();
2130          }
2131          unset( $date_parameters, $date_query );
2132  
2133          // Handle complex date queries.
2134          if ( ! empty( $q['date_query'] ) ) {
2135              $this->date_query = new WP_Date_Query( $q['date_query'] );
2136              $where           .= $this->date_query->get_sql();
2137          }
2138  
2139          // If we've got a post_type AND it's not "any" post_type.
2140          if ( ! empty( $q['post_type'] ) && 'any' !== $q['post_type'] ) {
2141              foreach ( (array) $q['post_type'] as $_post_type ) {
2142                  $ptype_obj = get_post_type_object( $_post_type );
2143                  if ( ! $ptype_obj || ! $ptype_obj->query_var || empty( $q[ $ptype_obj->query_var ] ) ) {
2144                      continue;
2145                  }
2146  
2147                  if ( ! $ptype_obj->hierarchical ) {
2148                      // Non-hierarchical post types can directly use 'name'.
2149                      $q['name'] = $q[ $ptype_obj->query_var ];
2150                  } else {
2151                      // Hierarchical post types will operate through 'pagename'.
2152                      $q['pagename'] = $q[ $ptype_obj->query_var ];
2153                      $q['name']     = '';
2154                  }
2155  
2156                  // Only one request for a slug is possible, this is why name & pagename are overwritten above.
2157                  break;
2158              } // End foreach.
2159              unset( $ptype_obj );
2160          }
2161  
2162          if ( '' !== $q['title'] ) {
2163              $where .= $wpdb->prepare( " AND {$wpdb->posts}.post_title = %s", stripslashes( $q['title'] ) );
2164          }
2165  
2166          // Parameters related to 'post_name'.
2167          if ( '' !== $q['name'] ) {
2168              $q['name'] = sanitize_title_for_query( $q['name'] );
2169              $where    .= " AND {$wpdb->posts}.post_name = '" . $q['name'] . "'";
2170          } elseif ( '' !== $q['pagename'] ) {
2171              if ( isset( $this->queried_object_id ) ) {
2172                  $reqpage = $this->queried_object_id;
2173              } else {
2174                  if ( 'page' !== $q['post_type'] ) {
2175                      foreach ( (array) $q['post_type'] as $_post_type ) {
2176                          $ptype_obj = get_post_type_object( $_post_type );
2177                          if ( ! $ptype_obj || ! $ptype_obj->hierarchical ) {
2178                              continue;
2179                          }
2180  
2181                          $reqpage = get_page_by_path( $q['pagename'], OBJECT, $_post_type );
2182                          if ( $reqpage ) {
2183                              break;
2184                          }
2185                      }
2186                      unset( $ptype_obj );
2187                  } else {
2188                      $reqpage = get_page_by_path( $q['pagename'] );
2189                  }
2190                  if ( ! empty( $reqpage ) ) {
2191                      $reqpage = $reqpage->ID;
2192                  } else {
2193                      $reqpage = 0;
2194                  }
2195              }
2196  
2197              $page_for_posts = get_option( 'page_for_posts' );
2198              if ( ( 'page' !== get_option( 'show_on_front' ) ) || empty( $page_for_posts ) || ( $reqpage != $page_for_posts ) ) {
2199                  $q['pagename'] = sanitize_title_for_query( wp_basename( $q['pagename'] ) );
2200                  $q['name']     = $q['pagename'];
2201                  $where        .= " AND ({$wpdb->posts}.ID = '$reqpage')";
2202                  $reqpage_obj   = get_post( $reqpage );
2203                  if ( is_object( $reqpage_obj ) && 'attachment' === $reqpage_obj->post_type ) {
2204                      $this->is_attachment = true;
2205                      $post_type           = 'attachment';
2206                      $q['post_type']      = 'attachment';
2207                      $this->is_page       = true;
2208                      $q['attachment_id']  = $reqpage;
2209                  }
2210              }
2211          } elseif ( '' !== $q['attachment'] ) {
2212              $q['attachment'] = sanitize_title_for_query( wp_basename( $q['attachment'] ) );
2213              $q['name']       = $q['attachment'];
2214              $where          .= " AND {$wpdb->posts}.post_name = '" . $q['attachment'] . "'";
2215          } elseif ( is_array( $q['post_name__in'] ) && ! empty( $q['post_name__in'] ) ) {
2216              $q['post_name__in'] = array_map( 'sanitize_title_for_query', $q['post_name__in'] );
2217              // Duplicate array before sorting to allow for the orderby clause.
2218              $post_name__in_for_where = array_unique( $q['post_name__in'] );
2219              sort( $post_name__in_for_where );
2220              $post_name__in = "'" . implode( "','", $post_name__in_for_where ) . "'";
2221              $where        .= " AND {$wpdb->posts}.post_name IN ($post_name__in)";
2222          }
2223  
2224          // If an attachment is requested by number, let it supersede any post number.
2225          if ( $q['attachment_id'] ) {
2226              $q['p'] = absint( $q['attachment_id'] );
2227          }
2228  
2229          // If a post number is specified, load that post.
2230          if ( $q['p'] ) {
2231              $where .= " AND {$wpdb->posts}.ID = " . $q['p'];
2232          } elseif ( $q['post__in'] ) {
2233              // Duplicate array before sorting to allow for the orderby clause.
2234              $post__in_for_where = $q['post__in'];
2235              $post__in_for_where = array_unique( array_map( 'absint', $post__in_for_where ) );
2236              sort( $post__in_for_where );
2237              $post__in = implode( ',', array_map( 'absint', $post__in_for_where ) );
2238              $where   .= " AND {$wpdb->posts}.ID IN ($post__in)";
2239          } elseif ( $q['post__not_in'] ) {
2240              sort( $q['post__not_in'] );
2241              $post__not_in = implode( ',', array_map( 'absint', $q['post__not_in'] ) );
2242              $where       .= " AND {$wpdb->posts}.ID NOT IN ($post__not_in)";
2243          }
2244  
2245          if ( is_numeric( $q['post_parent'] ) ) {
2246              $where .= $wpdb->prepare( " AND {$wpdb->posts}.post_parent = %d ", $q['post_parent'] );
2247          } elseif ( $q['post_parent__in'] ) {
2248              // Duplicate array before sorting to allow for the orderby clause.
2249              $post_parent__in_for_where = $q['post_parent__in'];
2250              $post_parent__in_for_where = array_unique( array_map( 'absint', $post_parent__in_for_where ) );
2251              sort( $post_parent__in_for_where );
2252              $post_parent__in = implode( ',', array_map( 'absint', $post_parent__in_for_where ) );
2253              $where          .= " AND {$wpdb->posts}.post_parent IN ($post_parent__in)";
2254          } elseif ( $q['post_parent__not_in'] ) {
2255              sort( $q['post_parent__not_in'] );
2256              $post_parent__not_in = implode( ',', array_map( 'absint', $q['post_parent__not_in'] ) );
2257              $where              .= " AND {$wpdb->posts}.post_parent NOT IN ($post_parent__not_in)";
2258          }
2259  
2260          if ( $q['page_id'] ) {
2261              if ( ( 'page' !== get_option( 'show_on_front' ) ) || ( get_option( 'page_for_posts' ) != $q['page_id'] ) ) {
2262                  $q['p'] = $q['page_id'];
2263                  $where  = " AND {$wpdb->posts}.ID = " . $q['page_id'];
2264              }
2265          }
2266  
2267          // If a search pattern is specified, load the posts that match.
2268          if ( strlen( $q['s'] ) ) {
2269              $search = $this->parse_search( $q );
2270          }
2271  
2272          if ( ! $q['suppress_filters'] ) {
2273              /**
2274               * Filters the search SQL that is used in the WHERE clause of WP_Query.
2275               *
2276               * @since 3.0.0
2277               *
2278               * @param string   $search Search SQL for WHERE clause.
2279               * @param WP_Query $query  The current WP_Query object.
2280               */
2281              $search = apply_filters_ref_array( 'posts_search', array( $search, &$this ) );
2282          }
2283  
2284          // Taxonomies.
2285          if ( ! $this->is_singular ) {
2286              $this->parse_tax_query( $q );
2287  
2288              $clauses = $this->tax_query->get_sql( $wpdb->posts, 'ID' );
2289  
2290              $join  .= $clauses['join'];
2291              $where .= $clauses['where'];
2292          }
2293  
2294          if ( $this->is_tax ) {
2295              if ( empty( $post_type ) ) {
2296                  // Do a fully inclusive search for currently registered post types of queried taxonomies.
2297                  $post_type  = array();
2298                  $taxonomies = array_keys( $this->tax_query->queried_terms );
2299                  foreach ( get_post_types( array( 'exclude_from_search' => false ) ) as $pt ) {
2300                      $object_taxonomies = 'attachment' === $pt ? get_taxonomies_for_attachments() : get_object_taxonomies( $pt );
2301                      if ( array_intersect( $taxonomies, $object_taxonomies ) ) {
2302                          $post_type[] = $pt;
2303                      }
2304                  }
2305                  if ( ! $post_type ) {
2306                      $post_type = 'any';
2307                  } elseif ( count( $post_type ) === 1 ) {
2308                      $post_type = $post_type[0];
2309                  } else {
2310                      // Sort post types to ensure same cache key generation.
2311                      sort( $post_type );
2312                  }
2313  
2314                  $post_status_join = true;
2315              } elseif ( in_array( 'attachment', (array) $post_type, true ) ) {
2316                  $post_status_join = true;
2317              }
2318          }
2319  
2320          /*
2321           * Ensure that 'taxonomy', 'term', 'term_id', 'cat', and
2322           * 'category_name' vars are set for backward compatibility.
2323           */
2324          if ( ! empty( $this->tax_query->queried_terms ) ) {
2325  
2326              /*
2327               * Set 'taxonomy', 'term', and 'term_id' to the
2328               * first taxonomy other than 'post_tag' or 'category'.
2329               */
2330              if ( ! isset( $q['taxonomy'] ) ) {
2331                  foreach ( $this->tax_query->queried_terms as $queried_taxonomy => $queried_items ) {
2332                      if ( empty( $queried_items['terms'][0] ) ) {
2333                          continue;
2334                      }
2335  
2336                      if ( ! in_array( $queried_taxonomy, array( 'category', 'post_tag' ), true ) ) {
2337                          $q['taxonomy'] = $queried_taxonomy;
2338  
2339                          if ( 'slug' === $queried_items['field'] ) {
2340                              $q['term'] = $queried_items['terms'][0];
2341                          } else {
2342                              $q['term_id'] = $queried_items['terms'][0];
2343                          }
2344  
2345                          // Take the first one we find.
2346                          break;
2347                      }
2348                  }
2349              }
2350  
2351              // 'cat', 'category_name', 'tag_id'.
2352              foreach ( $this->tax_query->queried_terms as $queried_taxonomy => $queried_items ) {
2353                  if ( empty( $queried_items['terms'][0] ) ) {
2354                      continue;
2355                  }
2356  
2357                  if ( 'category' === $queried_taxonomy ) {
2358                      $the_cat = get_term_by( $queried_items['field'], $queried_items['terms'][0], 'category' );
2359                      if ( $the_cat ) {
2360                          $this->set( 'cat', $the_cat->term_id );
2361                          $this->set( 'category_name', $the_cat->slug );
2362                      }
2363                      unset( $the_cat );
2364                  }
2365  
2366                  if ( 'post_tag' === $queried_taxonomy ) {
2367                      $the_tag = get_term_by( $queried_items['field'], $queried_items['terms'][0], 'post_tag' );
2368                      if ( $the_tag ) {
2369                          $this->set( 'tag_id', $the_tag->term_id );
2370                      }
2371                      unset( $the_tag );
2372                  }
2373              }
2374          }
2375  
2376          if ( ! empty( $this->tax_query->queries ) || ! empty( $this->meta_query->queries ) || ! empty( $this->allow_query_attachment_by_filename ) ) {
2377              $groupby = "{$wpdb->posts}.ID";
2378          }
2379  
2380          // Author/user stuff.
2381  
2382          if ( ! empty( $q['author'] ) && '0' != $q['author'] ) {
2383              $q['author'] = addslashes_gpc( '' . urldecode( $q['author'] ) );
2384              $authors     = array_unique( array_map( 'intval', preg_split( '/[,\s]+/', $q['author'] ) ) );
2385              sort( $authors );
2386              foreach ( $authors as $author ) {
2387                  $key         = $author > 0 ? 'author__in' : 'author__not_in';
2388                  $q[ $key ][] = abs( $author );
2389              }
2390              $q['author'] = implode( ',', $authors );
2391          }
2392  
2393          if ( ! empty( $q['author__not_in'] ) ) {
2394              if ( is_array( $q['author__not_in'] ) ) {
2395                  $q['author__not_in'] = array_unique( array_map( 'absint', $q['author__not_in'] ) );
2396                  sort( $q['author__not_in'] );
2397              }
2398              $author__not_in = implode( ',', (array) $q['author__not_in'] );
2399              $where         .= " AND {$wpdb->posts}.post_author NOT IN ($author__not_in) ";
2400          } elseif ( ! empty( $q['author__in'] ) ) {
2401              if ( is_array( $q['author__in'] ) ) {
2402                  $q['author__in'] = array_unique( array_map( 'absint', $q['author__in'] ) );
2403                  sort( $q['author__in'] );
2404              }
2405              $author__in = implode( ',', array_map( 'absint', array_unique( (array) $q['author__in'] ) ) );
2406              $where     .= " AND {$wpdb->posts}.post_author IN ($author__in) ";
2407          }
2408  
2409          // Author stuff for nice URLs.
2410  
2411          if ( '' !== $q['author_name'] ) {
2412              if ( str_contains( $q['author_name'], '/' ) ) {
2413                  $q['author_name'] = explode( '/', $q['author_name'] );
2414                  if ( $q['author_name'][ count( $q['author_name'] ) - 1 ] ) {
2415                      $q['author_name'] = $q['author_name'][ count( $q['author_name'] ) - 1 ]; // No trailing slash.
2416                  } else {
2417                      $q['author_name'] = $q['author_name'][ count( $q['author_name'] ) - 2 ]; // There was a trailing slash.
2418                  }
2419              }
2420              $q['author_name'] = sanitize_title_for_query( $q['author_name'] );
2421              $q['author']      = get_user_by( 'slug', $q['author_name'] );
2422              if ( $q['author'] ) {
2423                  $q['author'] = $q['author']->ID;
2424              }
2425              $whichauthor .= " AND ({$wpdb->posts}.post_author = " . absint( $q['author'] ) . ')';
2426          }
2427  
2428          // Matching by comment count.
2429          if ( isset( $q['comment_count'] ) ) {
2430              // Numeric comment count is converted to array format.
2431              if ( is_numeric( $q['comment_count'] ) ) {
2432                  $q['comment_count'] = array(
2433                      'value' => (int) $q['comment_count'],
2434                  );
2435              }
2436  
2437              if ( isset( $q['comment_count']['value'] ) ) {
2438                  $q['comment_count'] = array_merge(
2439                      array(
2440                          'compare' => '=',
2441                      ),
2442                      $q['comment_count']
2443                  );
2444  
2445                  // Fallback for invalid compare operators is '='.
2446                  $compare_operators = array( '=', '!=', '>', '>=', '<', '<=' );
2447                  if ( ! in_array( $q['comment_count']['compare'], $compare_operators, true ) ) {
2448                      $q['comment_count']['compare'] = '=';
2449                  }
2450  
2451                  $where .= $wpdb->prepare( " AND {$wpdb->posts}.comment_count {$q['comment_count']['compare']} %d", $q['comment_count']['value'] );
2452              }
2453          }
2454  
2455          // MIME-Type stuff for attachment browsing.
2456  
2457          if ( isset( $q['post_mime_type'] ) && '' !== $q['post_mime_type'] ) {
2458              $whichmimetype = wp_post_mime_type_where( $q['post_mime_type'], $wpdb->posts );
2459          }
2460          $where .= $search . $whichauthor . $whichmimetype;
2461  
2462          if ( ! empty( $this->allow_query_attachment_by_filename ) ) {
2463              $join .= " LEFT JOIN {$wpdb->postmeta} AS sq1 ON ( {$wpdb->posts}.ID = sq1.post_id AND sq1.meta_key = '_wp_attached_file' )";
2464          }
2465  
2466          if ( ! empty( $this->meta_query->queries ) ) {
2467              $clauses = $this->meta_query->get_sql( 'post', $wpdb->posts, 'ID', $this );
2468              $join   .= $clauses['join'];
2469              $where  .= $clauses['where'];
2470          }
2471  
2472          $rand = ( isset( $q['orderby'] ) && 'rand' === $q['orderby'] );
2473          if ( ! isset( $q['order'] ) ) {
2474              $q['order'] = $rand ? '' : 'DESC';
2475          } else {
2476              $q['order'] = $rand ? '' : $this->parse_order( $q['order'] );
2477          }
2478  
2479          // These values of orderby should ignore the 'order' parameter.
2480          $force_asc = array( 'post__in', 'post_name__in', 'post_parent__in' );
2481          if ( isset( $q['orderby'] ) && in_array( $q['orderby'], $force_asc, true ) ) {
2482              $q['order'] = '';
2483          }
2484  
2485          // Order by.
2486          if ( empty( $q['orderby'] ) ) {
2487              /*
2488               * Boolean false or empty array blanks out ORDER BY,
2489               * while leaving the value unset or otherwise empty sets the default.
2490               */
2491              if ( isset( $q['orderby'] ) && ( is_array( $q['orderby'] ) || false === $q['orderby'] ) ) {
2492                  $orderby = '';
2493              } else {
2494                  $orderby = "{$wpdb->posts}.post_date " . $q['order'];
2495              }
2496          } elseif ( 'none' === $q['orderby'] ) {
2497              $orderby = '';
2498          } else {
2499              $orderby_array = array();
2500              if ( is_array( $q['orderby'] ) ) {
2501                  foreach ( $q['orderby'] as $_orderby => $order ) {
2502                      $orderby = addslashes_gpc( urldecode( $_orderby ) );
2503                      $parsed  = $this->parse_orderby( $orderby );
2504  
2505                      if ( ! $parsed ) {
2506                          continue;
2507                      }
2508  
2509                      $orderby_array[] = $parsed . ' ' . $this->parse_order( $order );
2510                  }
2511                  $orderby = implode( ', ', $orderby_array );
2512  
2513              } else {
2514                  $q['orderby'] = urldecode( $q['orderby'] );
2515                  $q['orderby'] = addslashes_gpc( $q['orderby'] );
2516  
2517                  foreach ( explode( ' ', $q['orderby'] ) as $i => $orderby ) {
2518                      $parsed = $this->parse_orderby( $orderby );
2519                      // Only allow certain values for safety.
2520                      if ( ! $parsed ) {
2521                          continue;
2522                      }
2523  
2524                      $orderby_array[] = $parsed;
2525                  }
2526                  $orderby = implode( ' ' . $q['order'] . ', ', $orderby_array );
2527  
2528                  if ( empty( $orderby ) ) {
2529                      $orderby = "{$wpdb->posts}.post_date " . $q['order'];
2530                  } elseif ( ! empty( $q['order'] ) ) {
2531                      $orderby .= " {$q['order']}";
2532                  }
2533              }
2534          }
2535  
2536          // Order search results by relevance only when another "orderby" is not specified in the query.
2537          if ( ! empty( $q['s'] ) ) {
2538              $search_orderby = '';
2539              if ( ! empty( $q['search_orderby_title'] ) && ( empty( $q['orderby'] ) && ! $this->is_feed ) || ( isset( $q['orderby'] ) && 'relevance' === $q['orderby'] ) ) {
2540                  $search_orderby = $this->parse_search_order( $q );
2541              }
2542  
2543              if ( ! $q['suppress_filters'] ) {
2544                  /**
2545                   * Filters the ORDER BY used when ordering search results.
2546                   *
2547                   * @since 3.7.0
2548                   *
2549                   * @param string   $search_orderby The ORDER BY clause.
2550                   * @param WP_Query $query          The current WP_Query instance.
2551                   */
2552                  $search_orderby = apply_filters( 'posts_search_orderby', $search_orderby, $this );
2553              }
2554  
2555              if ( $search_orderby ) {
2556                  $orderby = $orderby ? $search_orderby . ', ' . $orderby : $search_orderby;
2557              }
2558          }
2559  
2560          if ( is_array( $post_type ) && count( $post_type ) > 1 ) {
2561              $post_type_cap = 'multiple_post_type';
2562          } else {
2563              if ( is_array( $post_type ) ) {
2564                  $post_type = reset( $post_type );
2565              }
2566              $post_type_object = get_post_type_object( $post_type );
2567              if ( empty( $post_type_object ) ) {
2568                  $post_type_cap = $post_type;
2569              }
2570          }
2571  
2572          if ( isset( $q['post_password'] ) ) {
2573              $where .= $wpdb->prepare( " AND {$wpdb->posts}.post_password = %s", $q['post_password'] );
2574              if ( empty( $q['perm'] ) ) {
2575                  $q['perm'] = 'readable';
2576              }
2577          } elseif ( isset( $q['has_password'] ) ) {
2578              $where .= sprintf( " AND {$wpdb->posts}.post_password %s ''", $q['has_password'] ? '!=' : '=' );
2579          }
2580  
2581          if ( ! empty( $q['comment_status'] ) ) {
2582              $where .= $wpdb->prepare( " AND {$wpdb->posts}.comment_status = %s ", $q['comment_status'] );
2583          }
2584  
2585          if ( ! empty( $q['ping_status'] ) ) {
2586              $where .= $wpdb->prepare( " AND {$wpdb->posts}.ping_status = %s ", $q['ping_status'] );
2587          }
2588  
2589          $skip_post_status = false;
2590          if ( 'any' === $post_type ) {
2591              $in_search_post_types = get_post_types( array( 'exclude_from_search' => false ) );
2592              if ( empty( $in_search_post_types ) ) {
2593                  $post_type_where  = ' AND 1=0 ';
2594                  $skip_post_status = true;
2595              } else {
2596                  $post_type_where = " AND {$wpdb->posts}.post_type IN ('" . implode( "', '", array_map( 'esc_sql', $in_search_post_types ) ) . "')";
2597              }
2598          } elseif ( ! empty( $post_type ) && is_array( $post_type ) ) {
2599              // Sort post types to ensure same cache key generation.
2600              sort( $post_type );
2601              $post_type_where = " AND {$wpdb->posts}.post_type IN ('" . implode( "', '", esc_sql( $post_type ) ) . "')";
2602          } elseif ( ! empty( $post_type ) ) {
2603              $post_type_where  = $wpdb->prepare( " AND {$wpdb->posts}.post_type = %s", $post_type );
2604              $post_type_object = get_post_type_object( $post_type );
2605          } elseif ( $this->is_attachment ) {
2606              $post_type_where  = " AND {$wpdb->posts}.post_type = 'attachment'";
2607              $post_type_object = get_post_type_object( 'attachment' );
2608          } elseif ( $this->is_page ) {
2609              $post_type_where  = " AND {$wpdb->posts}.post_type = 'page'";
2610              $post_type_object = get_post_type_object( 'page' );
2611          } else {
2612              $post_type_where  = " AND {$wpdb->posts}.post_type = 'post'";
2613              $post_type_object = get_post_type_object( 'post' );
2614          }
2615  
2616          $edit_cap = 'edit_post';
2617          $read_cap = 'read_post';
2618  
2619          if ( ! empty( $post_type_object ) ) {
2620              $edit_others_cap  = $post_type_object->cap->edit_others_posts;
2621              $read_private_cap = $post_type_object->cap->read_private_posts;
2622          } else {
2623              $edit_others_cap  = 'edit_others_' . $post_type_cap . 's';
2624              $read_private_cap = 'read_private_' . $post_type_cap . 's';
2625          }
2626  
2627          $user_id = get_current_user_id();
2628  
2629          $q_status = array();
2630          if ( $skip_post_status ) {
2631              $where .= $post_type_where;
2632          } elseif ( ! empty( $q['post_status'] ) ) {
2633  
2634              $where .= $post_type_where;
2635  
2636              $statuswheres = array();
2637              $q_status     = $q['post_status'];
2638              if ( ! is_array( $q_status ) ) {
2639                  $q_status = explode( ',', $q_status );
2640              }
2641              sort( $q_status );
2642              $r_status = array();
2643              $p_status = array();
2644              $e_status = array();
2645              if ( in_array( 'any', $q_status, true ) ) {
2646                  foreach ( get_post_stati( array( 'exclude_from_search' => true ) ) as $status ) {
2647                      if ( ! in_array( $status, $q_status, true ) ) {
2648                          $e_status[] = "{$wpdb->posts}.post_status <> '$status'";
2649                      }
2650                  }
2651              } else {
2652                  foreach ( get_post_stati() as $status ) {
2653                      if ( in_array( $status, $q_status, true ) ) {
2654                          if ( 'private' === $status ) {
2655                              $p_status[] = "{$wpdb->posts}.post_status = '$status'";
2656                          } else {
2657                              $r_status[] = "{$wpdb->posts}.post_status = '$status'";
2658                          }
2659                      }
2660                  }
2661              }
2662  
2663              if ( empty( $q['perm'] ) || 'readable' !== $q['perm'] ) {
2664                  $r_status = array_merge( $r_status, $p_status );
2665                  unset( $p_status );
2666              }
2667  
2668              if ( ! empty( $e_status ) ) {
2669                  $statuswheres[] = '(' . implode( ' AND ', $e_status ) . ')';
2670              }
2671              if ( ! empty( $r_status ) ) {
2672                  if ( ! empty( $q['perm'] ) && 'editable' === $q['perm'] && ! current_user_can( $edit_others_cap ) ) {
2673                      $statuswheres[] = "({$wpdb->posts}.post_author = $user_id " . 'AND (' . implode( ' OR ', $r_status ) . '))';
2674                  } else {
2675                      $statuswheres[] = '(' . implode( ' OR ', $r_status ) . ')';
2676                  }
2677              }
2678              if ( ! empty( $p_status ) ) {
2679                  if ( ! empty( $q['perm'] ) && 'readable' === $q['perm'] && ! current_user_can( $read_private_cap ) ) {
2680                      $statuswheres[] = "({$wpdb->posts}.post_author = $user_id " . 'AND (' . implode( ' OR ', $p_status ) . '))';
2681                  } else {
2682                      $statuswheres[] = '(' . implode( ' OR ', $p_status ) . ')';
2683                  }
2684              }
2685              if ( $post_status_join ) {
2686                  $join .= " LEFT JOIN {$wpdb->posts} AS p2 ON ({$wpdb->posts}.post_parent = p2.ID) ";
2687                  foreach ( $statuswheres as $index => $statuswhere ) {
2688                      $statuswheres[ $index ] = "($statuswhere OR ({$wpdb->posts}.post_status = 'inherit' AND " . str_replace( $wpdb->posts, 'p2', $statuswhere ) . '))';
2689                  }
2690              }
2691              $where_status = implode( ' OR ', $statuswheres );
2692              if ( ! empty( $where_status ) ) {
2693                  $where .= " AND ($where_status)";
2694              }
2695          } elseif ( ! $this->is_singular ) {
2696              if ( 'any' === $post_type ) {
2697                  $queried_post_types = get_post_types( array( 'exclude_from_search' => false ) );
2698              } elseif ( is_array( $post_type ) ) {
2699                  $queried_post_types = $post_type;
2700              } elseif ( ! empty( $post_type ) ) {
2701                  $queried_post_types = array( $post_type );
2702              } else {
2703                  $queried_post_types = array( 'post' );
2704              }
2705  
2706              if ( ! empty( $queried_post_types ) ) {
2707                  sort( $queried_post_types );
2708                  $status_type_clauses = array();
2709  
2710                  foreach ( $queried_post_types as $queried_post_type ) {
2711  
2712                      $queried_post_type_object = get_post_type_object( $queried_post_type );
2713  
2714                      $type_where = '(' . $wpdb->prepare( "{$wpdb->posts}.post_type = %s AND (", $queried_post_type );
2715  
2716                      // Public statuses.
2717                      $public_statuses = get_post_stati( array( 'public' => true ) );
2718                      $status_clauses  = array();
2719                      foreach ( $public_statuses as $public_status ) {
2720                          $status_clauses[] = "{$wpdb->posts}.post_status = '$public_status'";
2721                      }
2722                      $type_where .= implode( ' OR ', $status_clauses );
2723  
2724                      // Add protected states that should show in the admin all list.
2725                      if ( $this->is_admin ) {
2726                          $admin_all_statuses = get_post_stati(
2727                              array(
2728                                  'protected'              => true,
2729                                  'show_in_admin_all_list' => true,
2730                              )
2731                          );
2732                          foreach ( $admin_all_statuses as $admin_all_status ) {
2733                              $type_where .= " OR {$wpdb->posts}.post_status = '$admin_all_status'";
2734                          }
2735                      }
2736  
2737                      // Add private states that are visible to current user.
2738                      if ( is_user_logged_in() && $queried_post_type_object instanceof WP_Post_Type ) {
2739                          $read_private_cap = $queried_post_type_object->cap->read_private_posts;
2740                          $private_statuses = get_post_stati( array( 'private' => true ) );
2741                          foreach ( $private_statuses as $private_status ) {
2742                              $type_where .= current_user_can( $read_private_cap ) ? " \nOR {$wpdb->posts}.post_status = '$private_status'" : " \nOR ({$wpdb->posts}.post_author = $user_id AND {$wpdb->posts}.post_status = '$private_status')";
2743                          }
2744                      }
2745  
2746                      $type_where .= '))';
2747  
2748                      $status_type_clauses[] = $type_where;
2749                  }
2750  
2751                  if ( ! empty( $status_type_clauses ) ) {
2752                      $where .= ' AND (' . implode( ' OR ', $status_type_clauses ) . ')';
2753                  }
2754              } else {
2755                  $where .= ' AND 1=0 ';
2756              }
2757          } else {
2758              $where .= $post_type_where;
2759          }
2760  
2761          /*
2762           * Apply filters on where and join prior to paging so that any
2763           * manipulations to them are reflected in the paging by day queries.
2764           */
2765          if ( ! $q['suppress_filters'] ) {
2766              /**
2767               * Filters the WHERE clause of the query.
2768               *
2769               * @since 1.5.0
2770               *
2771               * @param string   $where The WHERE clause of the query.
2772               * @param WP_Query $query The WP_Query instance (passed by reference).
2773               */
2774              $where = apply_filters_ref_array( 'posts_where', array( $where, &$this ) );
2775  
2776              /**
2777               * Filters the JOIN clause of the query.
2778               *
2779               * @since 1.5.0
2780               *
2781               * @param string   $join  The JOIN clause of the query.
2782               * @param WP_Query $query The WP_Query instance (passed by reference).
2783               */
2784              $join = apply_filters_ref_array( 'posts_join', array( $join, &$this ) );
2785          }
2786  
2787          // Paging.
2788          if ( empty( $q['nopaging'] ) && ! $this->is_singular ) {
2789              $page = absint( $q['paged'] );
2790              if ( ! $page ) {
2791                  $page = 1;
2792              }
2793  
2794              // If 'offset' is provided, it takes precedence over 'paged'.
2795              if ( isset( $q['offset'] ) && is_numeric( $q['offset'] ) ) {
2796                  $q['offset'] = absint( $q['offset'] );
2797                  $pgstrt      = $q['offset'] . ', ';
2798              } else {
2799                  $pgstrt = absint( ( $page - 1 ) * $q['posts_per_page'] ) . ', ';
2800              }
2801              $limits = 'LIMIT ' . $pgstrt . $q['posts_per_page'];
2802          }
2803  
2804          // Comments feeds.
2805          if ( $this->is_comment_feed && ! $this->is_singular ) {
2806              if ( $this->is_archive || $this->is_search ) {
2807                  $cjoin    = "JOIN {$wpdb->posts} ON ( {$wpdb->comments}.comment_post_ID = {$wpdb->posts}.ID ) $join ";
2808                  $cwhere   = "WHERE comment_approved = '1' $where";
2809                  $cgroupby = "{$wpdb->comments}.comment_id";
2810              } else { // Other non-singular, e.g. front.
2811                  $cjoin    = "JOIN {$wpdb->posts} ON ( {$wpdb->comments}.comment_post_ID = {$wpdb->posts}.ID )";
2812                  $cwhere   = "WHERE ( post_status = 'publish' OR ( post_status = 'inherit' AND post_type = 'attachment' ) ) AND comment_approved = '1'";
2813                  $cgroupby = '';
2814              }
2815  
2816              if ( ! $q['suppress_filters'] ) {
2817                  /**
2818                   * Filters the JOIN clause of the comments feed query before sending.
2819                   *
2820                   * @since 2.2.0
2821                   *
2822                   * @param string   $cjoin The JOIN clause of the query.
2823                   * @param WP_Query $query The WP_Query instance (passed by reference).
2824                   */
2825                  $cjoin = apply_filters_ref_array( 'comment_feed_join', array( $cjoin, &$this ) );
2826  
2827                  /**
2828                   * Filters the WHERE clause of the comments feed query before sending.
2829                   *
2830                   * @since 2.2.0
2831                   *
2832                   * @param string   $cwhere The WHERE clause of the query.
2833                   * @param WP_Query $query  The WP_Query instance (passed by reference).
2834                   */
2835                  $cwhere = apply_filters_ref_array( 'comment_feed_where', array( $cwhere, &$this ) );
2836  
2837                  /**
2838                   * Filters the GROUP BY clause of the comments feed query before sending.
2839                   *
2840                   * @since 2.2.0
2841                   *
2842                   * @param string   $cgroupby The GROUP BY clause of the query.
2843                   * @param WP_Query $query    The WP_Query instance (passed by reference).
2844                   */
2845                  $cgroupby = apply_filters_ref_array( 'comment_feed_groupby', array( $cgroupby, &$this ) );
2846  
2847                  /**
2848                   * Filters the ORDER BY clause of the comments feed query before sending.
2849                   *
2850                   * @since 2.8.0
2851                   *
2852                   * @param string   $corderby The ORDER BY clause of the query.
2853                   * @param WP_Query $query    The WP_Query instance (passed by reference).
2854                   */
2855                  $corderby = apply_filters_ref_array( 'comment_feed_orderby', array( 'comment_date_gmt DESC', &$this ) );
2856  
2857                  /**
2858                   * Filters the LIMIT clause of the comments feed query before sending.
2859                   *
2860                   * @since 2.8.0
2861                   *
2862                   * @param string   $climits The JOIN clause of the query.
2863                   * @param WP_Query $query   The WP_Query instance (passed by reference).
2864                   */
2865                  $climits = apply_filters_ref_array( 'comment_feed_limits', array( 'LIMIT ' . get_option( 'posts_per_rss' ), &$this ) );
2866              }
2867  
2868              $cgroupby = ( ! empty( $cgroupby ) ) ? 'GROUP BY ' . $cgroupby : '';
2869              $corderby = ( ! empty( $corderby ) ) ? 'ORDER BY ' . $corderby : '';
2870              $climits  = ( ! empty( $climits ) ) ? $climits : '';
2871  
2872              $comments_request = "SELECT $distinct {$wpdb->comments}.comment_ID FROM {$wpdb->comments} $cjoin $cwhere $cgroupby $corderby $climits";
2873  
2874              $key          = md5( $comments_request );
2875              $last_changed = wp_cache_get_last_changed( 'comment' ) . ':' . wp_cache_get_last_changed( 'posts' );
2876  
2877              $cache_key   = "comment_feed:$key:$last_changed";
2878              $comment_ids = wp_cache_get( $cache_key, 'comment-queries' );
2879              if ( false === $comment_ids ) {
2880                  $comment_ids = $wpdb->get_col( $comments_request );
2881                  wp_cache_add( $cache_key, $comment_ids, 'comment-queries' );
2882              }
2883              _prime_comment_caches( $comment_ids );
2884  
2885              // Convert to WP_Comment.
2886              /** @var WP_Comment[] */
2887              $this->comments      = array_map( 'get_comment', $comment_ids );
2888              $this->comment_count = count( $this->comments );
2889  
2890              $post_ids = array();
2891  
2892              foreach ( $this->comments as $comment ) {
2893                  $post_ids[] = (int) $comment->comment_post_ID;
2894              }
2895  
2896              $post_ids = implode( ',', $post_ids );
2897              $join     = '';
2898              if ( $post_ids ) {
2899                  $where = "AND {$wpdb->posts}.ID IN ($post_ids) ";
2900              } else {
2901                  $where = 'AND 0';
2902              }
2903          }
2904  
2905          $pieces = array( 'where', 'groupby', 'join', 'orderby', 'distinct', 'fields', 'limits' );
2906  
2907          /*
2908           * Apply post-paging filters on where and join. Only plugins that
2909           * manipulate paging queries should use these hooks.
2910           */
2911          if ( ! $q['suppress_filters'] ) {
2912              /**
2913               * Filters the WHERE clause of the query.
2914               *
2915               * Specifically for manipulating paging queries.
2916               *
2917               * @since 1.5.0
2918               *
2919               * @param string   $where The WHERE clause of the query.
2920               * @param WP_Query $query The WP_Query instance (passed by reference).
2921               */
2922              $where = apply_filters_ref_array( 'posts_where_paged', array( $where, &$this ) );
2923  
2924              /**
2925               * Filters the GROUP BY clause of the query.
2926               *
2927               * @since 2.0.0
2928               *
2929               * @param string   $groupby The GROUP BY clause of the query.
2930               * @param WP_Query $query   The WP_Query instance (passed by reference).
2931               */
2932              $groupby = apply_filters_ref_array( 'posts_groupby', array( $groupby, &$this ) );
2933  
2934              /**
2935               * Filters the JOIN clause of the query.
2936               *
2937               * Specifically for manipulating paging queries.
2938               *
2939               * @since 1.5.0
2940               *
2941               * @param string   $join  The JOIN clause of the query.
2942               * @param WP_Query $query The WP_Query instance (passed by reference).
2943               */
2944              $join = apply_filters_ref_array( 'posts_join_paged', array( $join, &$this ) );
2945  
2946              /**
2947               * Filters the ORDER BY clause of the query.
2948               *
2949               * @since 1.5.1
2950               *
2951               * @param string   $orderby The ORDER BY clause of the query.
2952               * @param WP_Query $query   The WP_Query instance (passed by reference).
2953               */
2954              $orderby = apply_filters_ref_array( 'posts_orderby', array( $orderby, &$this ) );
2955  
2956              /**
2957               * Filters the DISTINCT clause of the query.
2958               *
2959               * @since 2.1.0
2960               *
2961               * @param string   $distinct The DISTINCT clause of the query.
2962               * @param WP_Query $query    The WP_Query instance (passed by reference).
2963               */
2964              $distinct = apply_filters_ref_array( 'posts_distinct', array( $distinct, &$this ) );
2965  
2966              /**
2967               * Filters the LIMIT clause of the query.
2968               *
2969               * @since 2.1.0
2970               *
2971               * @param string   $limits The LIMIT clause of the query.
2972               * @param WP_Query $query  The WP_Query instance (passed by reference).
2973               */
2974              $limits = apply_filters_ref_array( 'post_limits', array( $limits, &$this ) );
2975  
2976              /**
2977               * Filters the SELECT clause of the query.
2978               *
2979               * @since 2.1.0
2980               *
2981               * @param string   $fields The SELECT clause of the query.
2982               * @param WP_Query $query  The WP_Query instance (passed by reference).
2983               */
2984              $fields = apply_filters_ref_array( 'posts_fields', array( $fields, &$this ) );
2985  
2986              /**
2987               * Filters all query clauses at once, for convenience.
2988               *
2989               * Covers the WHERE, GROUP BY, JOIN, ORDER BY, DISTINCT,
2990               * fields (SELECT), and LIMIT clauses.
2991               *
2992               * @since 3.1.0
2993               *
2994               * @param string[] $clauses {
2995               *     Associative array of the clauses for the query.
2996               *
2997               *     @type string $where    The WHERE clause of the query.
2998               *     @type string $groupby  The GROUP BY clause of the query.
2999               *     @type string $join     The JOIN clause of the query.
3000               *     @type string $orderby  The ORDER BY clause of the query.
3001               *     @type string $distinct The DISTINCT clause of the query.
3002               *     @type string $fields   The SELECT clause of the query.
3003               *     @type string $limits   The LIMIT clause of the query.
3004               * }
3005               * @param WP_Query $query   The WP_Query instance (passed by reference).
3006               */
3007              $clauses = (array) apply_filters_ref_array( 'posts_clauses', array( compact( $pieces ), &$this ) );
3008  
3009              $where    = isset( $clauses['where'] ) ? $clauses['where'] : '';
3010              $groupby  = isset( $clauses['groupby'] ) ? $clauses['groupby'] : '';
3011              $join     = isset( $clauses['join'] ) ? $clauses['join'] : '';
3012              $orderby  = isset( $clauses['orderby'] ) ? $clauses['orderby'] : '';
3013              $distinct = isset( $clauses['distinct'] ) ? $clauses['distinct'] : '';
3014              $fields   = isset( $clauses['fields'] ) ? $clauses['fields'] : '';
3015              $limits   = isset( $clauses['limits'] ) ? $clauses['limits'] : '';
3016          }
3017  
3018          /**
3019           * Fires to announce the query's current selection parameters.
3020           *
3021           * For use by caching plugins.
3022           *
3023           * @since 2.3.0
3024           *
3025           * @param string $selection The assembled selection query.
3026           */
3027          do_action( 'posts_selection', $where . $groupby . $orderby . $limits . $join );
3028  
3029          /*
3030           * Filters again for the benefit of caching plugins.
3031           * Regular plugins should use the hooks above.
3032           */
3033          if ( ! $q['suppress_filters'] ) {
3034              /**
3035               * Filters the WHERE clause of the query.
3036               *
3037               * For use by caching plugins.
3038               *
3039               * @since 2.5.0
3040               *
3041               * @param string   $where The WHERE clause of the query.
3042               * @param WP_Query $query The WP_Query instance (passed by reference).
3043               */
3044              $where = apply_filters_ref_array( 'posts_where_request', array( $where, &$this ) );
3045  
3046              /**
3047               * Filters the GROUP BY clause of the query.
3048               *
3049               * For use by caching plugins.
3050               *
3051               * @since 2.5.0
3052               *
3053               * @param string   $groupby The GROUP BY clause of the query.
3054               * @param WP_Query $query   The WP_Query instance (passed by reference).
3055               */
3056              $groupby = apply_filters_ref_array( 'posts_groupby_request', array( $groupby, &$this ) );
3057  
3058              /**
3059               * Filters the JOIN clause of the query.
3060               *
3061               * For use by caching plugins.
3062               *
3063               * @since 2.5.0
3064               *
3065               * @param string   $join  The JOIN clause of the query.
3066               * @param WP_Query $query The WP_Query instance (passed by reference).
3067               */
3068              $join = apply_filters_ref_array( 'posts_join_request', array( $join, &$this ) );
3069  
3070              /**
3071               * Filters the ORDER BY clause of the query.
3072               *
3073               * For use by caching plugins.
3074               *
3075               * @since 2.5.0
3076               *
3077               * @param string   $orderby The ORDER BY clause of the query.
3078               * @param WP_Query $query   The WP_Query instance (passed by reference).
3079               */
3080              $orderby = apply_filters_ref_array( 'posts_orderby_request', array( $orderby, &$this ) );
3081  
3082              /**
3083               * Filters the DISTINCT clause of the query.
3084               *
3085               * For use by caching plugins.
3086               *
3087               * @since 2.5.0
3088               *
3089               * @param string   $distinct The DISTINCT clause of the query.
3090               * @param WP_Query $query    The WP_Query instance (passed by reference).
3091               */
3092              $distinct = apply_filters_ref_array( 'posts_distinct_request', array( $distinct, &$this ) );
3093  
3094              /**
3095               * Filters the SELECT clause of the query.
3096               *
3097               * For use by caching plugins.
3098               *
3099               * @since 2.5.0
3100               *
3101               * @param string   $fields The SELECT clause of the query.
3102               * @param WP_Query $query  The WP_Query instance (passed by reference).
3103               */
3104              $fields = apply_filters_ref_array( 'posts_fields_request', array( $fields, &$this ) );
3105  
3106              /**
3107               * Filters the LIMIT clause of the query.
3108               *
3109               * For use by caching plugins.
3110               *
3111               * @since 2.5.0
3112               *
3113               * @param string   $limits The LIMIT clause of the query.
3114               * @param WP_Query $query  The WP_Query instance (passed by reference).
3115               */
3116              $limits = apply_filters_ref_array( 'post_limits_request', array( $limits, &$this ) );
3117  
3118              /**
3119               * Filters all query clauses at once, for convenience.
3120               *
3121               * For use by caching plugins.
3122               *
3123               * Covers the WHERE, GROUP BY, JOIN, ORDER BY, DISTINCT,
3124               * fields (SELECT), and LIMIT clauses.
3125               *
3126               * @since 3.1.0
3127               *
3128               * @param string[] $clauses {
3129               *     Associative array of the clauses for the query.
3130               *
3131               *     @type string $where    The WHERE clause of the query.
3132               *     @type string $groupby  The GROUP BY clause of the query.
3133               *     @type string $join     The JOIN clause of the query.
3134               *     @type string $orderby  The ORDER BY clause of the query.
3135               *     @type string $distinct The DISTINCT clause of the query.
3136               *     @type string $fields   The SELECT clause of the query.
3137               *     @type string $limits   The LIMIT clause of the query.
3138               * }
3139               * @param WP_Query $query  The WP_Query instance (passed by reference).
3140               */
3141              $clauses = (array) apply_filters_ref_array( 'posts_clauses_request', array( compact( $pieces ), &$this ) );
3142  
3143              $where    = isset( $clauses['where'] ) ? $clauses['where'] : '';
3144              $groupby  = isset( $clauses['groupby'] ) ? $clauses['groupby'] : '';
3145              $join     = isset( $clauses['join'] ) ? $clauses['join'] : '';
3146              $orderby  = isset( $clauses['orderby'] ) ? $clauses['orderby'] : '';
3147              $distinct = isset( $clauses['distinct'] ) ? $clauses['distinct'] : '';
3148              $fields   = isset( $clauses['fields'] ) ? $clauses['fields'] : '';
3149              $limits   = isset( $clauses['limits'] ) ? $clauses['limits'] : '';
3150          }
3151  
3152          if ( ! empty( $groupby ) ) {
3153              $groupby = 'GROUP BY ' . $groupby;
3154          }
3155          if ( ! empty( $orderby ) ) {
3156              $orderby = 'ORDER BY ' . $orderby;
3157          }
3158  
3159          $found_rows = '';
3160          if ( ! $q['no_found_rows'] && ! empty( $limits ) ) {
3161              $found_rows = 'SQL_CALC_FOUND_ROWS';
3162          }
3163  
3164          /*
3165           * Beginning of the string is on a new line to prevent leading whitespace.
3166           *
3167           * The additional indentation of subsequent lines is to ensure the SQL
3168           * queries are identical to those generated when splitting queries. This
3169           * improves caching of the query by ensuring the same cache key is
3170           * generated for the same database queries functionally.
3171           *
3172           * See https://core.trac.wordpress.org/ticket/56841.
3173           * See https://github.com/WordPress/wordpress-develop/pull/6393#issuecomment-2088217429
3174           */
3175          $old_request =
3176              "SELECT $found_rows $distinct $fields
3177                       FROM {$wpdb->posts} $join
3178                       WHERE 1=1 $where
3179                       $groupby
3180                       $orderby
3181                       $limits";
3182  
3183          $this->request = $old_request;
3184  
3185          if ( ! $q['suppress_filters'] ) {
3186              /**
3187               * Filters the completed SQL query before sending.
3188               *
3189               * @since 2.0.0
3190               *
3191               * @param string   $request The complete SQL query.
3192               * @param WP_Query $query   The WP_Query instance (passed by reference).
3193               */
3194              $this->request = apply_filters_ref_array( 'posts_request', array( $this->request, &$this ) );
3195          }
3196  
3197          /**
3198           * Filters the posts array before the query takes place.
3199           *
3200           * Return a non-null value to bypass WordPress' default post queries.
3201           *
3202           * Filtering functions that require pagination information are encouraged to set
3203           * the `found_posts` and `max_num_pages` properties of the WP_Query object,
3204           * passed to the filter by reference. If WP_Query does not perform a database
3205           * query, it will not have enough information to generate these values itself.
3206           *
3207           * @since 4.6.0
3208           *
3209           * @param WP_Post[]|int[]|null $posts Return an array of post data to short-circuit WP's query,
3210           *                                    or null to allow WP to run its normal queries.
3211           * @param WP_Query             $query The WP_Query instance (passed by reference).
3212           */
3213          $this->posts = apply_filters_ref_array( 'posts_pre_query', array( null, &$this ) );
3214  
3215          /*
3216           * Ensure the ID database query is able to be cached.
3217           *
3218           * Random queries are expected to have unpredictable results and
3219           * cannot be cached. Note the space before `RAND` in the string
3220           * search, that to ensure against a collision with another
3221           * function.
3222           *
3223           * If `$fields` has been modified by the `posts_fields`,
3224           * `posts_fields_request`, `post_clauses` or `posts_clauses_request`
3225           * filters, then caching is disabled to prevent caching collisions.
3226           */
3227          $id_query_is_cacheable = ! str_contains( strtoupper( $orderby ), ' RAND(' );
3228  
3229          $cacheable_field_values = array(
3230              "{$wpdb->posts}.*",
3231              "{$wpdb->posts}.ID, {$wpdb->posts}.post_parent",
3232              "{$wpdb->posts}.ID",
3233          );
3234  
3235          if ( ! in_array( $fields, $cacheable_field_values, true ) ) {
3236              $id_query_is_cacheable = false;
3237          }
3238  
3239          if ( $q['cache_results'] && $id_query_is_cacheable ) {
3240              $new_request = str_replace( $fields, "{$wpdb->posts}.*", $this->request );
3241              $cache_key   = $this->generate_cache_key( $q, $new_request );
3242  
3243              $cache_found = false;
3244              if ( null === $this->posts ) {
3245                  $cached_results = wp_cache_get( $cache_key, 'post-queries', false, $cache_found );
3246  
3247                  if ( $cached_results ) {
3248                      /** @var int[] */
3249                      $post_ids = array_map( 'intval', $cached_results['posts'] );
3250  
3251                      $this->post_count    = count( $post_ids );
3252                      $this->found_posts   = $cached_results['found_posts'];
3253                      $this->max_num_pages = $cached_results['max_num_pages'];
3254  
3255                      if ( 'ids' === $q['fields'] ) {
3256                          $this->posts = $post_ids;
3257  
3258                          return $this->posts;
3259                      } elseif ( 'id=>parent' === $q['fields'] ) {
3260                          _prime_post_parent_id_caches( $post_ids );
3261  
3262                          $post_parent_cache_keys = array();
3263                          foreach ( $post_ids as $post_id ) {
3264                              $post_parent_cache_keys[] = 'post_parent:' . (string) $post_id;
3265                          }
3266  
3267                          /** @var int[] */
3268                          $post_parents = wp_cache_get_multiple( $post_parent_cache_keys, 'posts' );
3269  
3270                          foreach ( $post_parents as $cache_key => $post_parent ) {
3271                              $obj              = new stdClass();
3272                              $obj->ID          = (int) str_replace( 'post_parent:', '', $cache_key );
3273                              $obj->post_parent = (int) $post_parent;
3274  
3275                              $this->posts[] = $obj;
3276                          }
3277  
3278                          return $post_parents;
3279                      } else {
3280                          _prime_post_caches( $post_ids, $q['update_post_term_cache'], $q['update_post_meta_cache'] );
3281                          /** @var WP_Post[] */
3282                          $this->posts = array_map( 'get_post', $post_ids );
3283                      }
3284                  }
3285              }
3286          }
3287  
3288          if ( 'ids' === $q['fields'] ) {
3289              if ( null === $this->posts ) {
3290                  $this->posts = $wpdb->get_col( $this->request );
3291              }
3292  
3293              /** @var int[] */
3294              $this->posts      = array_map( 'intval', $this->posts );
3295              $this->post_count = count( $this->posts );
3296              $this->set_found_posts( $q, $limits );
3297  
3298              if ( $q['cache_results'] && $id_query_is_cacheable ) {
3299                  $cache_value = array(
3300                      'posts'         => $this->posts,
3301                      'found_posts'   => $this->found_posts,
3302                      'max_num_pages' => $this->max_num_pages,
3303                  );
3304  
3305                  wp_cache_set( $cache_key, $cache_value, 'post-queries' );
3306              }
3307  
3308              return $this->posts;
3309          }
3310  
3311          if ( 'id=>parent' === $q['fields'] ) {
3312              if ( null === $this->posts ) {
3313                  $this->posts = $wpdb->get_results( $this->request );
3314              }
3315  
3316              $this->post_count = count( $this->posts );
3317              $this->set_found_posts( $q, $limits );
3318  
3319              /** @var int[] */
3320              $post_parents       = array();
3321              $post_ids           = array();
3322              $post_parents_cache = array();
3323  
3324              foreach ( $this->posts as $key => $post ) {
3325                  $this->posts[ $key ]->ID          = (int) $post->ID;
3326                  $this->posts[ $key ]->post_parent = (int) $post->post_parent;
3327  
3328                  $post_parents[ (int) $post->ID ] = (int) $post->post_parent;
3329                  $post_ids[]                      = (int) $post->ID;
3330  
3331                  $post_parents_cache[ 'post_parent:' . (string) $post->ID ] = (int) $post->post_parent;
3332              }
3333              // Prime post parent caches, so that on second run, there is not another database query.
3334              wp_cache_add_multiple( $post_parents_cache, 'posts' );
3335  
3336              if ( $q['cache_results'] && $id_query_is_cacheable ) {
3337                  $cache_value = array(
3338                      'posts'         => $post_ids,
3339                      'found_posts'   => $this->found_posts,
3340                      'max_num_pages' => $this->max_num_pages,
3341                  );
3342  
3343                  wp_cache_set( $cache_key, $cache_value, 'post-queries' );
3344              }
3345  
3346              return $post_parents;
3347          }
3348  
3349          $is_unfiltered_query = $old_request == $this->request && "{$wpdb->posts}.*" === $fields;
3350  
3351          if ( null === $this->posts ) {
3352              $split_the_query = (
3353                  $is_unfiltered_query
3354                  && (
3355                      wp_using_ext_object_cache()
3356                      || ( ! empty( $limits ) && $q['posts_per_page'] < 500 )
3357                  )
3358              );
3359  
3360              /**
3361               * Filters whether to split the query.
3362               *
3363               * Splitting the query will cause it to fetch just the IDs of the found posts
3364               * (and then individually fetch each post by ID), rather than fetching every
3365               * complete row at once. One massive result vs. many small results.
3366               *
3367               * @since 3.4.0
3368               * @since 6.6.0 Added the `$old_request` and `$clauses` parameters.
3369               *
3370               * @param bool     $split_the_query Whether or not to split the query.
3371               * @param WP_Query $query           The WP_Query instance.
3372               * @param string   $old_request     The complete SQL query before filtering.
3373               * @param string[] $clauses {
3374               *     Associative array of the clauses for the query.
3375               *
3376               *     @type string $where    The WHERE clause of the query.
3377               *     @type string $groupby  The GROUP BY clause of the query.
3378               *     @type string $join     The JOIN clause of the query.
3379               *     @type string $orderby  The ORDER BY clause of the query.
3380               *     @type string $distinct The DISTINCT clause of the query.
3381               *     @type string $fields   The SELECT clause of the query.
3382               *     @type string $limits   The LIMIT clause of the query.
3383               * }
3384               */
3385              $split_the_query = apply_filters( 'split_the_query', $split_the_query, $this, $old_request, compact( $pieces ) );
3386  
3387              if ( $split_the_query ) {
3388                  // First get the IDs and then fill in the objects.
3389  
3390                  // Beginning of the string is on a new line to prevent leading whitespace. See https://core.trac.wordpress.org/ticket/56841.
3391                  $this->request =
3392                      "SELECT $found_rows $distinct {$wpdb->posts}.ID
3393                       FROM {$wpdb->posts} $join
3394                       WHERE 1=1 $where
3395                       $groupby
3396                       $orderby
3397                       $limits";
3398  
3399                  /**
3400                   * Filters the Post IDs SQL request before sending.
3401                   *
3402                   * @since 3.4.0
3403                   *
3404                   * @param string   $request The post ID request.
3405                   * @param WP_Query $query   The WP_Query instance.
3406                   */
3407                  $this->request = apply_filters( 'posts_request_ids', $this->request, $this );
3408  
3409                  $post_ids = $wpdb->get_col( $this->request );
3410  
3411                  if ( $post_ids ) {
3412                      $this->posts = $post_ids;
3413                      $this->set_found_posts( $q, $limits );
3414                      _prime_post_caches( $post_ids, $q['update_post_term_cache'], $q['update_post_meta_cache'] );
3415                  } else {
3416                      $this->posts = array();
3417                  }
3418              } else {
3419                  $this->posts = $wpdb->get_results( $this->request );
3420                  $this->set_found_posts( $q, $limits );
3421              }
3422          }
3423  
3424          // Convert to WP_Post objects.
3425          if ( $this->posts ) {
3426              /** @var WP_Post[] */
3427              $this->posts = array_map( 'get_post', $this->posts );
3428          }
3429  
3430          $unfiltered_posts = $this->posts;
3431  
3432          if ( $q['cache_results'] && $id_query_is_cacheable && ! $cache_found ) {
3433              $post_ids = wp_list_pluck( $this->posts, 'ID' );
3434  
3435              $cache_value = array(
3436                  'posts'         => $post_ids,
3437                  'found_posts'   => $this->found_posts,
3438                  'max_num_pages' => $this->max_num_pages,
3439              );
3440  
3441              wp_cache_set( $cache_key, $cache_value, 'post-queries' );
3442          }
3443  
3444          if ( ! $q['suppress_filters'] ) {
3445              /**
3446               * Filters the raw post results array, prior to status checks.
3447               *
3448               * @since 2.3.0
3449               *
3450               * @param WP_Post[] $posts Array of post objects.
3451               * @param WP_Query  $query The WP_Query instance (passed by reference).
3452               */
3453              $this->posts = apply_filters_ref_array( 'posts_results', array( $this->posts, &$this ) );
3454          }
3455  
3456          if ( ! empty( $this->posts ) && $this->is_comment_feed && $this->is_singular ) {
3457              /** This filter is documented in wp-includes/query.php */
3458              $cjoin = apply_filters_ref_array( 'comment_feed_join', array( '', &$this ) );
3459  
3460              /** This filter is documented in wp-includes/query.php */
3461              $cwhere = apply_filters_ref_array( 'comment_feed_where', array( "WHERE comment_post_ID = '{$this->posts[0]->ID}' AND comment_approved = '1'", &$this ) );
3462  
3463              /** This filter is documented in wp-includes/query.php */
3464              $cgroupby = apply_filters_ref_array( 'comment_feed_groupby', array( '', &$this ) );
3465              $cgroupby = ( ! empty( $cgroupby ) ) ? 'GROUP BY ' . $cgroupby : '';
3466  
3467              /** This filter is documented in wp-includes/query.php */
3468              $corderby = apply_filters_ref_array( 'comment_feed_orderby', array( 'comment_date_gmt DESC', &$this ) );
3469              $corderby = ( ! empty( $corderby ) ) ? 'ORDER BY ' . $corderby : '';
3470  
3471              /** This filter is documented in wp-includes/query.php */
3472              $climits = apply_filters_ref_array( 'comment_feed_limits', array( 'LIMIT ' . get_option( 'posts_per_rss' ), &$this ) );
3473  
3474              $comments_request = "SELECT {$wpdb->comments}.comment_ID FROM {$wpdb->comments} $cjoin $cwhere $cgroupby $corderby $climits";
3475  
3476              $comment_key          = md5( $comments_request );
3477              $comment_last_changed = wp_cache_get_last_changed( 'comment' );
3478  
3479              $comment_cache_key = "comment_feed:$comment_key:$comment_last_changed";
3480              $comment_ids       = wp_cache_get( $comment_cache_key, 'comment-queries' );
3481              if ( false === $comment_ids ) {
3482                  $comment_ids = $wpdb->get_col( $comments_request );
3483                  wp_cache_add( $comment_cache_key, $comment_ids, 'comment-queries' );
3484              }
3485              _prime_comment_caches( $comment_ids );
3486  
3487              // Convert to WP_Comment.
3488              /** @var WP_Comment[] */
3489              $this->comments      = array_map( 'get_comment', $comment_ids );
3490              $this->comment_count = count( $this->comments );
3491          }
3492  
3493          // Check post status to determine if post should be displayed.
3494          if ( ! empty( $this->posts ) && ( $this->is_single || $this->is_page ) ) {
3495              $status = get_post_status( $this->posts[0] );
3496  
3497              if ( 'attachment' === $this->posts[0]->post_type && 0 === (int) $this->posts[0]->post_parent ) {
3498                  $this->is_page       = false;
3499                  $this->is_single     = true;
3500                  $this->is_attachment = true;
3501              }
3502  
3503              // If the post_status was specifically requested, let it pass through.
3504              if ( ! in_array( $status, $q_status, true ) ) {
3505                  $post_status_obj = get_post_status_object( $status );
3506  
3507                  if ( $post_status_obj && ! $post_status_obj->public ) {
3508                      if ( ! is_user_logged_in() ) {
3509                          // User must be logged in to view unpublished posts.
3510                          $this->posts = array();
3511                      } else {
3512                          if ( $post_status_obj->protected ) {
3513                              // User must have edit permissions on the draft to preview.
3514                              if ( ! current_user_can( $edit_cap, $this->posts[0]->ID ) ) {
3515                                  $this->posts = array();
3516                              } else {
3517                                  $this->is_preview = true;
3518                                  if ( 'future' !== $status ) {
3519                                      $this->posts[0]->post_date = current_time( 'mysql' );
3520                                  }
3521                              }
3522                          } elseif ( $post_status_obj->private ) {
3523                              if ( ! current_user_can( $read_cap, $this->posts[0]->ID ) ) {
3524                                  $this->posts = array();
3525                              }
3526                          } else {
3527                              $this->posts = array();
3528                          }
3529                      }
3530                  } elseif ( ! $post_status_obj ) {
3531                      // Post status is not registered, assume it's not public.
3532                      if ( ! current_user_can( $edit_cap, $this->posts[0]->ID ) ) {
3533                          $this->posts = array();
3534                      }
3535                  }
3536              }
3537  
3538              if ( $this->is_preview && $this->posts && current_user_can( $edit_cap, $this->posts[0]->ID ) ) {
3539                  /**
3540                   * Filters the single post for preview mode.
3541                   *
3542                   * @since 2.7.0
3543                   *
3544                   * @param WP_Post  $post_preview  The Post object.
3545                   * @param WP_Query $query         The WP_Query instance (passed by reference).
3546                   */
3547                  $this->posts[0] = get_post( apply_filters_ref_array( 'the_preview', array( $this->posts[0], &$this ) ) );
3548              }
3549          }
3550  
3551          // Put sticky posts at the top of the posts array.
3552          $sticky_posts = get_option( 'sticky_posts' );
3553          if ( $this->is_home && $page <= 1 && is_array( $sticky_posts ) && ! empty( $sticky_posts ) && ! $q['ignore_sticky_posts'] ) {
3554              $num_posts     = count( $this->posts );
3555              $sticky_offset = 0;
3556              // Loop over posts and relocate stickies to the front.
3557              for ( $i = 0; $i < $num_posts; $i++ ) {
3558                  if ( in_array( $this->posts[ $i ]->ID, $sticky_posts, true ) ) {
3559                      $sticky_post = $this->posts[ $i ];
3560                      // Remove sticky from current position.
3561                      array_splice( $this->posts, $i, 1 );
3562                      // Move to front, after other stickies.
3563                      array_splice( $this->posts, $sticky_offset, 0, array( $sticky_post ) );
3564                      // Increment the sticky offset. The next sticky will be placed at this offset.
3565                      ++$sticky_offset;
3566                      // Remove post from sticky posts array.
3567                      $offset = array_search( $sticky_post->ID, $sticky_posts, true );
3568                      unset( $sticky_posts[ $offset ] );
3569                  }
3570              }
3571  
3572              // If any posts have been excluded specifically, Ignore those that are sticky.
3573              if ( ! empty( $sticky_posts ) && ! empty( $q['post__not_in'] ) ) {
3574                  $sticky_posts = array_diff( $sticky_posts, $q['post__not_in'] );
3575              }
3576  
3577              // Fetch sticky posts that weren't in the query results.
3578              if ( ! empty( $sticky_posts ) ) {
3579                  $stickies = get_posts(
3580                      array(
3581                          'post__in'               => $sticky_posts,
3582                          'post_type'              => $post_type,
3583                          'post_status'            => 'publish',
3584                          'posts_per_page'         => count( $sticky_posts ),
3585                          'suppress_filters'       => $q['suppress_filters'],
3586                          'cache_results'          => $q['cache_results'],
3587                          'update_post_meta_cache' => $q['update_post_meta_cache'],
3588                          'update_post_term_cache' => $q['update_post_term_cache'],
3589                          'lazy_load_term_meta'    => $q['lazy_load_term_meta'],
3590                      )
3591                  );
3592  
3593                  foreach ( $stickies as $sticky_post ) {
3594                      array_splice( $this->posts, $sticky_offset, 0, array( $sticky_post ) );
3595                      ++$sticky_offset;
3596                  }
3597              }
3598          }
3599  
3600          if ( ! $q['suppress_filters'] ) {
3601              /**
3602               * Filters the array of retrieved posts after they've been fetched and
3603               * internally processed.
3604               *
3605               * @since 1.5.0
3606               *
3607               * @param WP_Post[] $posts Array of post objects.
3608               * @param WP_Query  $query The WP_Query instance (passed by reference).
3609               */
3610              $this->posts = apply_filters_ref_array( 'the_posts', array( $this->posts, &$this ) );
3611          }
3612  
3613          /*
3614           * Ensure that any posts added/modified via one of the filters above are
3615           * of the type WP_Post and are filtered.
3616           */
3617          if ( $this->posts ) {
3618              $this->post_count = count( $this->posts );
3619  
3620              /** @var WP_Post[] */
3621              $this->posts = array_map( 'get_post', $this->posts );
3622  
3623              if ( $q['cache_results'] ) {
3624                  if ( $is_unfiltered_query && $unfiltered_posts === $this->posts ) {
3625                      update_post_caches( $this->posts, $post_type, $q['update_post_term_cache'], $q['update_post_meta_cache'] );
3626                  } else {
3627                      $post_ids = wp_list_pluck( $this->posts, 'ID' );
3628                      _prime_post_caches( $post_ids, $q['update_post_term_cache'], $q['update_post_meta_cache'] );
3629                  }
3630              }
3631  
3632              /** @var WP_Post */
3633              $this->post = reset( $this->posts );
3634          } else {
3635              $this->post_count = 0;
3636              $this->posts      = array();
3637          }
3638  
3639          if ( ! empty( $this->posts ) && $q['update_menu_item_cache'] ) {
3640              update_menu_item_cache( $this->posts );
3641          }
3642  
3643          if ( $q['lazy_load_term_meta'] ) {
3644              wp_queue_posts_for_term_meta_lazyload( $this->posts );
3645          }
3646  
3647          return $this->posts;
3648      }
3649  
3650      /**
3651       * Sets up the amount of found posts and the number of pages (if limit clause was used)
3652       * for the current query.
3653       *
3654       * @since 3.5.0
3655       *
3656       * @global wpdb $wpdb WordPress database abstraction object.
3657       *
3658       * @param array  $q      Query variables.
3659       * @param string $limits LIMIT clauses of the query.
3660       */
3661  	private function set_found_posts( $q, $limits ) {
3662          global $wpdb;
3663  
3664          /*
3665           * Bail if posts is an empty array. Continue if posts is an empty string,
3666           * null, or false to accommodate caching plugins that fill posts later.
3667           */
3668          if ( $q['no_found_rows'] || ( is_array( $this->posts ) && ! $this->posts ) ) {
3669              return;
3670          }
3671  
3672          if ( ! empty( $limits ) ) {
3673              /**
3674               * Filters the query to run for retrieving the found posts.
3675               *
3676               * @since 2.1.0
3677               *
3678               * @param string   $found_posts_query The query to run to find the found posts.
3679               * @param WP_Query $query             The WP_Query instance (passed by reference).
3680               */
3681              $found_posts_query = apply_filters_ref_array( 'found_posts_query', array( 'SELECT FOUND_ROWS()', &$this ) );
3682  
3683              $this->found_posts = (int) $wpdb->get_var( $found_posts_query );
3684          } else {
3685              if ( is_array( $this->posts ) ) {
3686                  $this->found_posts = count( $this->posts );
3687              } else {
3688                  if ( null === $this->posts ) {
3689                      $this->found_posts = 0;
3690                  } else {
3691                      $this->found_posts = 1;
3692                  }
3693              }
3694          }
3695  
3696          /**
3697           * Filters the number of found posts for the query.
3698           *
3699           * @since 2.1.0
3700           *
3701           * @param int      $found_posts The number of posts found.
3702           * @param WP_Query $query       The WP_Query instance (passed by reference).
3703           */
3704          $this->found_posts = (int) apply_filters_ref_array( 'found_posts', array( $this->found_posts, &$this ) );
3705  
3706          if ( ! empty( $limits ) ) {
3707              $this->max_num_pages = (int) ceil( $this->found_posts / $q['posts_per_page'] );
3708          }
3709      }
3710  
3711      /**
3712       * Sets up the next post and iterate current post index.
3713       *
3714       * @since 1.5.0
3715       *
3716       * @return WP_Post Next post.
3717       */
3718  	public function next_post() {
3719  
3720          ++$this->current_post;
3721  
3722          /** @var WP_Post */
3723          $this->post = $this->posts[ $this->current_post ];
3724          return $this->post;
3725      }
3726  
3727      /**
3728       * Sets up the current post.
3729       *
3730       * Retrieves the next post, sets up the post, sets the 'in the loop'
3731       * property to true.
3732       *
3733       * @since 1.5.0
3734       *
3735       * @global WP_Post $post Global post object.
3736       */
3737  	public function the_post() {
3738          global $post;
3739  
3740          if ( ! $this->in_the_loop ) {
3741              // Only prime the post cache for queries limited to the ID field.
3742              $post_ids = array_filter( $this->posts, 'is_numeric' );
3743              // Exclude any falsey values, such as 0.
3744              $post_ids = array_filter( $post_ids );
3745              if ( $post_ids ) {
3746                  _prime_post_caches( $post_ids, $this->query_vars['update_post_term_cache'], $this->query_vars['update_post_meta_cache'] );
3747              }
3748              $post_objects = array_map( 'get_post', $this->posts );
3749              update_post_author_caches( $post_objects );
3750          }
3751  
3752          $this->in_the_loop = true;
3753          $this->before_loop = false;
3754  
3755          if ( -1 === $this->current_post ) { // Loop has just started.
3756              /**
3757               * Fires once the loop is started.
3758               *
3759               * @since 2.0.0
3760               *
3761               * @param WP_Query $query The WP_Query instance (passed by reference).
3762               */
3763              do_action_ref_array( 'loop_start', array( &$this ) );
3764          }
3765  
3766          $post = $this->next_post();
3767          $this->setup_postdata( $post );
3768      }
3769  
3770      /**
3771       * Determines whether there are more posts available in the loop.
3772       *
3773       * Calls the {@see 'loop_end'} action when the loop is complete.
3774       *
3775       * @since 1.5.0
3776       *
3777       * @return bool True if posts are available, false if end of the loop.
3778       */
3779  	public function have_posts() {
3780          if ( $this->current_post + 1 < $this->post_count ) {
3781              return true;
3782          } elseif ( $this->current_post + 1 === $this->post_count && $this->post_count > 0 ) {
3783              /**
3784               * Fires once the loop has ended.
3785               *
3786               * @since 2.0.0
3787               *
3788               * @param WP_Query $query The WP_Query instance (passed by reference).
3789               */
3790              do_action_ref_array( 'loop_end', array( &$this ) );
3791  
3792              // Do some cleaning up after the loop.
3793              $this->rewind_posts();
3794          } elseif ( 0 === $this->post_count ) {
3795              $this->before_loop = false;
3796  
3797              /**
3798               * Fires if no results are found in a post query.
3799               *
3800               * @since 4.9.0
3801               *
3802               * @param WP_Query $query The WP_Query instance.
3803               */
3804              do_action( 'loop_no_results', $this );
3805          }
3806  
3807          $this->in_the_loop = false;
3808          return false;
3809      }
3810  
3811      /**
3812       * Rewinds the posts and resets post index.
3813       *
3814       * @since 1.5.0
3815       */
3816  	public function rewind_posts() {
3817          $this->current_post = -1;
3818          if ( $this->post_count > 0 ) {
3819              $this->post = $this->posts[0];
3820          }
3821      }
3822  
3823      /**
3824       * Iterates current comment index and returns WP_Comment object.
3825       *
3826       * @since 2.2.0
3827       *
3828       * @return WP_Comment Comment object.
3829       */
3830  	public function next_comment() {
3831          ++$this->current_comment;
3832  
3833          /** @var WP_Comment */
3834          $this->comment = $this->comments[ $this->current_comment ];
3835          return $this->comment;
3836      }
3837  
3838      /**
3839       * Sets up the current comment.
3840       *
3841       * @since 2.2.0
3842       *
3843       * @global WP_Comment $comment Global comment object.
3844       */
3845  	public function the_comment() {
3846          global $comment;
3847  
3848          $comment = $this->next_comment();
3849  
3850          if ( 0 === $this->current_comment ) {
3851              /**
3852               * Fires once the comment loop is started.
3853               *
3854               * @since 2.2.0
3855               */
3856              do_action( 'comment_loop_start' );
3857          }
3858      }
3859  
3860      /**
3861       * Determines whether there are more comments available.
3862       *
3863       * Automatically rewinds comments when finished.
3864       *
3865       * @since 2.2.0
3866       *
3867       * @return bool True if comments are available, false if no more comments.
3868       */
3869  	public function have_comments() {
3870          if ( $this->current_comment + 1 < $this->comment_count ) {
3871              return true;
3872          } elseif ( $this->current_comment + 1 === $this->comment_count ) {
3873              $this->rewind_comments();
3874          }
3875  
3876          return false;
3877      }
3878  
3879      /**
3880       * Rewinds the comments, resets the comment index and comment to first.
3881       *
3882       * @since 2.2.0
3883       */
3884  	public function rewind_comments() {
3885          $this->current_comment = -1;
3886          if ( $this->comment_count > 0 ) {
3887              $this->comment = $this->comments[0];
3888          }
3889      }
3890  
3891      /**
3892       * Sets up the WordPress query by parsing query string.
3893       *
3894       * @since 1.5.0
3895       *
3896       * @see WP_Query::parse_query() for all available arguments.
3897       *
3898       * @param string|array $query URL query string or array of query arguments.
3899       * @return WP_Post[]|int[] Array of post objects or post IDs.
3900       */
3901  	public function query( $query ) {
3902          $this->init();
3903          $this->query      = wp_parse_args( $query );
3904          $this->query_vars = $this->query;
3905          return $this->get_posts();
3906      }
3907  
3908      /**
3909       * Retrieves the currently queried object.
3910       *
3911       * If queried object is not set, then the queried object will be set from
3912       * the category, tag, taxonomy, posts page, single post, page, or author
3913       * query variable. After it is set up, it will be returned.
3914       *
3915       * @since 1.5.0
3916       *
3917       * @return WP_Term|WP_Post_Type|WP_Post|WP_User|null The queried object.
3918       */
3919  	public function get_queried_object() {
3920          if ( isset( $this->queried_object ) ) {
3921              return $this->queried_object;
3922          }
3923  
3924          $this->queried_object    = null;
3925          $this->queried_object_id = null;
3926  
3927          if ( $this->is_category || $this->is_tag || $this->is_tax ) {
3928              if ( $this->is_category ) {
3929                  $cat           = $this->get( 'cat' );
3930                  $category_name = $this->get( 'category_name' );
3931  
3932                  if ( $cat ) {
3933                      $term = get_term( $cat, 'category' );
3934                  } elseif ( $category_name ) {
3935                      $term = get_term_by( 'slug', $category_name, 'category' );
3936                  }
3937              } elseif ( $this->is_tag ) {
3938                  $tag_id = $this->get( 'tag_id' );
3939                  $tag    = $this->get( 'tag' );
3940  
3941                  if ( $tag_id ) {
3942                      $term = get_term( $tag_id, 'post_tag' );
3943                  } elseif ( $tag ) {
3944                      $term = get_term_by( 'slug', $tag, 'post_tag' );
3945                  }
3946              } else {
3947                  // For other tax queries, grab the first term from the first clause.
3948                  if ( ! empty( $this->tax_query->queried_terms ) ) {
3949                      $queried_taxonomies = array_keys( $this->tax_query->queried_terms );
3950                      $matched_taxonomy   = reset( $queried_taxonomies );
3951                      $query              = $this->tax_query->queried_terms[ $matched_taxonomy ];
3952  
3953                      if ( ! empty( $query['terms'] ) ) {
3954                          if ( 'term_id' === $query['field'] ) {
3955                              $term = get_term( reset( $query['terms'] ), $matched_taxonomy );
3956                          } else {
3957                              $term = get_term_by( $query['field'], reset( $query['terms'] ), $matched_taxonomy );
3958                          }
3959                      }
3960                  }
3961              }
3962  
3963              if ( ! empty( $term ) && ! is_wp_error( $term ) ) {
3964                  $this->queried_object    = $term;
3965                  $this->queried_object_id = (int) $term->term_id;
3966  
3967                  if ( $this->is_category && 'category' === $this->queried_object->taxonomy ) {
3968                      _make_cat_compat( $this->queried_object );
3969                  }
3970              }
3971          } elseif ( $this->is_post_type_archive ) {
3972              $post_type = $this->get( 'post_type' );
3973  
3974              if ( is_array( $post_type ) ) {
3975                  $post_type = reset( $post_type );
3976              }
3977  
3978              $this->queried_object = get_post_type_object( $post_type );
3979          } elseif ( $this->is_posts_page ) {
3980              $page_for_posts = get_option( 'page_for_posts' );
3981  
3982              $this->queried_object    = get_post( $page_for_posts );
3983              $this->queried_object_id = (int) $this->queried_object->ID;
3984          } elseif ( $this->is_singular && ! empty( $this->post ) ) {
3985              $this->queried_object    = $this->post;
3986              $this->queried_object_id = (int) $this->post->ID;
3987          } elseif ( $this->is_author ) {
3988              $author      = (int) $this->get( 'author' );
3989              $author_name = $this->get( 'author_name' );
3990  
3991              if ( $author ) {
3992                  $this->queried_object_id = $author;
3993              } elseif ( $author_name ) {
3994                  $user = get_user_by( 'slug', $author_name );
3995  
3996                  if ( $user ) {
3997                      $this->queried_object_id = $user->ID;
3998                  }
3999              }
4000  
4001              $this->queried_object = get_userdata( $this->queried_object_id );
4002          }
4003  
4004          return $this->queried_object;
4005      }
4006  
4007      /**
4008       * Retrieves the ID of the currently queried object.
4009       *
4010       * @since 1.5.0
4011       *
4012       * @return int
4013       */
4014  	public function get_queried_object_id() {
4015          $this->get_queried_object();
4016  
4017          if ( isset( $this->queried_object_id ) ) {
4018              return $this->queried_object_id;
4019          }
4020  
4021          return 0;
4022      }
4023  
4024      /**
4025       * Constructor.
4026       *
4027       * Sets up the WordPress query, if parameter is not empty.
4028       *
4029       * @since 1.5.0
4030       *
4031       * @see WP_Query::parse_query() for all available arguments.
4032       *
4033       * @param string|array $query URL query string or array of vars.
4034       */
4035  	public function __construct( $query = '' ) {
4036          if ( ! empty( $query ) ) {
4037              $this->query( $query );
4038          }
4039      }
4040  
4041      /**
4042       * Makes private properties readable for backward compatibility.
4043       *
4044       * @since 4.0.0
4045       *
4046       * @param string $name Property to get.
4047       * @return mixed Property.
4048       */
4049  	public function __get( $name ) {
4050          if ( in_array( $name, $this->compat_fields, true ) ) {
4051              return $this->$name;
4052          }
4053      }
4054  
4055      /**
4056       * Makes private properties checkable for backward compatibility.
4057       *
4058       * @since 4.0.0
4059       *
4060       * @param string $name Property to check if set.
4061       * @return bool Whether the property is set.
4062       */
4063  	public function __isset( $name ) {
4064          if ( in_array( $name, $this->compat_fields, true ) ) {
4065              return isset( $this->$name );
4066          }
4067  
4068          return false;
4069      }
4070  
4071      /**
4072       * Makes private/protected methods readable for backward compatibility.
4073       *
4074       * @since 4.0.0
4075       *
4076       * @param string $name      Method to call.
4077       * @param array  $arguments Arguments to pass when calling.
4078       * @return mixed|false Return value of the callback, false otherwise.
4079       */
4080  	public function __call( $name, $arguments ) {
4081          if ( in_array( $name, $this->compat_methods, true ) ) {
4082              return $this->$name( ...$arguments );
4083          }
4084          return false;
4085      }
4086  
4087      /**
4088       * Determines whether the query is for an existing archive page.
4089       *
4090       * Archive pages include category, tag, author, date, custom post type,
4091       * and custom taxonomy based archives.
4092       *
4093       * @since 3.1.0
4094       *
4095       * @see WP_Query::is_category()
4096       * @see WP_Query::is_tag()
4097       * @see WP_Query::is_author()
4098       * @see WP_Query::is_date()
4099       * @see WP_Query::is_post_type_archive()
4100       * @see WP_Query::is_tax()
4101       *
4102       * @return bool Whether the query is for an existing archive page.
4103       */
4104  	public function is_archive() {
4105          return (bool) $this->is_archive;
4106      }
4107  
4108      /**
4109       * Determines whether the query is for an existing post type archive page.
4110       *
4111       * @since 3.1.0
4112       *
4113       * @param string|string[] $post_types Optional. Post type or array of posts types
4114       *                                    to check against. Default empty.
4115       * @return bool Whether the query is for an existing post type archive page.
4116       */
4117  	public function is_post_type_archive( $post_types = '' ) {
4118          if ( empty( $post_types ) || ! $this->is_post_type_archive ) {
4119              return (bool) $this->is_post_type_archive;
4120          }
4121  
4122          $post_type = $this->get( 'post_type' );
4123          if ( is_array( $post_type ) ) {
4124              $post_type = reset( $post_type );
4125          }
4126          $post_type_object = get_post_type_object( $post_type );
4127  
4128          if ( ! $post_type_object ) {
4129              return false;
4130          }
4131  
4132          return in_array( $post_type_object->name, (array) $post_types, true );
4133      }
4134  
4135      /**
4136       * Determines whether the query is for an existing attachment page.
4137       *
4138       * @since 3.1.0
4139       *
4140       * @param int|string|int[]|string[] $attachment Optional. Attachment ID, title, slug, or array of such
4141       *                                              to check against. Default empty.
4142       * @return bool Whether the query is for an existing attachment page.
4143       */
4144  	public function is_attachment( $attachment = '' ) {
4145          if ( ! $this->is_attachment ) {
4146              return false;
4147          }
4148  
4149          if ( empty( $attachment ) ) {
4150              return true;
4151          }
4152  
4153          $attachment = array_map( 'strval', (array) $attachment );
4154  
4155          $post_obj = $this->get_queried_object();
4156          if ( ! $post_obj ) {
4157              return false;
4158          }
4159  
4160          if ( in_array( (string) $post_obj->ID, $attachment, true ) ) {
4161              return true;
4162          } elseif ( in_array( $post_obj->post_title, $attachment, true ) ) {
4163              return true;
4164          } elseif ( in_array( $post_obj->post_name, $attachment, true ) ) {
4165              return true;
4166          }
4167          return false;
4168      }
4169  
4170      /**
4171       * Determines whether the query is for an existing author archive page.
4172       *
4173       * If the $author parameter is specified, this function will additionally
4174       * check if the query is for one of the authors specified.
4175       *
4176       * @since 3.1.0
4177       *
4178       * @param int|string|int[]|string[] $author Optional. User ID, nickname, nicename, or array of such
4179       *                                          to check against. Default empty.
4180       * @return bool Whether the query is for an existing author archive page.
4181       */
4182  	public function is_author( $author = '' ) {
4183          if ( ! $this->is_author ) {
4184              return false;
4185          }
4186  
4187          if ( empty( $author ) ) {
4188              return true;
4189          }
4190  
4191          $author_obj = $this->get_queried_object();
4192          if ( ! $author_obj ) {
4193              return false;
4194          }
4195  
4196          $author = array_map( 'strval', (array) $author );
4197  
4198          if ( in_array( (string) $author_obj->ID, $author, true ) ) {
4199              return true;
4200          } elseif ( in_array( $author_obj->nickname, $author, true ) ) {
4201              return true;
4202          } elseif ( in_array( $author_obj->user_nicename, $author, true ) ) {
4203              return true;
4204          }
4205  
4206          return false;
4207      }
4208  
4209      /**
4210       * Determines whether the query is for an existing category archive page.
4211       *
4212       * If the $category parameter is specified, this function will additionally
4213       * check if the query is for one of the categories specified.
4214       *
4215       * @since 3.1.0
4216       *
4217       * @param int|string|int[]|string[] $category Optional. Category ID, name, slug, or array of such
4218       *                                            to check against. Default empty.
4219       * @return bool Whether the query is for an existing category archive page.
4220       */
4221  	public function is_category( $category = '' ) {
4222          if ( ! $this->is_category ) {
4223              return false;
4224          }
4225  
4226          if ( empty( $category ) ) {
4227              return true;
4228          }
4229  
4230          $cat_obj = $this->get_queried_object();
4231          if ( ! $cat_obj ) {
4232              return false;
4233          }
4234  
4235          $category = array_map( 'strval', (array) $category );
4236  
4237          if ( in_array( (string) $cat_obj->term_id, $category, true ) ) {
4238              return true;
4239          } elseif ( in_array( $cat_obj->name, $category, true ) ) {
4240              return true;
4241          } elseif ( in_array( $cat_obj->slug, $category, true ) ) {
4242              return true;
4243          }
4244  
4245          return false;
4246      }
4247  
4248      /**
4249       * Determines whether the query is for an existing tag archive page.
4250       *
4251       * If the $tag parameter is specified, this function will additionally
4252       * check if the query is for one of the tags specified.
4253       *
4254       * @since 3.1.0
4255       *
4256       * @param int|string|int[]|string[] $tag Optional. Tag ID, name, slug, or array of such
4257       *                                       to check against. Default empty.
4258       * @return bool Whether the query is for an existing tag archive page.
4259       */
4260  	public function is_tag( $tag = '' ) {
4261          if ( ! $this->is_tag ) {
4262              return false;
4263          }
4264  
4265          if ( empty( $tag ) ) {
4266              return true;
4267          }
4268  
4269          $tag_obj = $this->get_queried_object();
4270          if ( ! $tag_obj ) {
4271              return false;
4272          }
4273  
4274          $tag = array_map( 'strval', (array) $tag );
4275  
4276          if ( in_array( (string) $tag_obj->term_id, $tag, true ) ) {
4277              return true;
4278          } elseif ( in_array( $tag_obj->name, $tag, true ) ) {
4279              return true;
4280          } elseif ( in_array( $tag_obj->slug, $tag, true ) ) {
4281              return true;
4282          }
4283  
4284          return false;
4285      }
4286  
4287      /**
4288       * Determines whether the query is for an existing custom taxonomy archive page.
4289       *
4290       * If the $taxonomy parameter is specified, this function will additionally
4291       * check if the query is for that specific $taxonomy.
4292       *
4293       * If the $term parameter is specified in addition to the $taxonomy parameter,
4294       * this function will additionally check if the query is for one of the terms
4295       * specified.
4296       *
4297       * @since 3.1.0
4298       *
4299       * @global WP_Taxonomy[] $wp_taxonomies Registered taxonomies.
4300       *
4301       * @param string|string[]           $taxonomy Optional. Taxonomy slug or slugs to check against.
4302       *                                            Default empty.
4303       * @param int|string|int[]|string[] $term     Optional. Term ID, name, slug, or array of such
4304       *                                            to check against. Default empty.
4305       * @return bool Whether the query is for an existing custom taxonomy archive page.
4306       *              True for custom taxonomy archive pages, false for built-in taxonomies
4307       *              (category and tag archives).
4308       */
4309  	public function is_tax( $taxonomy = '', $term = '' ) {
4310          global $wp_taxonomies;
4311  
4312          if ( ! $this->is_tax ) {
4313              return false;
4314          }
4315  
4316          if ( empty( $taxonomy ) ) {
4317              return true;
4318          }
4319  
4320          $queried_object = $this->get_queried_object();
4321          $tax_array      = array_intersect( array_keys( $wp_taxonomies ), (array) $taxonomy );
4322          $term_array     = (array) $term;
4323  
4324          // Check that the taxonomy matches.
4325          if ( ! ( isset( $queried_object->taxonomy ) && count( $tax_array ) && in_array( $queried_object->taxonomy, $tax_array, true ) ) ) {
4326              return false;
4327          }
4328  
4329          // Only a taxonomy provided.
4330          if ( empty( $term ) ) {
4331              return true;
4332          }
4333  
4334          return isset( $queried_object->term_id ) &&
4335              count(
4336                  array_intersect(
4337                      array( $queried_object->term_id, $queried_object->name, $queried_object->slug ),
4338                      $term_array
4339                  )
4340              );
4341      }
4342  
4343      /**
4344       * Determines whether the current URL is within the comments popup window.
4345       *
4346       * @since 3.1.0
4347       * @deprecated 4.5.0
4348       *
4349       * @return false Always returns false.
4350       */
4351  	public function is_comments_popup() {
4352          _deprecated_function( __FUNCTION__, '4.5.0' );
4353  
4354          return false;
4355      }
4356  
4357      /**
4358       * Determines whether the query is for an existing date archive.
4359       *
4360       * @since 3.1.0
4361       *
4362       * @return bool Whether the query is for an existing date archive.
4363       */
4364  	public function is_date() {
4365          return (bool) $this->is_date;
4366      }
4367  
4368      /**
4369       * Determines whether the query is for an existing day archive.
4370       *
4371       * @since 3.1.0
4372       *
4373       * @return bool Whether the query is for an existing day archive.
4374       */
4375  	public function is_day() {
4376          return (bool) $this->is_day;
4377      }
4378  
4379      /**
4380       * Determines whether the query is for a feed.
4381       *
4382       * @since 3.1.0
4383       *
4384       * @param string|string[] $feeds Optional. Feed type or array of feed types
4385       *                                         to check against. Default empty.
4386       * @return bool Whether the query is for a feed.
4387       */
4388  	public function is_feed( $feeds = '' ) {
4389          if ( empty( $feeds ) || ! $this->is_feed ) {
4390              return (bool) $this->is_feed;
4391          }
4392  
4393          $qv = $this->get( 'feed' );
4394          if ( 'feed' === $qv ) {
4395              $qv = get_default_feed();
4396          }
4397  
4398          return in_array( $qv, (array) $feeds, true );
4399      }
4400  
4401      /**
4402       * Determines whether the query is for a comments feed.
4403       *
4404       * @since 3.1.0
4405       *
4406       * @return bool Whether the query is for a comments feed.
4407       */
4408  	public function is_comment_feed() {
4409          return (bool) $this->is_comment_feed;
4410      }
4411  
4412      /**
4413       * Determines whether the query is for the front page of the site.
4414       *
4415       * This is for what is displayed at your site's main URL.
4416       *
4417       * Depends on the site's "Front page displays" Reading Settings 'show_on_front' and 'page_on_front'.
4418       *
4419       * If you set a static page for the front page of your site, this function will return
4420       * true when viewing that page.
4421       *
4422       * Otherwise the same as {@see WP_Query::is_home()}.
4423       *
4424       * @since 3.1.0
4425       *
4426       * @return bool Whether the query is for the front page of the site.
4427       */
4428  	public function is_front_page() {
4429          // Most likely case.
4430          if ( 'posts' === get_option( 'show_on_front' ) && $this->is_home() ) {
4431              return true;
4432          } elseif ( 'page' === get_option( 'show_on_front' ) && get_option( 'page_on_front' )
4433              && $this->is_page( get_option( 'page_on_front' ) )
4434          ) {
4435              return true;
4436          } else {
4437              return false;
4438          }
4439      }
4440  
4441      /**
4442       * Determines whether the query is for the blog homepage.
4443       *
4444       * This is the page which shows the time based blog content of your site.
4445       *
4446       * Depends on the site's "Front page displays" Reading Settings 'show_on_front' and 'page_for_posts'.
4447       *
4448       * If you set a static page for the front page of your site, this function will return
4449       * true only on the page you set as the "Posts page".
4450       *
4451       * @since 3.1.0
4452       *
4453       * @see WP_Query::is_front_page()
4454       *
4455       * @return bool Whether the query is for the blog homepage.
4456       */
4457  	public function is_home() {
4458          return (bool) $this->is_home;
4459      }
4460  
4461      /**
4462       * Determines whether the query is for the Privacy Policy page.
4463       *
4464       * This is the page which shows the Privacy Policy content of your site.
4465       *
4466       * Depends on the site's "Change your Privacy Policy page" Privacy Settings 'wp_page_for_privacy_policy'.
4467       *
4468       * This function will return true only on the page you set as the "Privacy Policy page".
4469       *
4470       * @since 5.2.0
4471       *
4472       * @return bool Whether the query is for the Privacy Policy page.
4473       */
4474  	public function is_privacy_policy() {
4475          if ( get_option( 'wp_page_for_privacy_policy' )
4476              && $this->is_page( get_option( 'wp_page_for_privacy_policy' ) )
4477          ) {
4478              return true;
4479          } else {
4480              return false;
4481          }
4482      }
4483  
4484      /**
4485       * Determines whether the query is for an existing month archive.
4486       *
4487       * @since 3.1.0
4488       *
4489       * @return bool Whether the query is for an existing month archive.
4490       */
4491  	public function is_month() {
4492          return (bool) $this->is_month;
4493      }
4494  
4495      /**
4496       * Determines whether the query is for an existing single page.
4497       *
4498       * If the $page parameter is specified, this function will additionally
4499       * check if the query is for one of the pages specified.
4500       *
4501       * @since 3.1.0
4502       *
4503       * @see WP_Query::is_single()
4504       * @see WP_Query::is_singular()
4505       *
4506       * @param int|string|int[]|string[] $page Optional. Page ID, title, slug, path, or array of such
4507       *                                        to check against. Default empty.
4508       * @return bool Whether the query is for an existing single page.
4509       */
4510  	public function is_page( $page = '' ) {
4511          if ( ! $this->is_page ) {
4512              return false;
4513          }
4514  
4515          if ( empty( $page ) ) {
4516              return true;
4517          }
4518  
4519          $page_obj = $this->get_queried_object();
4520          if ( ! $page_obj ) {
4521              return false;
4522          }
4523  
4524          $page = array_map( 'strval', (array) $page );
4525  
4526          if ( in_array( (string) $page_obj->ID, $page, true ) ) {
4527              return true;
4528          } elseif ( in_array( $page_obj->post_title, $page, true ) ) {
4529              return true;
4530          } elseif ( in_array( $page_obj->post_name, $page, true ) ) {
4531              return true;
4532          } else {
4533              foreach ( $page as $pagepath ) {
4534                  if ( ! strpos( $pagepath, '/' ) ) {
4535                      continue;
4536                  }
4537  
4538                  $pagepath_obj = get_page_by_path( $pagepath );
4539  
4540                  if ( $pagepath_obj && ( $pagepath_obj->ID === $page_obj->ID ) ) {
4541                      return true;
4542                  }
4543              }
4544          }
4545  
4546          return false;
4547      }
4548  
4549      /**
4550       * Determines whether the query is for a paged result and not for the first page.
4551       *
4552       * @since 3.1.0
4553       *
4554       * @return bool Whether the query is for a paged result.
4555       */
4556  	public function is_paged() {
4557          return (bool) $this->is_paged;
4558      }
4559  
4560      /**
4561       * Determines whether the query is for a post or page preview.
4562       *
4563       * @since 3.1.0
4564       *
4565       * @return bool Whether the query is for a post or page preview.
4566       */
4567  	public function is_preview() {
4568          return (bool) $this->is_preview;
4569      }
4570  
4571      /**
4572       * Determines whether the query is for the robots.txt file.
4573       *
4574       * @since 3.1.0
4575       *
4576       * @return bool Whether the query is for the robots.txt file.
4577       */
4578  	public function is_robots() {
4579          return (bool) $this->is_robots;
4580      }
4581  
4582      /**
4583       * Determines whether the query is for the favicon.ico file.
4584       *
4585       * @since 5.4.0
4586       *
4587       * @return bool Whether the query is for the favicon.ico file.
4588       */
4589  	public function is_favicon() {
4590          return (bool) $this->is_favicon;
4591      }
4592  
4593      /**
4594       * Determines whether the query is for a search.
4595       *
4596       * @since 3.1.0
4597       *
4598       * @return bool Whether the query is for a search.
4599       */
4600  	public function is_search() {
4601          return (bool) $this->is_search;
4602      }
4603  
4604      /**
4605       * Determines whether the query is for an existing single post.
4606       *
4607       * Works for any post type excluding pages.
4608       *
4609       * If the $post parameter is specified, this function will additionally
4610       * check if the query is for one of the Posts specified.
4611       *
4612       * @since 3.1.0
4613       *
4614       * @see WP_Query::is_page()
4615       * @see WP_Query::is_singular()
4616       *
4617       * @param int|string|int[]|string[] $post Optional. Post ID, title, slug, path, or array of such
4618       *                                        to check against. Default empty.
4619       * @return bool Whether the query is for an existing single post.
4620       */
4621  	public function is_single( $post = '' ) {
4622          if ( ! $this->is_single ) {
4623              return false;
4624          }
4625  
4626          if ( empty( $post ) ) {
4627              return true;
4628          }
4629  
4630          $post_obj = $this->get_queried_object();
4631          if ( ! $post_obj ) {
4632              return false;
4633          }
4634  
4635          $post = array_map( 'strval', (array) $post );
4636  
4637          if ( in_array( (string) $post_obj->ID, $post, true ) ) {
4638              return true;
4639          } elseif ( in_array( $post_obj->post_title, $post, true ) ) {
4640              return true;
4641          } elseif ( in_array( $post_obj->post_name, $post, true ) ) {
4642              return true;
4643          } else {
4644              foreach ( $post as $postpath ) {
4645                  if ( ! strpos( $postpath, '/' ) ) {
4646                      continue;
4647                  }
4648  
4649                  $postpath_obj = get_page_by_path( $postpath, OBJECT, $post_obj->post_type );
4650  
4651                  if ( $postpath_obj && ( $postpath_obj->ID === $post_obj->ID ) ) {
4652                      return true;
4653                  }
4654              }
4655          }
4656          return false;
4657      }
4658  
4659      /**
4660       * Determines whether the query is for an existing single post of any post type
4661       * (post, attachment, page, custom post types).
4662       *
4663       * If the $post_types parameter is specified, this function will additionally
4664       * check if the query is for one of the Posts Types specified.
4665       *
4666       * @since 3.1.0
4667       *
4668       * @see WP_Query::is_page()
4669       * @see WP_Query::is_single()
4670       *
4671       * @param string|string[] $post_types Optional. Post type or array of post types
4672       *                                    to check against. Default empty.
4673       * @return bool Whether the query is for an existing single post
4674       *              or any of the given post types.
4675       */
4676  	public function is_singular( $post_types = '' ) {
4677          if ( empty( $post_types ) || ! $this->is_singular ) {
4678              return (bool) $this->is_singular;
4679          }
4680  
4681          $post_obj = $this->get_queried_object();
4682          if ( ! $post_obj ) {
4683              return false;
4684          }
4685  
4686          return in_array( $post_obj->post_type, (array) $post_types, true );
4687      }
4688  
4689      /**
4690       * Determines whether the query is for a specific time.
4691       *
4692       * @since 3.1.0
4693       *
4694       * @return bool Whether the query is for a specific time.
4695       */
4696  	public function is_time() {
4697          return (bool) $this->is_time;
4698      }
4699  
4700      /**
4701       * Determines whether the query is for a trackback endpoint call.
4702       *
4703       * @since 3.1.0
4704       *
4705       * @return bool Whether the query is for a trackback endpoint call.
4706       */
4707  	public function is_trackback() {
4708          return (bool) $this->is_trackback;
4709      }
4710  
4711      /**
4712       * Determines whether the query is for an existing year archive.
4713       *
4714       * @since 3.1.0
4715       *
4716       * @return bool Whether the query is for an existing year archive.
4717       */
4718  	public function is_year() {
4719          return (bool) $this->is_year;
4720      }
4721  
4722      /**
4723       * Determines whether the query is a 404 (returns no results).
4724       *
4725       * @since 3.1.0
4726       *
4727       * @return bool Whether the query is a 404 error.
4728       */
4729  	public function is_404() {
4730          return (bool) $this->is_404;
4731      }
4732  
4733      /**
4734       * Determines whether the query is for an embedded post.
4735       *
4736       * @since 4.4.0
4737       *
4738       * @return bool Whether the query is for an embedded post.
4739       */
4740  	public function is_embed() {
4741          return (bool) $this->is_embed;
4742      }
4743  
4744      /**
4745       * Determines whether the query is the main query.
4746       *
4747       * @since 3.3.0
4748       *
4749       * @global WP_Query $wp_the_query WordPress Query object.
4750       *
4751       * @return bool Whether the query is the main query.
4752       */
4753  	public function is_main_query() {
4754          global $wp_the_query;
4755          return $wp_the_query === $this;
4756      }
4757  
4758      /**
4759       * Sets up global post data.
4760       *
4761       * @since 4.1.0
4762       * @since 4.4.0 Added the ability to pass a post ID to `$post`.
4763       *
4764       * @global int     $id
4765       * @global WP_User $authordata
4766       * @global string  $currentday
4767       * @global string  $currentmonth
4768       * @global int     $page
4769       * @global array   $pages
4770       * @global int     $multipage
4771       * @global int     $more
4772       * @global int     $numpages
4773       *
4774       * @param WP_Post|object|int $post WP_Post instance or Post ID/object.
4775       * @return true True when finished.
4776       */
4777  	public function setup_postdata( $post ) {
4778          global $id, $authordata, $currentday, $currentmonth, $page, $pages, $multipage, $more, $numpages;
4779  
4780          if ( ! ( $post instanceof WP_Post ) ) {
4781              $post = get_post( $post );
4782          }
4783  
4784          if ( ! $post ) {
4785              return;
4786          }
4787  
4788          $elements = $this->generate_postdata( $post );
4789          if ( false === $elements ) {
4790              return;
4791          }
4792  
4793          $id           = $elements['id'];
4794          $authordata   = $elements['authordata'];
4795          $currentday   = $elements['currentday'];
4796          $currentmonth = $elements['currentmonth'];
4797          $page         = $elements['page'];
4798          $pages        = $elements['pages'];
4799          $multipage    = $elements['multipage'];
4800          $more         = $elements['more'];
4801          $numpages     = $elements['numpages'];
4802  
4803          /**
4804           * Fires once the post data has been set up.
4805           *
4806           * @since 2.8.0
4807           * @since 4.1.0 Introduced `$query` parameter.
4808           *
4809           * @param WP_Post  $post  The Post object (passed by reference).
4810           * @param WP_Query $query The current Query object (passed by reference).
4811           */
4812          do_action_ref_array( 'the_post', array( &$post, &$this ) );
4813  
4814          return true;
4815      }
4816  
4817      /**
4818       * Generates post data.
4819       *
4820       * @since 5.2.0
4821       *
4822       * @param WP_Post|object|int $post WP_Post instance or Post ID/object.
4823       * @return array|false Elements of post or false on failure.
4824       */
4825  	public function generate_postdata( $post ) {
4826  
4827          if ( ! ( $post instanceof WP_Post ) ) {
4828              $post = get_post( $post );
4829          }
4830  
4831          if ( ! $post ) {
4832              return false;
4833          }
4834  
4835          $id = (int) $post->ID;
4836  
4837          $authordata = get_userdata( $post->post_author );
4838  
4839          $currentday   = false;
4840          $currentmonth = false;
4841  
4842          $post_date = $post->post_date;
4843          if ( ! empty( $post_date ) && '0000-00-00 00:00:00' !== $post_date ) {
4844              // Avoid using mysql2date for performance reasons.
4845              $currentmonth = substr( $post_date, 5, 2 );
4846              $day          = substr( $post_date, 8, 2 );
4847              $year         = substr( $post_date, 2, 2 );
4848  
4849              $currentday = sprintf( '%s.%s.%s', $day, $currentmonth, $year );
4850          }
4851  
4852          $numpages  = 1;
4853          $multipage = 0;
4854          $page      = $this->get( 'page' );
4855          if ( ! $page ) {
4856              $page = 1;
4857          }
4858  
4859          /*
4860           * Force full post content when viewing the permalink for the $post,
4861           * or when on an RSS feed. Otherwise respect the 'more' tag.
4862           */
4863          if ( get_queried_object_id() === $post->ID && ( $this->is_page() || $this->is_single() ) ) {
4864              $more = 1;
4865          } elseif ( $this->is_feed() ) {
4866              $more = 1;
4867          } else {
4868              $more = 0;
4869          }
4870  
4871          $content = $post->post_content;
4872          if ( str_contains( $content, '<!--nextpage-->' ) ) {
4873              $content = str_replace( "\n<!--nextpage-->\n", '<!--nextpage-->', $content );
4874              $content = str_replace( "\n<!--nextpage-->", '<!--nextpage-->', $content );
4875              $content = str_replace( "<!--nextpage-->\n", '<!--nextpage-->', $content );
4876  
4877              // Remove the nextpage block delimiters, to avoid invalid block structures in the split content.
4878              $content = str_replace( '<!-- wp:nextpage -->', '', $content );
4879              $content = str_replace( '<!-- /wp:nextpage -->', '', $content );
4880  
4881              // Ignore nextpage at the beginning of the content.
4882              if ( str_starts_with( $content, '<!--nextpage-->' ) ) {
4883                  $content = substr( $content, 15 );
4884              }
4885  
4886              $pages = explode( '<!--nextpage-->', $content );
4887          } else {
4888              $pages = array( $post->post_content );
4889          }
4890  
4891          /**
4892           * Filters the "pages" derived from splitting the post content.
4893           *
4894           * "Pages" are determined by splitting the post content based on the presence
4895           * of `<!-- nextpage -->` tags.
4896           *
4897           * @since 4.4.0
4898           *
4899           * @param string[] $pages Array of "pages" from the post content split by `<!-- nextpage -->` tags.
4900           * @param WP_Post  $post  Current post object.
4901           */
4902          $pages = apply_filters( 'content_pagination', $pages, $post );
4903  
4904          $numpages = count( $pages );
4905  
4906          if ( $numpages > 1 ) {
4907              if ( $page > 1 ) {
4908                  $more = 1;
4909              }
4910              $multipage = 1;
4911          } else {
4912              $multipage = 0;
4913          }
4914  
4915          $elements = compact( 'id', 'authordata', 'currentday', 'currentmonth', 'page', 'pages', 'multipage', 'more', 'numpages' );
4916  
4917          return $elements;
4918      }
4919  
4920      /**
4921       * Generates cache key.
4922       *
4923       * @since 6.1.0
4924       *
4925       * @global wpdb $wpdb WordPress database abstraction object.
4926       *
4927       * @param array  $args Query arguments.
4928       * @param string $sql  SQL statement.
4929       * @return string Cache key.
4930       */
4931  	protected function generate_cache_key( array $args, $sql ) {
4932          global $wpdb;
4933  
4934          unset(
4935              $args['cache_results'],
4936              $args['fields'],
4937              $args['lazy_load_term_meta'],
4938              $args['update_post_meta_cache'],
4939              $args['update_post_term_cache'],
4940              $args['update_menu_item_cache'],
4941              $args['suppress_filters']
4942          );
4943  
4944          if ( empty( $args['post_type'] ) ) {
4945              if ( $this->is_attachment ) {
4946                  $args['post_type'] = 'attachment';
4947              } elseif ( $this->is_page ) {
4948                  $args['post_type'] = 'page';
4949              } else {
4950                  $args['post_type'] = 'post';
4951              }
4952          } elseif ( 'any' === $args['post_type'] ) {
4953              $args['post_type'] = array_values( get_post_types( array( 'exclude_from_search' => false ) ) );
4954          }
4955          $args['post_type'] = (array) $args['post_type'];
4956          // Sort post types to ensure same cache key generation.
4957          sort( $args['post_type'] );
4958  
4959          /*
4960           * Sort arrays that can be used for ordering prior to cache key generation.
4961           *
4962           * These arrays are sorted in the query generator for the purposes of the
4963           * WHERE clause but the arguments are not modified as they can be used for
4964           * the orderby clase.
4965           *
4966           * Their use in the orderby clause will generate a different SQL query so
4967           * they can be sorted for the cache key generation.
4968           */
4969          $sortable_arrays_with_int_values = array(
4970              'post__in',
4971              'post_parent__in',
4972          );
4973          foreach ( $sortable_arrays_with_int_values as $key ) {
4974              if ( isset( $args[ $key ] ) && is_array( $args[ $key ] ) ) {
4975                  $args[ $key ] = array_unique( array_map( 'absint', $args[ $key ] ) );
4976                  sort( $args[ $key ] );
4977              }
4978          }
4979  
4980          // Sort and unique the 'post_name__in' for cache key generation.
4981          if ( isset( $args['post_name__in'] ) && is_array( $args['post_name__in'] ) ) {
4982              $args['post_name__in'] = array_unique( $args['post_name__in'] );
4983              sort( $args['post_name__in'] );
4984          }
4985  
4986          if ( isset( $args['post_status'] ) ) {
4987              $args['post_status'] = (array) $args['post_status'];
4988              // Sort post status to ensure same cache key generation.
4989              sort( $args['post_status'] );
4990          }
4991  
4992          // Add a default orderby value of date to ensure same cache key generation.
4993          if ( ! isset( $q['orderby'] ) ) {
4994              $args['orderby'] = 'date';
4995          }
4996  
4997          $placeholder = $wpdb->placeholder_escape();
4998          array_walk_recursive(
4999              $args,
5000              /*
5001               * Replace wpdb placeholders with the string used in the database
5002               * query to avoid unreachable cache keys. This is necessary because
5003               * the placeholder is randomly generated in each request.
5004               *
5005               * $value is passed by reference to allow it to be modified.
5006               * array_walk_recursive() does not return an array.
5007               */
5008              static function ( &$value ) use ( $wpdb, $placeholder ) {
5009                  if ( is_string( $value ) && str_contains( $value, $placeholder ) ) {
5010                      $value = $wpdb->remove_placeholder_escape( $value );
5011                  }
5012              }
5013          );
5014  
5015          ksort( $args );
5016  
5017          // Replace wpdb placeholder in the SQL statement used by the cache key.
5018          $sql = $wpdb->remove_placeholder_escape( $sql );
5019          $key = md5( serialize( $args ) . $sql );
5020  
5021          $last_changed = wp_cache_get_last_changed( 'posts' );
5022          if ( ! empty( $this->tax_query->queries ) ) {
5023              $last_changed .= wp_cache_get_last_changed( 'terms' );
5024          }
5025  
5026          $this->query_cache_key = "wp_query:$key:$last_changed";
5027          return $this->query_cache_key;
5028      }
5029  
5030      /**
5031       * After looping through a nested query, this function
5032       * restores the $post global to the current post in this query.
5033       *
5034       * @since 3.7.0
5035       *
5036       * @global WP_Post $post Global post object.
5037       */
5038  	public function reset_postdata() {
5039          if ( ! empty( $this->post ) ) {
5040              $GLOBALS['post'] = $this->post;
5041              $this->setup_postdata( $this->post );
5042          }
5043      }
5044  
5045      /**
5046       * Lazyloads term meta for posts in the loop.
5047       *
5048       * @since 4.4.0
5049       * @deprecated 4.5.0 See wp_queue_posts_for_term_meta_lazyload().
5050       *
5051       * @param mixed $check
5052       * @param int   $term_id
5053       * @return mixed
5054       */
5055  	public function lazyload_term_meta( $check, $term_id ) {
5056          _deprecated_function( __METHOD__, '4.5.0' );
5057          return $check;
5058      }
5059  
5060      /**
5061       * Lazyloads comment meta for comments in the loop.
5062       *
5063       * @since 4.4.0
5064       * @deprecated 4.5.0 See wp_lazyload_comment_meta().
5065       *
5066       * @param mixed $check
5067       * @param int   $comment_id
5068       * @return mixed
5069       */
5070  	public function lazyload_comment_meta( $check, $comment_id ) {
5071          _deprecated_function( __METHOD__, '4.5.0' );
5072          return $check;
5073      }
5074  }


Generated : Fri Feb 21 08:20:01 2025 Cross-referenced by PHPXref