1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
select
pid_log,
jobname_log,
dbtimestamp_log,
dbendstamp_log,
timediff(`dbendstamp_log`,`dbtimestamp_log`) AS Duree,
script_log,
args_log,
returncode_log
from
log
where true
AND message_log!='Wrapper End'
AND dbtimestamp_log between '".$date2."' and '".$date1."'
UNION
select
pid_log,
jobname_log,
dbtimestamp_log,
dbendstamp_log,
timediff(`dbendstamp_log`,`dbtimestamp_log`) AS Duree,
script_log,
args_log,
returncode_log
from
log
where true
AND message_log!='Wrapper End'
AND dbtimestamp_log between '".$date3."' and '".$date4."'
order by dbtimestamp_log DESC, returncode_log DESC
; |
Partager