Function __global->remove_unneeded_joins_rough
Definitions
sources/database_search.php
- Optimise out JOIN queries we don't need, using a fairly simple MySQL-centric algorithm.We do this as apparently on at least some MySQL versions unused LEFT JOINs are not optimised out.Assumes that any fields from a join are referenced using the JOINs alias.
- Is abstract?: No
- Is static?: No
- Is final?: No
- Return: string
Parameters
| Name | Type | Default | Set | Range | Description |
|---|---|---|---|---|---|
| $query | string | required parameter | N/A | N/A | The SQL query |
Return
- Optimised query
- Type: string
- Set: N/A
- Range: N/A