Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 9:1:26' AND e.date<='2024-07-12 9:1:26' AND e.DeviceLoginName='862531041054447' 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-07-11 06:01:26' AND g.time<='2024-07-12 06:01:26' AND g.DeviceLoginName='862531041054447' GROUP BY  g.time, g.Distance;
CountAzimuth:1091
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 0:1:26' AND e.date<='2024-07-12 9:1:26' AND e.DeviceLoginName='862531041054447' 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-07-11 21:01:26' AND g.time<='2024-07-12 06:01:26' AND g.DeviceLoginName='862531041054447' GROUP BY  g.time, g.Distance;
CountAzimuth:307
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 0:1:26' AND e.date<='2024-07-08 12:1:26' AND e.DeviceLoginName='862531041054447' 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-07-07 21:01:26' AND g.time<='2024-07-08 09:01:26' AND g.DeviceLoginName='862531041054447' GROUP BY  g.time, g.Distance;
CountAzimuth:570
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 0:1:26' AND e.date<='2024-07-01 12:1:26' AND e.DeviceLoginName='862531041054447' 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-30 21:01:26' AND g.time<='2024-07-01 09:01:26' AND g.DeviceLoginName='862531041054447' GROUP BY  g.time, g.Distance;
CountAzimuth:480
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-01 9:20:50' AND e.date<='2024-07-12 9:20:50' AND e.DeviceLoginName='9014' 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-07-01 06:20:50' AND g.time<='2024-07-12 06:20:50' AND g.DeviceLoginName='9014' GROUP BY  g.time, g.Distance;
CountAzimuth:12696
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-16 0:35:3' AND e.date<='2024-06-16 23:35:3' AND e.DeviceLoginName='9018' 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-15 21:35:03' AND g.time<='2024-06-16 20:35:03' AND g.DeviceLoginName='9018' GROUP BY  g.time, g.Distance;
CountAzimuth:3424
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-09 0:35:3' AND e.date<='2024-06-09 23:35:3' AND e.DeviceLoginName='9018' 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-08 21:35:03' AND g.time<='2024-06-09 20:35:03' AND g.DeviceLoginName='9018' GROUP BY  g.time, g.Distance;
CountAzimuth:3891
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-06 0:8:47' AND e.date<='2024-07-07 23:8:47' AND e.DeviceLoginName='3057' 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-07-05 21:08:47' AND g.time<='2024-07-07 20:08:47' AND g.DeviceLoginName='3057' GROUP BY  g.time, g.Distance;
CountAzimuth:1453
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-06 0:8:47' AND e.date<='2024-07-07 23:8:47' AND e.DeviceLoginName='3197' 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-07-05 21:08:47' AND g.time<='2024-07-07 20:08:47' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:365
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 0:8:47' AND e.date<='2024-07-12 23:8:47' AND e.DeviceLoginName='3197' 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-07-11 21:08:47' AND g.time<='2024-07-12 20:08:47' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:312
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 0:8:47' AND e.date<='2024-07-11 23:8:47' AND e.DeviceLoginName='3197' 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-07-10 21:08:47' AND g.time<='2024-07-11 20:08:47' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:1146
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 0:49:15' AND e.date<='2024-07-08 23:49:15' 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-07-07 21:49:15' AND g.time<='2024-07-08 20:49:15' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:1292
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 0:49:15' AND e.date<='2024-07-09 23:49:15' 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-07-08 21:49:15' AND g.time<='2024-07-09 20:49:15' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:1133
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 0:49:15' AND e.date<='2024-07-10 23:49:15' 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-07-09 21:49:15' AND g.time<='2024-07-10 20:49:15' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:710
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 0:49:15' AND e.date<='2024-07-11 23:49:15' 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-07-10 21:49:15' AND g.time<='2024-07-11 20:49:15' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:469
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 2:39:22' AND e.date<='2024-07-12 13:39:22' 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-07-11 23:39:22' AND g.time<='2024-07-12 10:39:22' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:133
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 0:39:42' AND e.date<='2024-07-12 13:39:42' 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-07-11 21:39:42' AND g.time<='2024-07-12 10:39:42' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:294
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 5:0:0' AND e.DeviceLoginName='3203' 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-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='3203' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:300
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:123
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 5:0:0' AND e.DeviceLoginName='2882' 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-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='2882' GROUP BY  g.time, g.Distance;
CountAzimuth:224
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 5:0:0' AND e.DeviceLoginName='352353085654322' 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-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='352353085654322' GROUP BY  g.time, g.Distance;
CountAzimuth:20
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:245
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 5:0:0' AND e.DeviceLoginName='4864' 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-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='4864' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-08 23:0:0' AND e.date<='2024-07-09 5:0:0' AND e.DeviceLoginName='3197' 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-07-08 20:00:00' AND g.time<='2024-07-09 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:99
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 23:0:0' AND e.date<='2024-07-10 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-09 20:00:00' AND g.time<='2024-07-10 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:273
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 23:0:0' AND e.date<='2024-07-10 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-09 20:00:00' AND g.time<='2024-07-10 02:00:00' AND g.DeviceLoginName='2623' GROUP BY  g.time, g.Distance;
CountAzimuth:518
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 23:0:0' AND e.date<='2024-07-10 5:0:0' 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-07-09 20:00:00' AND g.time<='2024-07-10 02:00:00' AND g.DeviceLoginName='2647' GROUP BY  g.time, g.Distance;
CountAzimuth:157
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 23:0:0' AND e.date<='2024-07-10 5:0:0' AND e.DeviceLoginName='352353085648530' 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-07-09 20:00:00' AND g.time<='2024-07-10 02:00:00' AND g.DeviceLoginName='352353085648530' GROUP BY  g.time, g.Distance;
CountAzimuth:185
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-09 23:0:0' AND e.date<='2024-07-10 5:0:0' AND e.DeviceLoginName='3197' 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-07-09 20:00:00' AND g.time<='2024-07-10 02:00:00' AND g.DeviceLoginName='3197' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='3203' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='3203' GROUP BY  g.time, g.Distance;
CountAzimuth:31
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='3144' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='3144' GROUP BY  g.time, g.Distance;
CountAzimuth:123
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='352353084209250' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='352353084209250' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:322
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='9382' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='9382' GROUP BY  g.time, g.Distance;
CountAzimuth:111
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='354836080152241' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='2489' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='2489' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='2496' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='2496' GROUP BY  g.time, g.Distance;
CountAzimuth:45
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 23:0:0' AND e.date<='2024-07-11 5:0:0' AND e.DeviceLoginName='3115' 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-07-10 20:00:00' AND g.time<='2024-07-11 02:00:00' AND g.DeviceLoginName='3115' GROUP BY  g.time, g.Distance;
CountAzimuth:22
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 23:0:0' AND e.date<='2024-07-12 5:0:0' AND e.DeviceLoginName='3184' 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-07-11 20:00:00' AND g.time<='2024-07-12 02:00:00' AND g.DeviceLoginName='3184' GROUP BY  g.time, g.Distance;
CountAzimuth:64
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 23:0:0' AND e.date<='2024-07-12 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-11 20:00:00' AND g.time<='2024-07-12 02:00:00' AND g.DeviceLoginName='2456' GROUP BY  g.time, g.Distance;
CountAzimuth:138
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 23:0:0' AND e.date<='2024-07-12 5:0:0' AND e.DeviceLoginName='356078111430837' 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-07-11 20:00:00' AND g.time<='2024-07-12 02:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY  g.time, g.Distance;
CountAzimuth:239
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 23:0:0' AND e.date<='2024-07-12 5:0:0' 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-07-11 20:00:00' AND g.time<='2024-07-12 02:00:00' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 23:0:0' AND e.date<='2024-07-12 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-07-11 20:00:00' AND g.time<='2024-07-12 02:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:235
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-11 23:0:0' AND e.date<='2024-07-12 5:0:0' AND e.DeviceLoginName='356078111262933' 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-07-11 20:00:00' AND g.time<='2024-07-12 02:00:00' AND g.DeviceLoginName='356078111262933' GROUP BY  g.time, g.Distance;
CountAzimuth:253
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 11:13:28' AND e.date<='2024-07-12 16:13:28' 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-07-12 08:13:28' AND g.time<='2024-07-12 13:13:28' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:192
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 13:47:59' AND e.date<='2024-07-12 16:47:59' 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-07-12 10:47:59' AND g.time<='2024-07-12 13:47:59' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:332
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 13:58:46' AND e.date<='2024-07-12 16:58:46' 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-07-12 10:58:46' AND g.time<='2024-07-12 13:58:46' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:332
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 14:13:1' AND e.date<='2024-07-12 17:13: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-07-12 11:13:01' AND g.time<='2024-07-12 14:13:01' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:332
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 15:14:47' AND e.date<='2024-07-12 17:14:47' 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-07-12 12:14:47' AND g.time<='2024-07-12 14:14:47' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:212
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 16:19:14' AND e.date<='2024-07-12 17:19:14' 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-07-12 13:19:14' AND g.time<='2024-07-12 14:19:14' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:117
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 14:29:27' AND e.date<='2024-07-12 17:29:27' 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-07-12 11:29:27' AND g.time<='2024-07-12 14:29:27' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:449
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-12 14:33:24' AND e.date<='2024-07-12 17:33:24' 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-07-12 11:33:24' AND g.time<='2024-07-12 14:33:24' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:468