Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8994' AND TIME>='2024-11-25 03:23:47' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8994' AND TIME>='2024-10-26 08:23:47' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8994' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8994' AND TIME>='2024-11-25 03:24:37' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8994' AND TIME>='2024-10-26 08:24:37' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8994' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2574' AND TIME>='2024-11-25 04:53:59' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2574' AND TIME>='2024-10-26 09:53:59' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2574' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2574' AND TIME>='2024-11-25 05:47:00' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2574' AND TIME>='2024-10-26 10:47:00' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2574' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2974' AND TIME>='2024-11-25 05:48: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='352353083500956' AND TIME>='2024-11-25 07:41: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='352353083500956' AND TIME>='2024-11-25 07:45:53' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2783' AND TIME>='2024-11-25 08:05:32' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3084' AND TIME>='2024-11-25 09:39:42' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3084' AND TIME>='2024-10-26 14:39:42' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2621' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2621' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2621' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2697' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2697' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2697' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2814' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2814' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2814' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2840' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2840' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2840' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3065' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3065' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3065' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3186' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3186' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3186' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4961' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4961' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4961' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9389' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9389' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9389' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2875' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2861' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4846' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3212' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='5130' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3021' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2754' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4630' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2543' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2565' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2829' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086150866' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086150866' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086150866' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173066816669' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3038' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='355234055234161' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353086130694' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3158' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='864866053467873' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='864866053465430' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084159372' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='358021081796827' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2830' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078116286200' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8989' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3041' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084146916' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084146916' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2563' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2563' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2563' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9018' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9018' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2886' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2886' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2886' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084187837' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9006' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9006' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173066828375' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173066828375' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173066828375' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3084' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3084' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9004' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='353173066836337' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4883' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4827' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4869' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9005' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9005' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083433844' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083433844' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3087' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3087' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3087' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2958' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111472417' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041078289' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2615' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2615' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2882' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084138319' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9012' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9000' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2724' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2724' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083507225' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8998' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='8998' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2890' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2890' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2849' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2849' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3024' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078118052857' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2768' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2623' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083474111' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2599' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3026' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3026' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3139' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2899' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2899' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2899' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2595' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='862531041064321' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085652573' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085652573' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085652573' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3070' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085648530' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2718' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084197539' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2735' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084314431' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2667' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2638' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2638' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2638' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353084176731' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2726' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2534' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2580' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='356078111282576' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2594' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2594' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2624' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2624' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2997' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2526' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3027' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083504503' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083504503' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2533' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2602' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2755' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2781' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3110' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2809' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353085033170' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='352353083463817' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3048' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3048' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3048' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3036' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2573' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2573' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2573' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='9002' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2797' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2797' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3046' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='3046' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='4968' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixed; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2705' AND TIME>='2024-11-25 09:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedWeek; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2705' AND TIME>='2024-10-26 14:50:28' ORDER BY TIME DESC LIMIT 1 Method:GetLastCoordFixedAll; Query:SELECT ADDTIME(time,'0 2:0:0'),latitude,longitude FROM tms_gpsdata_fixed WHERE DeviceLoginName='2705' ORDER BY TIME DESC LIMIT 1