Hello,

When I issue you this SELECT statement by itself:

SELECT swi.email
FROM swd, swi
WHERE swd.category IN (147)
AND swd.answer = 'yes'
AND swi.id = swd.ix_id
ORDER BY RAND()
LIMIT 500;

produces 500 results.

But when I issue the same SELECT via a UNION, that is this:

(SELECT email
FROM users
WHERE category IN (147)
AND answer='yes'
AND user_status = '1'
ORDER BY RAND()
LIMIT 250)
UNION
(SELECT swi.email
FROM swd, swi
WHERE swd.category IN (147)
AND swd.answer = 'yes'
AND swi.id = swd.ix_id
ORDER BY RAND()
LIMIT 500);

Then I am getting 410 results!
So I should be getting at least 500, which I am getting when 2nd SELECT is issued by itself, however when I put it in this UNION then I am getting
less than what I was getting when the 2nd SELECT was issued by itself!

What is going on???

Regards,