àß=Íù O‡]ø¶Ð € æ›Ov p>Íù €·Cf±Ð € æ›à– p>Íù ‡²ˆ € æ›à¶@p>Íù O‡]ø¶Ð € æ›àÖ`p>Íù ‡²ˆ € æ›àö€p>Íù O‡]ø¶Ð € æ›à p>Íù ‡²ˆ € æ›à6Àp>Íù O‡]ø¶Ð € æ›àVàp>Íù €·Cf±Ð € æ›àv q>Íù ‡²ˆ € æ›á– q>Íù O‡]ø¶Ð € æ›á¶@q>Íù ‡²ˆ € æ›áÖ`q>Íù O‡]ø¶Ð € æ›áö€q>Íù ‡²ˆ € æ›á q>Íù O‡]ø¶Ð € æ›á6Àq>Íù €·Cf±Ð € æ›áVàq>Íù ‡²ˆ € æ›áv r>Íù O‡]ø¶Ð € æ›â– r>Íù ‡²ˆ € æ›â¶@r>Íù O‡]ø¶Ð € æ›âÖ`r>Íù ‡²ˆ € æ›âö€r>Íù O‡]ø¶Ð € æ›â r>Íù €·Cf±Ð € æ›â6Àr>Íù ‡²ˆ € æ›âVàr>Íù O‡]ø¶Ð € æ›âv s>Íù ‡²ˆ € æ›ã– s>Íù O‡]ø¶Ð € æ›ã¶@s>Íù ‡²ˆ € æ›ãÖ`s>Íù O‡]ø¶Ð € æ›ãö€s>Íù €·Cf±Ð € æ›ã s>Íù ‡²ˆ € æ›ã6Às>Íù O‡]ø¶Ð € æ›ãVàs>Íù ‡²ˆ € æ›ãv t>Íù O‡]ø¶Ð € æ›ä– t>Íù ‡²ˆ € æ›ä¶@t>Íù O‡]ø¶Ð € æ›äÖ`t>Íù €·Cf±Ð € æ›äö€t>Íù ‡²ˆ € æ›ä t>Íù O‡]ø¶Ð € æ›ä6Àt>Íù ‡²ˆ € æ›äVàt>Íù O‡]ø¶Ð € æ›äv u>Íù ‡²ˆ € æ›å– u>Íù O‡]ø¶Ð € æ›å¶@u>Íù €·Cf±Ð € æ›åÖ`u>Íù ‡²ˆ € æ›åö€u>Íù O‡]ø¶Ð € æ›å u>Íù ‡²ˆ € æ›å6Àu>Íù O‡]ø¶Ð € æ›åVàu>Íù ‡²ˆ € æ›åv v>Íù O‡]ø¶Ð € æ›æ– v>Íù €·Cf±Ð € æ›æ¶@v>Íù ‡²ˆ € æ›æÖ`v>Íù O‡]ø¶Ð € æ›æö€v>Íù ‡²ˆ € æ›æ v>Íù O‡]ø¶Ð € æ›æ6Àv>Íù ‡²ˆ € æ›æVàv>Íù O‡]ø¶Ð € æ›æv w>Íù €·Cf±Ð € æ›ç– w>Íù ‡²ˆ € æ›ç¶@w>Íù O‡]ø¶Ð € æ›çÖ`w>Íù ‡²ˆ € æ›çö€w>Íù O‡]ø¶Ð € æ›ç w>Íù ‡²ˆ € æ›ç6Àw>Íù O‡]ø¶Ð € æ›çVàw>Íù €·Cf±Ð € æ›çv x>Íù ‡²ˆ € æ›è– x>Íù O‡]ø¶Ð € æ›è¶@x>Íù ‡²ˆ € æ›èÖ`x>Íù O‡]ø¶Ð € æ›èö€x>Íù ‡²ˆ € æ›è x>Íù O‡]ø¶Ð € æ›è6Àx>Íù €·Cf±Ð € æ›èVàx>Íù ‡²ˆ € æ›èv y>Íù O‡]ø¶Ð € æ›é– y>Íù ‡²ˆ € æ›é¶@y>Íù O‡]ø¶Ð € æ›éÖ`y>Íù ‡²ˆ € æ›éö€y>Íù O‡]ø¶Ð € æ›é y>Íù €·Cf±Ð € æ›é6Ày>Íù ‡²ˆ € æ›éVày>Íù O‡]ø¶Ð € æ›év z>Íù ‡²ˆ € æ›ê– z>Íù O‡]ø¶Ð € æ›ê¶@z>Íù ‡²ˆ € æ›êÖ`z>Íù O‡]ø¶Ð € æ›êö€z>Íù €·Cf±Ð € æ›ê z>Íù ‡²ˆ € æ›ê6Àz>Íù O‡]ø¶Ð € æ›êVàz>Íù ‡²ˆ € æ›êv {>Íù O‡]ø¶Ð € æ›ë– {>Íù ‡²ˆ € æ›ë¶@{>Íù O‡]ø¶Ð € æ›ëÖ`{>Íù €·Cf±Ð € æ›ëö€{>Íù ‡²ˆ € æ›ë {>Íù O‡]ø¶Ð € æ›ë6À{>Íù ‡²ˆ € æ›ëVà{>Íù O‡]ø¶Ð € æ›ëv |>Íù ‡²ˆ € æ›ì– |>Íù O‡]ø¶Ð € æ›ì¶@|>Íù €·Cf±Ð € æ›ìÖ`|>Íù ‡²ˆ € æ›ìö€|>Íù O‡]ø¶Ð € æ›ì |>Íù ‡²ˆ € æ›ì6À|>Íù O‡]ø¶Ð € æ›ìVà|>Íù ‡²ˆ € æ›ìv }>Íù O‡]ø¶Ð € æ›í– }>Íù €·Cf±Ð € æ›í¶@}>Íù ‡²ˆ € æ›íÖ`}>Íù O‡]ø¶Ð € æ›íö€}>Íù ‡²ˆ € æ›í }>Íù O‡]ø¶Ð € æ›í6À}>Íù ‡²ˆ € æ›íVà}>Íù O‡]ø¶Ð € æ›ív ~>Íù €·Cf±Ð € æ›î– ~>Íù ‡²ˆ € æ›î¶@~>Íù O‡]ø¶Ð € æ›îÖ`~>Íù ‡²ˆ € æ›îö€~>Íù O‡]ø¶Ð € æ›î ~>Íù ‡²ˆ € æ›î6À~>Íù O‡]ø¶Ð € æ›îVà~>Íù €·Cf±Ð € æ›îv >Íù ‡²ˆ € æ›ï– >Íù O‡]ø¶Ð € æ›ï¶@>Íù ‡²ˆ € æ›ïÖ`>Íù O‡]ø¶Ð € æ›ïö€>Íù ‡²ˆ € æ›ï >Íù O‡]ø¶Ð € æ›ï6À>Íù €·Cf±Ð € æ›ïVpost_type IN (" . \implode( ', ', \array_fill( 0, \count( $post_types ), '%s' ) ) . ') AND P.post_status NOT IN (' . \implode( ', ', \array_fill( 0, \count( $excluded_post_statuses ), '%s' ) ) . ") AND P.ID not in ( SELECT I.object_id from $indexable_table as I WHERE I.object_type = 'post' AND I.version = %d )", $replacements ); } /** * Builds a query for selecting the ID's of unindexed posts. * * @param bool $limit The maximum number of post IDs to return. * * @return string The prepared query string. */ protected function get_select_query( $limit = false ) { $indexable_table = Model::get_table_name( 'Indexable' ); $post_types = $this->post_type_helper->get_indexable_post_types(); $excluded_post_statuses = $this->post_helper->get_excluded_post_statuses(); $replacements = \array_merge( $post_types, $excluded_post_statuses ); $replacements[] = $this->version; $limit_query = ''; if ( $limit ) { $limit_query = 'LIMIT %d'; $replacements[] = $limit; } // Warning: If this query is changed, makes sure to update the query in get_count_query as well. // @phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.ReplacementsWrongNumber return $this->wpdb->prepare( " SELECT P.ID FROM {$this->wpdb->posts} AS P WHERE P.post_type IN (" . \implode( ', ', \array_fill( 0, \count( $post_types ), '%s' ) ) . ') AND P.post_status NOT IN (' . \implode( ', ', \array_fill( 0, \count( $excluded_post_statuses ), '%s' ) ) . ") AND P.ID not in ( SELECT I.object_id from $indexable_table as I WHERE I.object_type = 'post' AND I.version = %d ) $limit_query", $replacements ); } }