Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-05-14 06:34:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-04-14 10:34:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-05-14 06:53:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-04-14 10:53:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-05-14 06:53:56' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-04-14 10:53:56' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-05-14 06:53:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-04-14 10:53:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-05-14 06:54:23' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2949' AND TIME>='2024-04-14 10:54:23' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116299468' AND TIME>='2024-05-14 07:42:39' ORDER BY TIME DESC LIMIT 1