Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-03-07 22:00:00' AND g.time<='2024-03-08 06:28:07' AND g.DeviceLoginName='354836080173346'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 04:38:15' AND TIME<='2024-03-08 04:48:15' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 05:30:48' AND TIME<='2024-03-08 05:40:48' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 06:04:58' AND TIME<='2024-03-08 06:14:58' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 06:14:11' AND TIME<='2024-03-08 06:24:11' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='354836080173346' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-07 22:00:00' AND e.date<='2024-03-08 06:28:07'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 04:38:15' AND TIME<='2024-03-08 04:48:15' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 05:30:48' AND TIME<='2024-03-08 05:40:48' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 06:04:58' AND TIME<='2024-03-08 06:14:58' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-03-08 06:14:11' AND TIME<='2024-03-08 06:24:11' AND DeviceLoginName='354836080173346' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='9010' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:85
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='862531041078313' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:459
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='2456' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='2456' GROUP BY  g.time, g.Distance;
CountAzimuth:284
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='4883' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='4883' GROUP BY  g.time, g.Distance;
CountAzimuth:156
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='353173060487970' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:103
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='8993' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='8993' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='2662' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:124
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='3162' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='3162' GROUP BY  g.time, g.Distance;
CountAzimuth:228
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='2623' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='2623' GROUP BY  g.time, g.Distance;
CountAzimuth:86
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='3156' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:189
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-04 23:0:0' AND e.date<='2024-03-05 5:0:0' AND e.DeviceLoginName='3167' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-04 21:00:00' AND g.time<='2024-03-05 03:00:00' AND g.DeviceLoginName='3167' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='4848' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='4848' GROUP BY  g.time, g.Distance;
CountAzimuth:243
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='5131' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='5131' GROUP BY  g.time, g.Distance;
CountAzimuth:99
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='2913' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='2913' GROUP BY  g.time, g.Distance;
CountAzimuth:28
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='9009' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='9009' GROUP BY  g.time, g.Distance;
CountAzimuth:84
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='5080' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='5080' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='353173060487970' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:101
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='2633' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='2633' GROUP BY  g.time, g.Distance;
CountAzimuth:87
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='5117' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:169
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='2470' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:168
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='2846' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='2846' GROUP BY  g.time, g.Distance;
CountAzimuth:103
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='3156' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:293
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='2878' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='2878' GROUP BY  g.time, g.Distance;
CountAzimuth:347
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-05 23:0:0' AND e.date<='2024-03-06 5:0:0' AND e.DeviceLoginName='2809' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-05 21:00:00' AND g.time<='2024-03-06 03:00:00' AND g.DeviceLoginName='2809' GROUP BY  g.time, g.Distance;
CountAzimuth:130
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='353173060485131' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:71
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='4962' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='4962' GROUP BY  g.time, g.Distance;
CountAzimuth:180
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:230
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='356078111301566' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='356078111301566' GROUP BY  g.time, g.Distance;
CountAzimuth:131
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='353173060487970' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:115
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='2470' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:240
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='4868' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='4868' GROUP BY  g.time, g.Distance;
CountAzimuth:75
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='2728' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='2728' GROUP BY  g.time, g.Distance;
CountAzimuth:44
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-06 23:0:0' AND e.date<='2024-03-07 5:0:0' AND e.DeviceLoginName='8983' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-06 21:00:00' AND g.time<='2024-03-07 03:00:00' AND g.DeviceLoginName='8983' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='2652' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='2652' GROUP BY  g.time, g.Distance;
CountAzimuth:290
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='4964' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:228
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='353173066816669' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='353173066816669' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='4849' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:139
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='5078' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:116
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='2974' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='2974' GROUP BY  g.time, g.Distance;
CountAzimuth:3
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='3126' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='3126' GROUP BY  g.time, g.Distance;
CountAzimuth:45
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='352353084234167' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='352353084234167' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='5117' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:143
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='352353086184659' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='352353086184659' GROUP BY  g.time, g.Distance;
CountAzimuth:113
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='3029' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='3029' GROUP BY  g.time, g.Distance;
CountAzimuth:402
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='3179' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:270
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='3061' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:52
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='2556' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:50
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='356078111279820' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY  g.time, g.Distance;
CountAzimuth:146
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='353173060497698' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:170
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='2743' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-07 23:0:0' AND e.date<='2024-03-08 5:0:0' AND e.DeviceLoginName='2610' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 21:00:00' AND g.time<='2024-03-08 03:00:00' AND g.DeviceLoginName='2610' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-08 0:43:54' AND e.date<='2024-03-08 13:43:54' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-07 22:43:54' AND g.time<='2024-03-08 11:43:54' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1067
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-08 4:49:40' AND e.date<='2024-03-08 13:49:40' AND e.DeviceLoginName='2473' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-08 02:49:40' AND g.time<='2024-03-08 11:49:40' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1382
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-08 7:53:43' AND e.date<='2024-03-08 13:53:43' AND e.DeviceLoginName='2473' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-08 05:53:43' AND g.time<='2024-03-08 11:53:43' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:1382
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-08 2:6:18' AND e.date<='2024-03-08 14:6:18' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-08 00:06:18' AND g.time<='2024-03-08 12:06:18' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1067
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-08 6:28:37' AND e.date<='2024-03-08 14:28:37' AND e.DeviceLoginName='352353083458635' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-03-08 04:28:37' AND g.time<='2024-03-08 12:28:37' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1067