Hello!!
A few weeks ago (after update geodirectory) one query is loading my database, this runs many times in parallel. I think is related to sitemap generation (Yoast seo) but is a particular geodirectory table (maybe poor optimized). Please help me, my site is broken.
wp_geodir_post_locations= 493 rows
wp_geodir_gd_place_detail= 505104 Rows
wp_posts =679706 Rows
SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country, l.region_slug AS region FROM wp_geodir_post_locations l LEFT JOIN wp_geodir_gd_place_detail pd ON ( pd.country = l.country AND pd.region = l.region ) LEFT JOIN wp_posts p ON p.ID = pd.post_id LEFT JOIN wp_term_relationships
AS tr ON tr.object_id = p.ID LEFT JOIN
wp_term_taxonomy
AS tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id AND tt.taxonomy = 'gd_place_tags' ) WHERE p.post_type = 'gd_place' AND p.post_status = 'publish' AND l.location_id IS NOT NULL AND tt.term_id IS NOT NULL AND l.country_slug LIKE 'colombia' GROUP BY CONCAT(tt.term_id, '-', l.country_slug, '-', l.region_slug) ORDER BY date_gmt DESC
PD:Please don’t suggest cache queries in the database, it is not possible in my case.
Thanks!!