Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 6:54:4' AND e.date<='2025-04-16 23:54:4' AND e.DeviceLoginName='4884' 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>='2025-04-15 03:54:04' AND g.time<='2025-04-16 20:54:04' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:1524
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-05 0:24:27' AND e.date<='2025-04-06 23:24:27' AND e.DeviceLoginName='2829' 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>='2025-04-04 21:24:27' AND g.time<='2025-04-06 20:24:27' AND g.DeviceLoginName='2829' GROUP BY  g.time, g.Distance;
CountAzimuth:1173
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 0:45:8' AND e.date<='2025-04-15 23:45:8' AND e.DeviceLoginName='352353084314407' 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>='2025-04-14 21:45:08' AND g.time<='2025-04-15 20:45:08' AND g.DeviceLoginName='352353084314407' GROUP BY  g.time, g.Distance;
CountAzimuth:100
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 9:23:27' AND e.date<='2025-04-16 9:23:27' 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>='2025-04-15 06:23:27' AND g.time<='2025-04-16 06:23:27' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:1770
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 9:26:31' AND e.date<='2025-04-16 9:26:31' AND e.DeviceLoginName='2492' 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>='2025-04-15 06:26:31' AND g.time<='2025-04-16 06:26:31' AND g.DeviceLoginName='2492' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 9:26:31' AND e.date<='2025-04-16 9:26:31' AND e.DeviceLoginName='2492' 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>='2025-03-31 06:26:31' AND g.time<='2025-04-16 06:26:31' AND g.DeviceLoginName='2492' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-16 0:30:48' AND e.date<='2025-04-16 9:30:48' AND e.DeviceLoginName='2553' 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>='2025-04-15 21:30:48' AND g.time<='2025-04-16 06:30:48' AND g.DeviceLoginName='2553' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 0:30:48' AND e.date<='2025-04-16 9:30:48' AND e.DeviceLoginName='2553' 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>='2025-04-14 21:30:48' AND g.time<='2025-04-16 06:30:48' AND g.DeviceLoginName='2553' GROUP BY  g.time, g.Distance;
CountAzimuth:146
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:30:48' AND e.date<='2025-04-16 9:30:48' AND e.DeviceLoginName='2553' 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>='2025-04-13 21:30:48' AND g.time<='2025-04-16 06:30:48' AND g.DeviceLoginName='2553' GROUP BY  g.time, g.Distance;
CountAzimuth:386
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-07 14:12:9' AND e.date<='2025-04-16 14:12:9' AND e.DeviceLoginName='352353085039086' 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>='2025-04-07 11:12:09' AND g.time<='2025-04-16 11:12:09' AND g.DeviceLoginName='352353085039086' GROUP BY  g.time, g.Distance;
CountAzimuth:588
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-16 5:31:5' AND e.date<='2025-04-16 14:31:5' AND e.DeviceLoginName='352353083458635' 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>='2025-04-16 02:31:05' AND g.time<='2025-04-16 11:31:05' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:593
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-07 14:12:9' AND e.date<='2025-04-16 14:12:9' AND e.DeviceLoginName='2736' 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>='2025-04-07 11:12:09' AND g.time<='2025-04-16 11:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:6781
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 14:32:27' AND e.date<='2025-04-16 14:32:27' AND e.DeviceLoginName='354836080167561' 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>='2025-04-15 11:32:27' AND g.time<='2025-04-16 11:32:27' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:863
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 14:32:57' AND e.date<='2025-04-16 14:32:57' AND e.DeviceLoginName='356078116278207' 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>='2025-04-15 11:32:57' AND g.time<='2025-04-16 11:32:57' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:1598
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-27 0:12:9' AND e.date<='2025-03-27 23:12:9' AND e.DeviceLoginName='2736' 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>='2025-03-26 21:12:09' AND g.time<='2025-03-27 20:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:563
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-28 0:12:9' AND e.date<='2025-03-28 23:12:9' AND e.DeviceLoginName='2736' 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>='2025-03-27 21:12:09' AND g.time<='2025-03-28 20:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:468
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-29 0:12:9' AND e.date<='2025-03-30 23:12:9' AND e.DeviceLoginName='2736' 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>='2025-03-28 21:12:09' AND g.time<='2025-03-30 20:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:29
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 0:12:9' AND e.date<='2025-04-01 23:12:9' AND e.DeviceLoginName='2736' 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>='2025-03-30 21:12:09' AND g.time<='2025-04-01 20:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:817
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-02 0:12:9' AND e.date<='2025-04-02 23:12:9' AND e.DeviceLoginName='2736' 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>='2025-04-01 21:12:09' AND g.time<='2025-04-02 20:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:1098
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-03-31 0:12:9' AND e.date<='2025-03-31 23:12:9' AND e.DeviceLoginName='2736' 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>='2025-03-30 21:12:09' AND g.time<='2025-03-31 20:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:427
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-01 0:12:9' AND e.date<='2025-04-01 23:12:9' AND e.DeviceLoginName='2736' 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>='2025-03-31 21:12:09' AND g.time<='2025-04-01 20:12:09' AND g.DeviceLoginName='2736' GROUP BY  g.time, g.Distance;
CountAzimuth:390
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-06 0:40:5' AND e.date<='2025-04-06 23:40:5' AND e.DeviceLoginName='356078111312860' 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>='2025-04-05 21:40:05' AND g.time<='2025-04-06 20:40:05' AND g.DeviceLoginName='356078111312860' GROUP BY  g.time, g.Distance;
CountAzimuth:1693
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-15 16:20:21' AND e.date<='2025-04-16 16:20:21' AND e.DeviceLoginName='4862' 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>='2025-04-15 13:20:21' AND g.time<='2025-04-16 13:20:21' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:2114
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 0:20:21' AND e.date<='2025-04-13 23:20:21' AND e.DeviceLoginName='4862' 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>='2025-04-11 21:20:21' AND g.time<='2025-04-13 20:20:21' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:1
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-14 0:20:21' AND e.date<='2025-04-14 23:20:21' AND e.DeviceLoginName='4862' 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>='2025-04-13 21:20:21' AND g.time<='2025-04-14 20:20:21' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:1901
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-12 2:19:49' AND e.date<='2025-04-12 23:19:49' AND e.DeviceLoginName='3021' 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>='2025-04-11 23:19:49' AND g.time<='2025-04-12 20:19:49' AND g.DeviceLoginName='3021' GROUP BY  g.time, g.Distance;
CountAzimuth:233
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2025-04-13 0:7:37' AND e.date<='2025-04-13 11:21:37' AND e.DeviceLoginName='3021' 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>='2025-04-12 21:07:37' AND g.time<='2025-04-13 08:21:37' AND g.DeviceLoginName='3021' GROUP BY  g.time, g.Distance;
CountAzimuth:362