Note that while the (simplified) example above doesn’t look too bad, it gets way worse as you add more associations. With 8 associations you get ~64 joins, which critically will get MariaDB/MySQL to reject the SQL as they only support up to 61 joins… understandably.