Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4884' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2485' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2619' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2500' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2571' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2876' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2898' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3032' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3057' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3071' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3100' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3172' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3188' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3197' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' 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-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060485131' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2790' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2677' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2677' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060512918' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055170423' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080392292' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080314031' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080357964' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080405763' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084102240' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084149035' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085039615' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085039615' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086157176' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041072803' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041072803' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111471005' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111471005' AND TIME>='2023-12-30 07:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111451585' AND TIME>='2024-01-29 03:44:26' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055763185' AND TIME>='2024-01-29 03:53:50' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055763185' AND TIME>='2023-12-30 07:53:50' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055763185' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5117' AND TIME>='2024-01-29 07:51:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4884' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2485' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2619' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2500' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2453' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2571' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2578' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2564' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2850' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2867' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2876' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2898' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2915' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2939' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3032' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3057' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3071' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3088' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3100' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3165' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3172' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3188' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3197' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2817' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2475' 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-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060485131' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2790' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2677' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2677' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060512918' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055170423' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080392292' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080314031' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080357964' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080405763' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083494887' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084102240' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084149035' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085039615' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086157176' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041072803' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111471005' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111471005' AND TIME>='2023-12-30 12:51:57' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111451585' AND TIME>='2024-01-29 08:51:57' ORDER BY TIME DESC LIMIT 1