blob: 385462d8afb610e9a270ff03beb59bf42f2bf47e (
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 = 0
ORDER BY e.starttime, s.serviceid
LIMIT 1
|
