Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3162' AND TIME>='2024-12-06 03:11: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='3162' AND TIME>='2024-11-06 07:11: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='2736' AND TIME>='2024-12-06 03:15:52' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3162' AND TIME>='2024-12-06 03:42:32' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3162' AND TIME>='2024-11-06 07:42:32' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2684' AND TIME>='2024-12-06 03:53:06' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2684' AND TIME>='2024-11-06 07:53:06' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2630' AND TIME>='2024-12-06 03:58:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2684' AND TIME>='2024-12-06 04:01:05' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2684' AND TIME>='2024-11-06 08:01:05' ORDER BY TIME DESC LIMIT 1