Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4884' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4884' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2485' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2619' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2619' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2500' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2571' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2571' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2876' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2898' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' AND TIME>='2024-08-29 08:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' AND TIME>='2024-09-28 04:23:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3032' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3032' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3032' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3057' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3071' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3100' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3172' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3188' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3197' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3162' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060485131' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2790' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2677' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060512918' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060512918' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055170423' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055575019' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080392292' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080314031' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080357964' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080405763' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084102240' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084149035' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085039615' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085039615' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086157176' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041072803' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041072803' AND TIME>='2024-08-29 08:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041072803' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111471005' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111451585' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078118085444' AND TIME>='2024-09-28 04:23:16' ORDER BY TIME DESC LIMIT 1