Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8984' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9011' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2574' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2590' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2725' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2820' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3072' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2698' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3163' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5080' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2492' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2492' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2494' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2597' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2654' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2701' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2706' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2727' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2757' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2807' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2844' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2846' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2874' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2888' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2913' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2950' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2966' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2720' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3086' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3086' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3086' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' AND TIME>='2024-05-29 21:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' AND TIME>='2024-04-30 01:57:34' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3099' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' AND TIME>='2024-04-30 01:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3141' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3147' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4959' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2535' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' AND TIME>='2024-04-30 01:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3125' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2557' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2633' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' AND TIME>='2024-04-30 01:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5072' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9375' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173060488002' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055232561' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055232561' AND TIME>='2024-04-30 01:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='354836080121006' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='358021081941837' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084291100' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084150330' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084149035' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084652467' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085645312' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086184659' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='864866053465679' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041050148' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041069957' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111445637' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111469876' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116292406' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116281466' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116474855' AND TIME>='2024-05-29 21:57:35' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:09:36' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:09:36' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:11:00' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:11:00' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:13:38' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:13:38' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:13:39' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:13:39' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:19:09' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:19:09' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:19:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:19:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:19:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:19:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:19:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:19:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 02:19:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 06:19:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 05:07:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 09:07:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 05:07:48' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 09:07:48' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 05:07:49' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 09:07:49' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 05:07:50' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 09:07:50' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 05:09:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 09:09:10' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 05:09:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 09:09:11' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 06:13:36' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 10:13:36' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 06:13:36' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 10:13:36' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 06:13:37' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 10:13:37' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 06:13:38' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 10:13:38' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 06:13:41' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 10:13:41' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 06:13:51' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 10:13:51' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 06:13:52' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 10:13:52' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 07:26:39' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 11:26:39' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 07:26:42' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 11:26:42' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-05-30 07:28:51' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 3:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2506' AND TIME>='2024-04-30 11:28:51' ORDER BY TIME DESC LIMIT 1