Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3071' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' AND TIME>='2024-02-09 09:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' AND TIME>='2024-01-10 13:37:04' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' ORDER BY TIME DESC LIMIT 1