blob: ba4d7d883cf8d15da5487c37a5fde54ff4f88e83 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
select *
from record r, events e, schedules s
where r.serviceid = e.serviceid
and r.eventid = e.eventid
and /*r.scheduleid*/ 161 = s.scheduleid
and r.recordstatus = 1
and r.recordingstatus = 0
and e.starttime - s.early - interval '3minutes' < now()
order by e.starttime - s.early
;
select *
from schedules
|
