That is a pretty gnarly query. I would suggest using a MySQL query analyzer like this one:
tools.percona.com/