Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.
Using BETWEEN instead of LIMIT and OFFSET proved to be a simple optimization to a troublesome slow MySQL query.