Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-26 0:8:11' AND e.date<='2024-04-26 23:8:11' AND e.DeviceLoginName='352353084656807' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-25 21:08:11' AND g.time<='2024-04-26 20:08:11' AND g.DeviceLoginName='352353084656807' GROUP BY  g.time, g.Distance;
CountAzimuth:2404
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-29 0:0:44' AND e.date<='2024-04-29 23:59:44' AND e.DeviceLoginName='3082' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-28 21:00:44' AND g.time<='2024-04-29 20:59:44' AND g.DeviceLoginName='3082' GROUP BY  g.time, g.Distance;
CountAzimuth:1213
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-30 0:0:4' AND e.date<='2024-04-30 23:59:4' AND e.DeviceLoginName='3082' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-29 21:00:04' AND g.time<='2024-04-30 20:59:04' AND g.DeviceLoginName='3082' GROUP BY  g.time, g.Distance;
CountAzimuth:1714
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-01 0:0:4' AND e.date<='2024-05-01 23:59:4' AND e.DeviceLoginName='3082' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-30 21:00:04' AND g.time<='2024-05-01 20:59:04' AND g.DeviceLoginName='3082' GROUP BY  g.time, g.Distance;
CountAzimuth:2172
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-29 0:0:4' AND e.date<='2024-04-29 23:59:4' AND e.DeviceLoginName='356078116301603' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-28 21:00:04' AND g.time<='2024-04-29 20:59:04' AND g.DeviceLoginName='356078116301603' GROUP BY  g.time, g.Distance;
CountAzimuth:332
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-30 0:0:4' AND e.date<='2024-04-30 23:59:4' AND e.DeviceLoginName='356078116301603' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-29 21:00:04' AND g.time<='2024-04-30 20:59:04' AND g.DeviceLoginName='356078116301603' GROUP BY  g.time, g.Distance;
CountAzimuth:1095
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-01 0:0:4' AND e.date<='2024-05-01 23:59:4' AND e.DeviceLoginName='356078116301603' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-30 21:00:04' AND g.time<='2024-05-01 20:59:04' AND g.DeviceLoginName='356078116301603' GROUP BY  g.time, g.Distance;
CountAzimuth:1614
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-27 0:24:22' AND e.date<='2024-04-28 23:24:22' AND e.DeviceLoginName='2773' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-26 21:24:22' AND g.time<='2024-04-28 20:24:22' AND g.DeviceLoginName='2773' GROUP BY  g.time, g.Distance;
CountAzimuth:1824
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-27 0:24:22' AND e.date<='2024-04-28 23:24:22' AND e.DeviceLoginName='2676' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-26 21:24:22' AND g.time<='2024-04-28 20:24:22' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:2553
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-20 0:24:22' AND e.date<='2024-04-21 23:24:22' AND e.DeviceLoginName='2676' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-19 21:24:22' AND g.time<='2024-04-21 20:24:22' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:1130
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 0:24:22' AND e.date<='2024-04-14 23:24:22' AND e.DeviceLoginName='2676' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-12 21:24:22' AND g.time<='2024-04-14 20:24:22' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:1063
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:24:22' AND e.date<='2024-04-07 23:24:22' AND e.DeviceLoginName='2676' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 21:24:22' AND g.time<='2024-04-07 20:24:22' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:1226
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:24:22' AND e.date<='2024-04-07 23:24:22' AND e.DeviceLoginName='8997' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 21:24:22' AND g.time<='2024-04-07 20:24:22' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:2286
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 0:24:22' AND e.date<='2024-04-14 23:24:22' AND e.DeviceLoginName='8997' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-12 21:24:22' AND g.time<='2024-04-14 20:24:22' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:3461
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-20 0:24:22' AND e.date<='2024-04-21 23:24:22' AND e.DeviceLoginName='8997' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-19 21:24:22' AND g.time<='2024-04-21 20:24:22' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:3293
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-27 0:24:22' AND e.date<='2024-04-28 23:24:22' AND e.DeviceLoginName='8997' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-26 21:24:22' AND g.time<='2024-04-28 20:24:22' AND g.DeviceLoginName='8997' GROUP BY  g.time, g.Distance;
CountAzimuth:5009
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-27 0:24:22' AND e.date<='2024-04-28 23:24:22' AND e.DeviceLoginName='353173060497698' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-26 21:24:22' AND g.time<='2024-04-28 20:24:22' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:525
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-20 0:24:22' AND e.date<='2024-04-21 23:24:22' AND e.DeviceLoginName='353173060497698' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-19 21:24:22' AND g.time<='2024-04-21 20:24:22' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:420
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 0:24:22' AND e.date<='2024-04-14 23:24:22' AND e.DeviceLoginName='353173060497698' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-12 21:24:22' AND g.time<='2024-04-14 20:24:22' AND g.DeviceLoginName='353173060497698' GROUP BY  g.time, g.Distance;
CountAzimuth:724
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-13 0:24:22' AND e.date<='2024-04-14 23:24:22' AND e.DeviceLoginName='356078118085311' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-12 21:24:22' AND g.time<='2024-04-14 20:24:22' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-20 0:24:22' AND e.date<='2024-04-21 23:24:22' AND e.DeviceLoginName='356078118085311' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-19 21:24:22' AND g.time<='2024-04-21 20:24:22' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:2649
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-27 0:24:22' AND e.date<='2024-04-28 23:24:22' AND e.DeviceLoginName='356078118085311' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-26 21:24:22' AND g.time<='2024-04-28 20:24:22' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:3418
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-02 7:39:30' AND e.date<='2024-05-02 15:39:30' AND e.DeviceLoginName='2473' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-05-02 04:39:30' AND g.time<='2024-05-02 12:39:30' AND g.DeviceLoginName='2473' GROUP BY  g.time, g.Distance;
CountAzimuth:678
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 10:19:31' AND e.date<='2024-04-06 10:8:31' AND e.DeviceLoginName='2500' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-06 07:19:31' AND g.time<='2024-04-06 07:08:31' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 10:19:31' AND e.date<='2024-04-06 10:8:31' AND e.DeviceLoginName='2500' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-06 07:19:31' AND g.time<='2024-04-06 07:08:31' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-12 23:0:0' AND e.date<='2024-04-13 5:0:0' AND e.DeviceLoginName='3079' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-12 20:00:00' AND g.time<='2024-04-13 02:00:00' AND g.DeviceLoginName='3079' GROUP BY  g.time, g.Distance;
CountAzimuth:134
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 8:19:31' AND e.date<='2024-04-06 15:8:31' AND e.DeviceLoginName='2500' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-06 05:19:31' AND g.time<='2024-04-06 12:08:31' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:18
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-18 13:19:31' AND e.date<='2024-04-18 13:43:31' AND e.DeviceLoginName='2500' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-18 10:19:31' AND g.time<='2024-04-18 10:43:31' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:51