Optimizing complex sql query MySql 8.0

Transact-SQL
4

Can you post it as text? The columns cut off on the right might have relevant info.