blob: e5fbbf1353882c528b76082140ebea65e564eef8 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
SELECT d.*
FROM allDeliveries d
LEFT OUTER JOIN services s
ON d.transportstreamid = s.transportstreamid
LEFT OUTER JOIN events e
ON s.serviceid = e.serviceid
AND e.starttime > NOW()
LEFT OUTER JOIN record r
ON r.eventuid = e.eventuid
AND r.recordstatus = 'WillRecordThisShowing'
ORDER BY e.starttime, s.serviceid
LIMIT 1
|
