Optimize slow SQL query caused by usage of multiple JOIN clauses in MySQL 5.6 with InnoDB
How to optimize execution plan for query with multiple outer joins to huge tables, group by and order by clauses?