select trigger.id,trigger.target,trigger.event_def as def,to_char(trigger.add_time,'YYYY-MM-DD') as add,to_char(trigger.run_time,'MM-DD') as run,to_char(trigger.start_time,'MM-DD') as start,to_char(trigger.update_time,'MM-DD') as update,trigger.update_process as process,trigger.state,to_char(notice.create_time,'MM-DD HH:MI') as noticetime, REPLACE(LEFT(notice.data,26), E'\n','') AS noticetxt from action_trigger.event as trigger LEFT OUTER JOIN action_trigger.event_output AS notice ON trigger.template_output = notice.id where trigger.event_def in ('5') AND trigger.update_time::DATE BETWEEN '2014-12-26' AND '2014-12-31' AND trigger.state <> 'invalid' order by trigger.run_time;