select
date_format(now(),'%Y-%m-%d %H:%i:%s'),
date_format(concat(operateDate," ",operateTime),'%Y-%m-%d %H:%i:%s')
from schedule sch , schedule_operate sch_oper
where date_format(now(),'%Y-%m-%d %H:%i:%s') <= date_format(concat(case when operateDate is null then date_format(now(),'%Y-%m-%d') else operateDate end," ",operateTime),'%Y-%m-%d %H:%i:%s') order by operateTime asc