How to solve the problem of exceeding the maximum number of JOINs?

Question

MySQL

too many tables; MySQL can only use 61 tables in a join

https://dev.1c-bitrix.ru/community/webdev/user/948... - here the guy asked, but he was not answered.
I faced the same problem.

Answer 1

There are two solutions - good and correct.
The good thing is not to make such cumbersome queries.
And the right thing is to refrain from working with the database at all.

Answer 2

You may need to use virtual tables and views.
Here is a link to habré https://m.habrahabr.ru/post/47031/

Answer 3

Maybe where possible, use nested queries and union?

Answer 4

Store properties in a separate table, not in a shared one