Fix MySQL/MariaDB query where limit of 61 tables is hit

I am trying to get data out of a system whereby the way the data is stored means I have to join individual fields to table instances to get the data - this works but once the data set increases we hit the limit of:

#1116 - Too many tables; MariaDB can only use 61 tables in a join

I found an article on Stackoverflow which talks about using sub-queries to overcome this so I think it is possible (https://stackoverflow.com/questions/11953995/does-the-limit-on-the-maximum-number-of-sql-join-tables-apply-to-the-whole-query/20134402#20134402) but I am not able to get it to work.

I cannot reduce the field numbers or table numbers hence the join numbers so if anyone is confident they can do this using sub-queries or unions then please get in touch. Basically, I have 70+ joins at the moment and I need to be able to get all the data out in a single query.

Sanitised version of the query is attached