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:
1 to 39 of 39
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. }