Query issues

Hi there

The below query was run by geodirectory and my hosting provider advised it was due to

“wp_geodir_post_locations is missing a proper key in the query and in the above case the query had been running for 1.5 hours”

Are you able to advise if something needs fixing?

SELECT tt.term_id, MAX(p.post_modified_gmt) AS date_gmt, l.country_slug AS country FROM wp_geodir_post_locations l LEFT JOIN wp_geodir_gd_place_detail pd ON pd.country = l.country 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_placecategory’ ) 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 GROUP BY CONCAT(tt.term_id, ‘-‘, l.country_slug) ORDER BY date_gmt DESC