Getting Help with MySQL Query


I’m having some trouble with query #PTsgIv0J.

Whenever this query is called, the CPU drives up on the server - and the site that calls the query hangs. It isn’t until I kill the PID that the site recovers. Any advice is greatly appreciated!



I can’t able to check your query. can you provide the explain plan of that query and show table status of those tables which are involved in query?
MySQL/Percona version will also help. Thanks.