Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 7:31:24' AND e.date<='2024-03-22 7:31:24' 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-21 05:31:24' AND g.time<='2024-03-22 05:31:24' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 7:31:42' AND e.date<='2024-03-22 7:31:42' 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-21 05:31:42' AND g.time<='2024-03-22 05:31:42' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:384
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 7:46:37' AND e.date<='2024-03-22 7:46:37' AND e.DeviceLoginName='358021081803706' 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-21 05:46:37' AND g.time<='2024-03-22 05:46:37' AND g.DeviceLoginName='358021081803706' GROUP BY  g.time, g.Distance;
CountAzimuth:460
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:37
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:300
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 6:15:41' AND e.date<='2024-03-22 9:15:41' 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-21 04:15:41' AND g.time<='2024-03-22 07:15:41' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:191
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='5078' GROUP BY  g.time, g.Distance;
CountAzimuth:69
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='2966' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='2966' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='2883' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:140
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='3126' GROUP BY  g.time, g.Distance;
CountAzimuth:159
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:114
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='862531041050148' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='2662' GROUP BY  g.time, g.Distance;
CountAzimuth:117
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='4862' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:208
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='2904' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='2904' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 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-18 23:0:0' AND e.date<='2024-03-19 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='5132' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:33
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='2888' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='2888' GROUP BY  g.time, g.Distance;
CountAzimuth:93
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 23:0:0' AND e.date<='2024-03-19 5:0:0' AND e.DeviceLoginName='3187' 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-18 21:00:00' AND g.time<='2024-03-19 03:00:00' AND g.DeviceLoginName='3187' GROUP BY  g.time, g.Distance;
CountAzimuth:201
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='4962' GROUP BY  g.time, g.Distance;
CountAzimuth:146
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='3123' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='3123' GROUP BY  g.time, g.Distance;
CountAzimuth:116
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:334
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:235
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='2913' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='862531041079980' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='862531041079980' GROUP BY  g.time, g.Distance;
CountAzimuth:72
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='2883' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:191
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='3045' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='5082' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='5082' GROUP BY  g.time, g.Distance;
CountAzimuth:52
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY  g.time, g.Distance;
CountAzimuth:98
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='3188' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='3188' GROUP BY  g.time, g.Distance;
CountAzimuth:36
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='3030' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:159
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='2574' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='2574' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='4862' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:202
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:25
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:2
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='2630' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='2630' GROUP BY  g.time, g.Distance;
CountAzimuth:90
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 5:0:0' AND e.DeviceLoginName='2997' 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='2997' GROUP BY  g.time, g.Distance;
CountAzimuth:176
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-19 23:0:0' AND e.date<='2024-03-20 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-19 21:00:00' AND g.time<='2024-03-20 03:00:00' AND g.DeviceLoginName='2878' GROUP BY  g.time, g.Distance;
CountAzimuth:300
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 0:26:46' AND e.date<='2024-03-22 9:26:46' AND e.DeviceLoginName='2833' 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-17 22:26:46' AND g.time<='2024-03-22 07:26:46' AND g.DeviceLoginName='2833' GROUP BY  g.time, g.Distance;
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='8997' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:182
CountAzimuth:12710
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='4964' GROUP BY  g.time, g.Distance;
CountAzimuth:238
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='3045' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:40
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='353173060512918' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='353173060512918' GROUP BY  g.time, g.Distance;
CountAzimuth:69
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='4883' GROUP BY  g.time, g.Distance;
CountAzimuth:216
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:230
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:769
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='2866' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:307
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='4862' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:227
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='3179' GROUP BY  g.time, g.Distance;
CountAzimuth:17
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:88
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='356078111326001' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='356078111326001' GROUP BY  g.time, g.Distance;
CountAzimuth:89
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='5132' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='5132' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='2927' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='2927' GROUP BY  g.time, g.Distance;
CountAzimuth:289
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='2627' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='2627' GROUP BY  g.time, g.Distance;
CountAzimuth:110
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='2584' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='2584' GROUP BY  g.time, g.Distance;
CountAzimuth:14
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 23:0:0' AND e.date<='2024-03-21 5:0:0' AND e.DeviceLoginName='3172' 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-20 21:00:00' AND g.time<='2024-03-21 03:00:00' AND g.DeviceLoginName='3172' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY  g.time, g.Distance;
CountAzimuth:38
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='2554' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='2554' GROUP BY  g.time, g.Distance;
CountAzimuth:21
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='3154' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='3154' GROUP BY  g.time, g.Distance;
CountAzimuth:399
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='3025' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='3025' GROUP BY  g.time, g.Distance;
CountAzimuth:125
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='2790' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='2790' GROUP BY  g.time, g.Distance;
CountAzimuth:78
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='4966' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:139
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='4869' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='4869' GROUP BY  g.time, g.Distance;
CountAzimuth:47
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='352353086184659' GROUP BY  g.time, g.Distance;
CountAzimuth:96
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='4868' GROUP BY  g.time, g.Distance;
CountAzimuth:141
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='2846' GROUP BY  g.time, g.Distance;
CountAzimuth:98
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='2743' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='3105' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='3105' GROUP BY  g.time, g.Distance;
CountAzimuth:41
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='2948' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='2948' GROUP BY  g.time, g.Distance;
CountAzimuth:16
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='356078111326001' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='356078111326001' GROUP BY  g.time, g.Distance;
CountAzimuth:87
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 23:0:0' AND e.date<='2024-03-22 5:0:0' AND e.DeviceLoginName='3100' 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-21 21:00:00' AND g.time<='2024-03-22 03:00:00' AND g.DeviceLoginName='3100' GROUP BY  g.time, g.Distance;
CountAzimuth:78
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 0:7:50' AND e.date<='2024-03-22 11:7:50' 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-20 22:07:50' AND g.time<='2024-03-22 09:07:50' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-22 3:8:4' AND e.date<='2024-03-22 11:8:4' 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-22 01:08:04' AND g.time<='2024-03-22 09:08:04' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-22 0:8:25' AND e.date<='2024-03-22 11:8:25' AND e.DeviceLoginName='3056' 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-21 22:08:25' AND g.time<='2024-03-22 09:08:25' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:236
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-21 5:59:12' AND e.date<='2024-03-21 23:59:12' AND e.DeviceLoginName='2849' 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-21 03:59:12' AND g.time<='2024-03-21 21:59:12' AND g.DeviceLoginName='2849' GROUP BY  g.time, g.Distance;
CountAzimuth:1725
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-22 5:59:12' AND e.date<='2024-03-22 23:59:12' AND e.DeviceLoginName='2849' 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-22 03:59:12' AND g.time<='2024-03-22 21:59:12' AND g.DeviceLoginName='2849' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-22 5:59:12' AND e.date<='2024-03-22 23:59:12' AND e.DeviceLoginName='2849' 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-22 03:59:12' AND g.time<='2024-03-22 21:59:12' AND g.DeviceLoginName='2849' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-20 5:2:22' AND e.date<='2024-03-20 23:2:22' AND e.DeviceLoginName='2849' 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-20 03:02:22' AND g.time<='2024-03-20 21:02:22' AND g.DeviceLoginName='2849' GROUP BY  g.time, g.Distance;
CountAzimuth:367
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-18 5:2:22' AND e.date<='2024-03-18 23:2:22' AND e.DeviceLoginName='2849' 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-18 03:02:22' AND g.time<='2024-03-18 21:02:22' AND g.DeviceLoginName='2849' GROUP BY  g.time, g.Distance;
CountAzimuth:89