SQL: Quickly getting the value of column B wherever column A is minimum
Use:
SELECT x.objuid, y.time, y.frame, z.time, z.frame FROM (SELECT m.objuid, MIN(m.time) AS min_time, MAX(m.time) AS max_time FROM MOTION m GROUP BY m.objuid) x JOIN MOTION y ON y.objuid = x.objuid AND y.time = x.min_time JOIN MOTION z ON z.objuid = x.objuid AND z.time = x.max_time