Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 8:24:57' AND e.date<='2024-06-20 8:24:57' AND e.DeviceLoginName='2883' 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-06-01 05:24:57' AND g.time<='2024-06-20 05:24:57' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:13612
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:30:47' AND e.date<='2024-06-16 23:30:47' AND e.DeviceLoginName='2876' 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-06-14 21:30:47' AND g.time<='2024-06-16 20:30:47' AND g.DeviceLoginName='2876' GROUP BY  g.time, g.Distance;
CountAzimuth:1310
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:53:46' AND e.date<='2024-06-10 23:53:46' AND e.DeviceLoginName='352353085652458' 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-06-09 21:53:46' AND g.time<='2024-06-10 20:53:46' AND g.DeviceLoginName='352353085652458' GROUP BY  g.time, g.Distance;
CountAzimuth:469
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 0:53:46' AND e.date<='2024-06-11 23:53:46' AND e.DeviceLoginName='352353085652458' 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-06-10 21:53:46' AND g.time<='2024-06-11 20:53:46' AND g.DeviceLoginName='352353085652458' GROUP BY  g.time, g.Distance;
CountAzimuth:503
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:30:47' AND e.date<='2024-06-16 23:30:47' AND e.DeviceLoginName='356078111451585' 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-06-14 21:30:47' AND g.time<='2024-06-16 20:30:47' AND g.DeviceLoginName='356078111451585' GROUP BY  g.time, g.Distance;
CountAzimuth:687
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:30:47' AND e.date<='2024-06-14 23:30:47' AND e.DeviceLoginName='356078111451585' 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-06-09 21:30:47' AND g.time<='2024-06-14 20:30:47' AND g.DeviceLoginName='356078111451585' GROUP BY  g.time, g.Distance;
CountAzimuth:3646
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:30:47' AND e.date<='2024-06-14 23:30:47' AND e.DeviceLoginName='352353085652458' 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-06-09 21:30:47' AND g.time<='2024-06-14 20:30:47' AND g.DeviceLoginName='352353085652458' GROUP BY  g.time, g.Distance;
CountAzimuth:2482
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:30:47' AND e.date<='2024-06-14 23:30:47' AND e.DeviceLoginName='2504' 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-06-09 21:30:47' AND g.time<='2024-06-14 20:30:47' AND g.DeviceLoginName='2504' GROUP BY  g.time, g.Distance;
CountAzimuth:5171
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:30:47' AND e.date<='2024-06-20 23:30:47' AND e.DeviceLoginName='2504' 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-06-16 21:30:47' AND g.time<='2024-06-20 20:30:47' AND g.DeviceLoginName='2504' GROUP BY  g.time, g.Distance;
CountAzimuth:9090
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:30:47' AND e.date<='2024-06-20 23:30:47' AND e.DeviceLoginName='356078111451585' 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-06-16 21:30:47' AND g.time<='2024-06-20 20:30:47' AND g.DeviceLoginName='356078111451585' GROUP BY  g.time, g.Distance;
CountAzimuth:4095
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:30:47' AND e.date<='2024-06-20 23:30:47' AND e.DeviceLoginName='9022' 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-06-16 21:30:47' AND g.time<='2024-06-20 20:30:47' AND g.DeviceLoginName='9022' GROUP BY  g.time, g.Distance;
CountAzimuth:9697
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-18 0:39:32' AND e.date<='2024-06-18 23:39:32' AND e.DeviceLoginName='352353083473741' 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-06-17 21:39:32' AND g.time<='2024-06-18 20:39:32' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:3223
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 0:39:32' AND e.date<='2024-06-19 23:39:32' AND e.DeviceLoginName='352353083473741' 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-06-18 21:39:32' AND g.time<='2024-06-19 20:39:32' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:5301
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-20 1:30:21' AND e.date<='2024-06-20 12:30:21' 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>='2024-06-19 22:30:21' AND g.time<='2024-06-20 09:30:21' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:428
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 0:39:32' AND e.date<='2024-06-19 23:39:32' AND e.DeviceLoginName='352353083473741' 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-06-18 21:39:32' AND g.time<='2024-06-19 20:39:32' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:5301
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-20 3:36:44' AND e.date<='2024-06-20 12:36:44' 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>='2024-06-20 00:36:44' AND g.time<='2024-06-20 09:36:44' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:428
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 12:37:25' AND e.date<='2024-06-19 23:37:25' AND e.DeviceLoginName='2556' 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-06-19 09:37:25' AND g.time<='2024-06-19 20:37:25' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:107
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-19 12:37:42' AND e.date<='2024-06-19 23:37:42' 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>='2024-06-19 09:37:42' AND g.time<='2024-06-19 20:37:42' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:972
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-20 0:38:24' AND e.date<='2024-06-20 12:38:24' 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>='2024-06-19 21:38:24' AND g.time<='2024-06-20 09:38:24' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:377
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-20 1:39:28' AND e.date<='2024-06-20 12:39:28' AND e.DeviceLoginName='2556' 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-06-19 22:39:28' AND g.time<='2024-06-20 09:39:28' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:85
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-20 10:49:1' AND e.date<='2024-06-20 12:49:1' 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>='2024-06-20 07:49:01' AND g.time<='2024-06-20 09:49:01' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:173
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:12:25' AND e.date<='2024-06-16 23:12:25' AND e.DeviceLoginName='3168' 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-06-14 21:12:25' AND g.time<='2024-06-16 20:12:25' AND g.DeviceLoginName='3168' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-08 0:12:25' AND e.date<='2024-06-09 23:12:25' AND e.DeviceLoginName='3168' 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-06-07 21:12:25' AND g.time<='2024-06-09 20:12:25' AND g.DeviceLoginName='3168' GROUP BY  g.time, g.Distance;
CountAzimuth:2710
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:42:10' AND e.date<='2024-06-16 23:42:10' 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-06-14 21:42:10' AND g.time<='2024-06-16 20:42:10' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:3033
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:42:10' AND e.date<='2024-06-15 23:42:10' 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-06-14 21:42:10' AND g.time<='2024-06-15 20:42:10' AND g.DeviceLoginName='356078118085311' GROUP BY  g.time, g.Distance;
CountAzimuth:1565
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-17 0:12:25' AND e.date<='2024-06-20 23:12:25' AND e.DeviceLoginName='2647' 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-06-16 21:12:25' AND g.time<='2024-06-20 20:12:25' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:3642
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-10 0:46:59' AND e.date<='2024-06-10 23:46:59' AND e.DeviceLoginName='2647' 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-06-09 21:46:59' AND g.time<='2024-06-10 20:46:59' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:1617
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-11 0:46:59' AND e.date<='2024-06-11 23:46:59' AND e.DeviceLoginName='2647' 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-06-10 21:46:59' AND g.time<='2024-06-11 20:46:59' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:1221
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-12 0:46:59' AND e.date<='2024-06-12 23:46:59' AND e.DeviceLoginName='2647' 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-06-11 21:46:59' AND g.time<='2024-06-12 20:46:59' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:759
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-13 0:46:59' AND e.date<='2024-06-13 23:46:59' AND e.DeviceLoginName='2647' 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-06-12 21:46:59' AND g.time<='2024-06-13 20:46:59' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:986
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-14 0:46:59' AND e.date<='2024-06-14 23:46:59' AND e.DeviceLoginName='2647' 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-06-13 21:46:59' AND g.time<='2024-06-14 20:46:59' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:432
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-15 0:46:59' AND e.date<='2024-06-16 23:46:59' AND e.DeviceLoginName='2647' 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-06-14 21:46:59' AND g.time<='2024-06-16 20:46:59' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:0