Too many JOINs is a symptom of complex spaghetti queries. Consider splitting up the complex query into many simpler queries, and reduce the number of JOINs