Getting Help with MySQL Query

Hello,

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!

Thanks,
Justin

Hi,

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.