When the issue occurred we were using the full version, not decaff. The issue caused event espresso to get disabled automatically by WordPress and in the emergency we re-enabled it as decaff.
WordPress.com is insistent that the query is too intensive and caused the problem. It seems WordPress blame EE, and EE are blaming WordPress leaving us in a very difficult position. I would appreciate your honest professional opinion about what we need to do here.