Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4962' AND TIME>='2024-07-09 02:04:58' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4962' AND TIME>='2024-07-09 02:11:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-07-09 02:40:07' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-06-09 06:40:07' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-07-09 02:40:17' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-06-09 06:40:17' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-07-09 02:41:02' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-06-09 06:41:02' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-07-09 02:41:48' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-06-09 06:41:48' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-07-09 02:41:48' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-06-09 06:41:48' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-07-09 02:41:49' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-06-09 06:41:49' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-07-09 02:43:50' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' AND TIME>='2024-06-09 06:43:50' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2751' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4966' AND TIME>='2024-07-09 07:18:15' ORDER BY TIME DESC LIMIT 1