Refactor Mysql View

I have received a view in MySQL that has too many joins and goes beyond the 61 table limit. I need it done correctly.

I have included the sql file to look at.

Thanks!