как я могу использовать объединение union и в порядке в mysql?
select * from _member_facebook
inner join _member_pts
ON _member_facebook._fb_owner=_member_pts._username
where _member_facebook._promote_point = 9
ORDER BY RAND() limit 2
UNION ALL
select * from _member_facebook
inner join _member_pts
ON _member_facebook._fb_owner=_member_pts._username
where _member_facebook._promote_point = 8 limit 3
выдает ошибку
#1221 - Incorrect usage of UNION and ORDER BY
кто-нибудь может помочь?