1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| SELECT SQL_NO_CACHE
evt.ID
, evt.VEHICLE_ID
, evt.DRIVER_ID
, evt.EVENT_TYPE_ID
, evt.CREATED_AT
, evt.MESSAGE
, evt.RECEIVED
, evt.LONGITUDE
, evt.QUADRANT_LONG
, evt.LATITUDE
, evt.QUADRANT_LAT
, evt.HEADING
, evt.SPEED
, evt.LOCATION_NAME
, evt.VALIDITY
FROM avl_event AS evt
WHERE EXISTS
( SELECT 1
FROM avl_event AS tmp
WHERE tmp.CREATED_AT >= '2010-01-05 05:00:00'
AND tmp.CREATED_AT <= '2010-01-06 04:59:00'
AND tmp.EVENT_TYPE_ID = evt.EVENT_TYPE_ID
AND tmp.VEHICLE_ID = evt.VEHICLE_ID
GROUP BY tmp.VEHICLE_ID
HAVING MIN(tmp.CREATED_AT) = evt.CREATED_AT
)
AND evt.EVENT_TYPE_ID = 2
ORDER BY evt.CREATED_AT ASC
; |
Partager