Optimizing view failed - Error running report - answers.map_prod_lvl1_id breaks it

Summary:

Hello,

We are experiencing issues with all report using answers.map_prod_lvl1_id.

Our goal is to simply display the answers created in a specific period of time (lets say 1 year) in all our interfaces and display only the product level 1 associated with each answer alongside other information such as Answer ID, summary and Language.

The report was working fine up until 2 months ago but now when running it I receive the error "Optimizing view failed" and on the error logs located in Logs→Error Log I can see a new entry with "SOAP SQL: SQL Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE"