Click on the advice to get more details.
OUTER JOIN defeated
The reference to an outer table column in the WHERE clause prevents the OUTER JOIN from returning any non-matched rows, which implicitly converts the query to an INNER JOIN. This is probably a bug in the query or a misunderstanding of how OUTER JOIN works.
Rule ID: JOI.003
Unquoted date/time literal
A query such as "WHERE col<2010-02-12" is valid SQL but is probably a bug, because it will be interpreted as "WHERE col<1996"; the literal should be quoted.
Rule ID: LIT.002
Selecting all columns with the * wildcard will cause the query's meaning and behavior to change if the table's schema changes, and might cause the query to retrieve too much data.
Rule ID: COL.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: #BzN1BzsK.
- 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