Hi,

We have 2 SELECT that are being joined via UNION.
The code being like this:

(SELECT x, y, z
FROM swd, swv
WHERE swv .keyword = '$find'
AND likes > 0
AND swv .meta_id = swd.id
AND display = 'yes'
ORDER BY likes DESC)
UNION
(SELECT x, y, z
FROM swd
WHERE MATCH (kw1, kw2, kw3, kw4, kw5, kw6, kw7, kw8, kw9, kw10) AGAINST('$find')
AND display = 'yes'
LIMIT $start, $page)

So, when the 1st SELECT is run by itself it does correctly return the results ORDERed BY number of likes DECS

However, when the 2 SELECTS are run together in the UNION, the ORDER BY DESC of the 1st SELECT is lost!
What is going on?
What do we need to do to maintain ORDER BY DESC when the 2 SELECTS are in UNION?

ThanX
Dean