Reset Data doesn't work

Hi,

That’s a bit of a misunderstanding here. The reset data feature is removing “single day” entries – it does not remove overall views count.

There is a way to achieve what you described. For now it requires to use a WP filter, but there are plans to introduce some more user-friendly methods.

First, paste this into functions.php of your theme:

function pvc_custom_posts_join($join, $query) {
	global $wpdb;

	// the key part is pvc.type = 0, 0 is for daily views
	if(isset($query->order_by_post_views) && $query->order_by_post_views)
		$join .= " LEFT JOIN ".$wpdb->prefix."post_views pvc ON pvc.id = ".$wpdb->prefix."posts.ID AND pvc.type = 0";

	return $join;
}
add_filter('posts_join', 'pvc_custom_posts_join', 11, 2);

Then you just run standard WP query, with “orderby” parameter set to “post_views”, to get the desired posts ordered by post views.

Thanks for the code, but when I use it I receive the following error:

WordPress database error: [Not unique table/alias: 'pvc']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_posts AS p2 ON (wp_posts.post_parent = p2.ID) LEFT JOIN wp_post_views pvc ON pvc.id = wp_posts.ID AND pvc.type = 4 LEFT JOIN wp_post_views pvc ON pvc.id = wp_posts.ID AND pvc.type = 0 WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (21,31,33,34,42,43,44) ) AND wp_posts.post_type = 'page' AND (((wp_posts.post_status = 'publish') OR (wp_posts.post_status = 'inherit' AND (p2.post_status = 'publish')))) GROUP BY wp_posts.ID, wp_posts.ID ORDER BY pvc.count DESC, wp_posts.ID DESC LIMIT 0, 12

Any ideas?

I didn’t test that. But as the message says try changing pvc alias to seomthing different (pvc2)