Mariadb report takes over 5hrs to run against Mariadb 10.7.3 server

One of our reports is extremely slow when run against 10.7.3 server. It takes over 5 hours whereas the same report run against 10.6.7 takes only 2 minutes. The SQL has been attached (slowsql.txt)

Screenshot for Results against 10.7.3

Screenshot for Results against 10.6.7

I have reproduced the results in a third party product called Squirrel.

When running the query and returning 100 rows for 10.6.7
the query results are returned in 37.588 seconds

When running the query and returning 100 rows for 10.7.3
the query results are returned in 544.163 seconds

When running the query and returning 1000 rows for 10.6.7
the query results are returned in 86.245 seconds

Screenshot for 10.6.7

When running the query and returning 1000 rows for 10.7.3
the query results are returned in 3376.95 seconds

Screenshot for 10.7.3

Attached is the 7zip compressed file for ddl (gosales_1021.7z) and the sql which is extremely slow (slowsql.txt)