Problem By Yoast Local SEO

Hi,

I’m sorry for the late response.

The posts query becomes invalid when the plugin is activated.

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts 
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id) 
LEFT JOIN wp_term_relationships AS tt1
ON (wp_posts.ID = tt1.object_id)
INNER JOIN wp_postmeta
ON (wp_posts.ID = wp_postmeta.post_id)
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (3) 
AND tt1.term_taxonomy_id IN (3) )
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.IDwp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 10

We’ve added this code in the functions.php file to fix the issue.

add_filter('posts_groupby_request', 'avf_posts_groupby_request_mod', 10, 1);
function avf_posts_groupby_request_mod($groupby) {
	if(is_tag()) {
		$groupby = 'wp_posts.ID';
	}
	return $groupby;
}

Please ask the plugin author if there’s a function inside the plugin that alters the posts query.

Best regards,
Ismael