Query sending data

Hi the below query keeps getting stuck sending data in mysql.

It will get stuck in sending data for a few hours then another of the same query will appear then another all building up and leading to an error on the site.

I have deactivated and re started plugins which worked for a while then I re uploaded my theme which again worked for a while

But now the problem persists.

Can I ask what runs this query so I can better understand of how I can resolve this once and for all?

I know it’s gonna be something simple but it’s driving me crazy.

I’m using geotravel theme and recently upgraded from v1 to v2
Thanks

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