Is there a workaround for using LIMIT in a subquery in MySQL?
Here is my original query... SELECT `id` FROM `properties` LIMIT 10, 20 The LIMIT condition is for pagination. Now, I have to get all like before, but I need to get only a third of rows where a condition is present. I came up with this, just throwing LIMIT 30 in before I figured out how to do (total rows matched / 3) * 2. SELECT...