Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' 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-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' 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-02-14 00:03:11' 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>='2024-01-15 04:03:11' 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='352353086156905' AND TIME>='2024-02-14 00:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' AND TIME>='2024-01-15 04:03:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' 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-02-14 00:03:45' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4884' AND TIME>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2619' AND TIME>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2571' AND TIME>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3197' AND TIME>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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-02-14 00:03:45' 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>='2024-01-15 04:03:45' 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-02-14 00:03:46' 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>='2024-01-15 04:03:46' 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-02-14 00:03:46' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' 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-02-14 01:21: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='3078' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-01-15 05:21: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='353173060636303' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' 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-02-14 01:21:31' 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>='2024-01-15 05:21:31' 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='352353086156905' AND TIME>='2024-02-14 01:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' AND TIME>='2024-01-15 05:21:31' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9011' AND TIME>='2024-02-14 03:22: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='2590' AND TIME>='2024-02-14 03:22: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='2725' AND TIME>='2024-02-14 03:22: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='2820' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3072' AND TIME>='2024-02-14 03:22: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='2698' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5080' AND TIME>='2024-02-14 03:22: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='2492' AND TIME>='2024-02-14 03:22: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='2494' AND TIME>='2024-02-14 03:22: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='2597' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2597' AND TIME>='2024-01-15 07:22: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='2654' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2844' AND TIME>='2024-02-14 03:22: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='2846' AND TIME>='2024-02-14 03:22: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='2874' AND TIME>='2024-02-14 03:22: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='2888' AND TIME>='2024-02-14 03:22: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='2913' AND TIME>='2024-02-14 03:22: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='2950' AND TIME>='2024-02-14 03:22: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='2966' AND TIME>='2024-02-14 03:22: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='2720' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3086' AND TIME>='2024-02-14 03:22: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='3099' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3147' AND TIME>='2024-02-14 03:22: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='4959' AND TIME>='2024-02-14 03:22: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='2535' AND TIME>='2024-02-14 03:22: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='3125' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2557' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2557' AND TIME>='2024-01-15 07:22: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='2633' AND TIME>='2024-02-14 03:22: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='5072' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9375' AND TIME>='2024-02-14 03:22: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='353173060488002' AND TIME>='2024-02-14 03:22: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='355234055232561' AND TIME>='2024-02-14 03:22: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='354836080121006' AND TIME>='2024-02-14 03:22: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='358021081941837' AND TIME>='2024-02-14 03:22: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='352353084291100' AND TIME>='2024-02-14 03:22: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='352353084150330' AND TIME>='2024-02-14 03:22: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='352353084149035' AND TIME>='2024-02-14 03:22: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='352353084652467' AND TIME>='2024-02-14 03:22: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='352353085645312' AND TIME>='2024-02-14 03:22: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='352353086184659' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086184659' AND TIME>='2024-01-15 07:22: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='864866053465679' AND TIME>='2024-02-14 03:22: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='862531041050148' AND TIME>='2024-02-14 03:22: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='862531041069957' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041069957' AND TIME>='2024-01-15 07:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041069957' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111445637' AND TIME>='2024-02-14 03:22: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='356078111469876' AND TIME>='2024-02-14 03:22: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='356078116292406' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116292406' AND TIME>='2024-01-15 07:22: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='356078116281466' AND TIME>='2024-02-14 03:22:29' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116281466' AND TIME>='2024-01-15 07:22: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='2511' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' 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-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' 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-02-14 05:13:19' 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>='2024-01-15 09:13:19' 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='352353086156905' AND TIME>='2024-02-14 05:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' AND TIME>='2024-01-15 09:13:19' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' 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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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='2571' AND TIME>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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='3100' AND TIME>='2024-02-14 05:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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='3197' AND TIME>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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-02-14 05:16: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='862531041072803' AND TIME>='2024-01-15 09:16: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-02-14 05:16: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>='2024-01-15 09:16: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-02-14 05:16: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='2511' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' 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-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' 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-02-14 06:05:15' 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>='2024-01-15 10:05:15' 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='352353086156905' AND TIME>='2024-02-14 06:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' AND TIME>='2024-01-15 10:05:15' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9011' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2590' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2725' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3072' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5080' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2492' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2494' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2597' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2706' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2844' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2846' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2874' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2888' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2913' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2950' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2966' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3086' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3147' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4959' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2535' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2557' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2633' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9375' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060488002' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055232561' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080121006' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='358021081941837' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084291100' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084150330' AND TIME>='2024-02-14 06:44:54' 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-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084652467' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085645312' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086184659' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086184659' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='864866053465679' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041050148' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041069957' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041069957' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041069957' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111445637' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111469876' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116292406' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116292406' AND TIME>='2024-01-15 10:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116281466' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116474855' AND TIME>='2024-02-14 06:44:54' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2511' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2592' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3034' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2896' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2905' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2944' 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-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3078' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3112' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5199' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2916' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060636303' 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-02-14 09:42:30' 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>='2024-01-15 13:42:30' 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='352353086156905' AND TIME>='2024-02-14 09:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' AND TIME>='2024-01-15 13:42:30' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086156905' ORDER BY TIME DESC LIMIT 1