The thing here is that Aliases are used to join tables, and those joins are made using LEFT JOIN. That's how it goes to associated tables and query by fields on them.
Do you have created indexes in all fields involved in the conditions and joins?
The thing here is that Aliases are used to join tables, and those joins are made using LEFT JOIN. That's how it goes to associated tables and query by fields on them.