i wanted to use this:
(select * from Seasons where id=5) union
(select * from Seasons where id<>5 order by id desc);
but i had to use this:
SELECT * FROM
(SELECT * FROM Seasons
WHERE id=5
ORDER BY id DESC) AS t1
UNION
SELECT * FROM
(SELECT * FROM Seasons
WHERE id<>5
ORDER BY id desc) AS t2