62,614
社区成员
发帖
与我相关
我的任务
分享
SELECT NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG
from
(
(select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from
(
select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from NOTICE where NOTICE_ORDER is not null AND NOTICE_ORDER<>''
order by NOTICE_ORDER, NOTICE_ID desc) as a
)
union all
(select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from
(
select NOTICE_ID,NOTICE_TITLE_EN,NOTICE_ORDER,CREATE_TIME,CREATE_USER_ID,FLAG from NOTICE where NOTICE_ORDER is null OR NOTICE_ORDER=''
order by NOTICE_ID desc ) as b
)
) as c
LIMIT 0,10