This is a Shared SQL Query
Shlomi decided to share this query with you.
You can generate, save, and share your own queries easily, too! Click here to get started.
> Advice for this Query
Click on the advice to get more details.
Non-deterministic GROUP BY
The SQL retrieves columns that are neither in an aggregate function nor the GROUP BY expression, so these values will be non-deterministic in the result.
Rule ID: RES.001
SELECT without WHERE
The SELECT statement has no WHERE clause and could examine many more rows than intended.
Rule ID: CLA.001
Do you need help resolving the problems with this query? Here are some resources:
- If this tool provided bad advice, use the feedback form at left to report a bug.
Please mention your query ID: #PLUQIJmK. - Ask your friends to look at it
- Paste the link in a forum, such as Percona's performance forums
-
Percona offers expert MySQL support services to help you optimize and rewrite problematic queries.
You can contact us as follows:
- Sales USA +1-888-316-9775 M-F 8-5 Pacific time
- Sales UK +44-208-133-0309 M-F 8-5 London time