Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2454' AND TIME>='2024-08-19 06:24:36'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2454' AND TIME>='2024-07-20 10:24:36'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2454'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2454' AND TIME>='2024-08-19 07:19:47'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2454' AND TIME>='2024-07-20 11:19:47'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2454'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080105512' AND TIME>='2024-08-19 07:35:51'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080105512' AND TIME>='2024-07-20 11:35:51'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2881' AND TIME>='2024-08-19 07:36:09'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2881' AND TIME>='2024-07-20 11:36:09'  ORDER BY TIME DESC LIMIT 1
Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2881'  ORDER BY TIME DESC LIMIT 1