Get by date interval

I was searching the same, but couldn’t find anything, so i wrote my own “quick and dirty” function. Maybe someone find it useful. The function accepts three parameters:

• $post_type = Name of a post type
• $days = Number of days that should be included up to the current date
• $limit = The number of posts

It’s a very specific function and not as comfortable as a WP_Query request, but i thought i share this here :)

function pvc_get_posts_by_interval( string $post_type, int $days = 3, int $limit = 6 ) 
{
	global $wpdb;

	$date_since = date( 'Ymd', strtotime( "-{$days} days" ) );

	$query = "SELECT wpp.*, SUM(pvc.count) AS total 
		FROM {$wpdb->prefix}post_views pvc, {$wpdb->prefix}posts wpp
		WHERE pvc.period >= %d
			AND pvc.type = 0 
			AND wpp.post_type = '%s'
			AND pvc.id = wpp.ID
		GROUP BY pvc.id 
		ORDER BY total DESC
		LIMIT %d";
	
	return $wpdb->get_results( 
		$wpdb->prepare( 
			$query,
			$date_since,
			$post_type,
			$limit
		) 
	);
}

You can use the following in your theme to loop through the results:

$top_views = pvc_get_posts_by_interval( 'post', 15, 20 );
foreach ( $top_views as $post ) : setup_postdata( $top_views );

	// Loop - You can use functions like the_title()

endforeach;
wp_reset_postdata();

Thanks, but this can’t do the same as my own function. I needed a function, that gives me the most viewed posts of the last 3, 7 or 30 days (or any other specific day count) alongside with their view count of this period.

Your views_query example above would be great, if i could use the “after”, “before” or “compare” arguments to define time periods like in the date_query. Only yearly, monthly, weekly and daily views data is not exactly what i need.

This feature will be great. I am going to implement custom orderby attribute “views_X_days” where X is the number of days to take into account.

Anyone did this?