[thelist] can / should this be done in SQL?

[Joel D Canfield]

> select * from (
> SELECT * FROM news WHERE category = 1 LIMIT 4
> UNION
> SELECT * FROM news WHERE category = 2 LIMIT 3
> UNION
> SELECT * FROM news WHERE category = 6 LIMIT 3
> UNION
> SELECT * FROM news WHERE category = 3 LIMIT 2
> ) order by date desc

doesn't that just sort the results, returning whichever records happen
to come first in each category?

joel