8.3.1.15 Optimizing LIMIT Queries

In some cases, MySQL handles a query differently when you are using LIMIT row_count and not using HAVING: