blob: 1bf20537e3f730514652936cdb3109c54b27210f (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
SELECT dd.*
FROM delivery_dvbt dd, services s
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 = 0
WHERE dd.transportstreamid = s.transportstreamid
ORDER BY e.starttime, s.serviceid
LIMIT 1
|
