Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.
Concatenating Subqueries with Multiple Results in MySQL
ERROR: Subquery returns more than 1 row Error Code: 1242 The "Subquery returns more than 1 row" error may indicate that your data is not normalized properly especially if your data relationships are supposed to be one-to-one. However, if you have data with one-to-many relationships like items in multiple categories…