无法在全局顺序子句中使用mysql错误表

(SELECT dtable.* FROM app_detailsvvv as dtable INNER JOIN new_apps ON 
new_apps.trackId=dtable.trackId WHERE primaryGenreName='Games' AND composed='1' AND
new_apps.top>0) UNION (SELECT * FROM app_detailsvvv as dtable WHERE
primaryGenreName='Games') ORDER BY new_apps.top ASC, trackName ASC LIMIT 12
(SELECT dtable.* FROM app_detailsvvv as dtable