blob: 8e906adb49c79dba4c5c37e66adac3d0f6a6b2dd (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
SELECT dd.*
FROM delivery_dvbt dd, services s
LEFT OUTER JOIN record r
ON r.serviceid = s.serviceid
AND r.recordstatus = 0
LEFT OUTER JOIN events e
ON r.eventid = e.eventid
AND r.serviceid = e.serviceid
AND e.starttime > NOW()
WHERE dd.transportstreamid = s.transportstreamid
ORDER BY e.starttime, s.serviceid
LIMIT 1
|
