SELECT
  otimibus_gps.positions.id,
  otimibus_gps.positions.deviceid,
  otimibus_gps.positions.devicetime,
  otimibus_gps.positions.latitude,
  otimibus_gps.positions.longitude
FROM
  otimibus_gps.positions
WHERE deviceid in ('1','2')
GROUP BY deviceid
ORDER BY devicetime DESC