Re: optimize select query

[Rick James]

Multiple, nested, groupwise max?? Ouch.

Study the examples in the links in here
http://forums.mysql.com/read.php?10,400440,401023
The reformulate the subqueries.

Perhaps we should first focus on

      and  bo.first_value = 
      ( SELECT  max(book1.first_value)
            from  bookmakers book1
            where  book1.event_id = je.id
              and  book1.insert_date = 
              ( SELECT  max(insert_date)
                    from  bookmakers
                    where  event_id = je.id
                      and  bookmaker_id = book1.bookmaker_id))

until you can avoid those subqueries.