You appear to be a bot. Output may be restricted

Description

Retrieve an array of published posts from the last 2 days.

Usage

$array = Jetpack_Sitemap_Librarian::query_most_recent_posts( $num_posts );

Parameters

$num_posts

( int ) required – Largest number of posts to retrieve.

Returns

array The posts.

Source

File name: jetpack/modules/sitemaps/sitemap-librarian.php
Lines:

  public function query_most_recent_posts( $num_posts ) {
    global $wpdb;

    $two_days_ago = date( 'Y-m-d', strtotime( '-2 days' ) );

    
/**
 * Filter post types to be included in news sitemap.
 *
 * @module sitemaps
 *
 * @since 3.9.0
 *
 * @param array $post_types Array with post types to include in news sitemap.
 */
    $post_types = apply_filters(
      'jetpack_sitemap_news_sitemap_post_types',
      array( 'page', 'post' )
    );

    foreach ( (array) $post_types as $i => $post_type ) {
      $post_types[ $i ] = $wpdb->prepare( '%s', $post_type );
    }

    $post_types_list = join( ',', $post_types );

    return $wpdb->get_results(
      $wpdb->prepare(
        "SELECT *
					FROM $wpdb->posts
					WHERE post_status='publish'
						AND post_date >= '%s'
						AND post_type IN ($post_types_list)
					ORDER BY post_date DESC
					LIMIT %d;",
        $two_days_ago,
        $num_posts
      )
    ); // WPCS: db call ok; no-cache ok.
  }
 

 View on GitHub View on Trac