MYSQL Union Order By Question

[eluser]bubaphex[/eluser]
Hi All,

Im trying to order my query in two places, the first select, and the second select.

I dont wish to order my query as a whole.

My query:

Code:

SELECT * FROM jos_content WHERE introtext LIKE 'something' AND state = '1' UNION ALL SELECT * FROM jos_content WHERE state = '1'

Basicly i want something like this:

Code:

SELECT * FROM jos_content WHERE introtext LIKE 'something' AND state = '1' ORDER BY created DESC UNION ALL SELECT * FROM jos_content WHERE state = '1' ORDER BY created DESC

Could any one shed some light on this?

Any help will be much appreciated