SELECT a.*, 1 as order1 FROM module_a a WHERE a.menuid = '81' AND a.datatype = 'page' AND a.publish='true' AND a.lang='cht' and a.allowNckuData = 'true' and a.belongid = '127' and a.memberPvge='' AND homeChk='true' AND (homeDate>='2022-08-15' or homeDate='0000-00-00')
UNION ALL
SELECT a2.*, 2 as order1 FROM module_a a2 WHERE a2.menuid = '81' AND a2.datatype = 'page' AND a2.publish='true' AND a2.lang='cht' AND allowNckuData = 'true' AND a2.belongid = 127 AND (a2.homeChk!='true' or (homeChk='true' AND (homeDate<'2022-08-15' AND homeDate!='0000-00-00'))) ORDER BY order1, pubDate desc,odring,id desc