union all拼接排序后的结果集

遇到一个问题: union all拼接排序后的结果集时会出现最后拼接的结果集排序不起作用

        select * from ( select *, '1' as type from (
select * from wp_project where project_type = '大型项目'
union all
select * from wp_project where 1=0
) likeProject
union all
select *, '2' as type from wp_project where project_type not in ('大型项目')

) project order by type, publish_time DESC

备注: 需要union all的结果集查询时增加一个冗余字段(例如上面的type)，按冗余字段和时间排序