Unknown column 'emarket' in 'field list'
select titleorl,groupid,classid,newspath,emarket,filename,id,titlepic,title,newstime from ***_ecms_iad where groupid <= 0 and FROM_UNIXTIME(newstime,'%Y-%m-%d') <= '2023-08-31' and FROM_UNIXTIME(newstime,'%Y-%m-%d') >= '2023-08-01' and isgood=1 union select titleorl,groupid,classid,newspath,emarket,filename,id,titlepic,title,newstime from ***_ecms_videos where groupid <= 0 and FROM_UNIXTIME(newstime,'%Y-%m-%d') <= '2023-08-31' and FROM_UNIXTIME(newstime,'%Y-%m-%d') >= '2023-08-01' and isgood=1 order by newstime asc limit 100