Re: union and missing limits

[M B]

Don't get me wrong :) I'm very grateful for your help!

Now it's working, kind of... different result than the query without inner limits.

I do not understand something, can you please explain to me?

Let's say there's 5000 of total records.

1. Inner selects are WITHOUT limits, outer has 50, so outer select will have 5000 rows where to choose the first 50 rows to display.

2. Both inner selects and outer has limit 50. Now outer select has only 100 rows from where to choose that 50 first rows.

Are those claims correct? If they are, that UNION with inner LIMITS are never going to show correct results...

Or (probably) I'm missing something...