Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 0:12:10' AND e.date<='2024-06-04 0:12:10' 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>='2024-06-02 21:12:10' AND g.time<='2024-06-03 21:12:10' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:114
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 6:52:45' AND e.date<='2024-06-03 9:52:45' AND e.DeviceLoginName='356078111279986' 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-03 03:52:45' AND g.time<='2024-06-03 06:52:45' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:150
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 4:53:34' AND e.date<='2024-06-03 7:53:34' AND e.DeviceLoginName='356078111279986' 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-03 01:53:34' AND g.time<='2024-06-03 04:53:34' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 8:23:20' AND e.date<='2024-06-03 9:54:20' AND e.DeviceLoginName='356078111279986' 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-03 05:23:20' AND g.time<='2024-06-03 06:54:20' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:151
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 9:56:11' AND e.date<='2024-06-03 12:56:11' AND e.DeviceLoginName='356078111279986' 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-03 06:56:11' AND g.time<='2024-06-03 09:56:11' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:55
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 12:57:34' AND e.date<='2024-06-03 15:57:34' AND e.DeviceLoginName='356078111279986' 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-03 09:57:34' AND g.time<='2024-06-03 12:57:34' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:140
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 14:58:15' AND e.date<='2024-06-03 20:58:15' AND e.DeviceLoginName='356078111279986' 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-03 11:58:15' AND g.time<='2024-06-03 17:58:15' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:333
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 19:59:43' AND e.date<='2024-06-03 23:59:43' AND e.DeviceLoginName='356078111279986' 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-03 16:59:43' AND g.time<='2024-06-03 20:59:43' AND g.DeviceLoginName='356078111279986' GROUP BY  g.time, g.Distance;
CountAzimuth:46
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 3:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-06-03 21:00:00' AND g.time<='2024-06-04 06:07:02' AND g.DeviceLoginName='9005'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-04 05:12:55' AND TIME<='2024-06-04 05:22:55' AND DeviceLoginName='9005' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='9005' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 21:00:00' AND e.date<='2024-06-04 06:07:02'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-04 05:07:47' AND TIME<='2024-06-04 05:17:47' AND DeviceLoginName='9005' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-27 0:4:49' AND e.date<='2024-05-31 23:4:49' AND e.DeviceLoginName='9005' 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-26 21:04:49' AND g.time<='2024-05-31 20:04:49' AND g.DeviceLoginName='9005' GROUP BY  g.time, g.Distance;
CountAzimuth:12592
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-02 0:43:57' AND e.date<='2024-06-02 23:43:57' 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-01 21:43:57' AND g.time<='2024-06-02 20:43:57' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:678
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:45:25' AND e.date<='2024-06-01 23:45:25' 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-05-31 21:45:25' AND g.time<='2024-06-01 20:45:25' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:773
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-04 0:34:20' AND e.date<='2024-06-04 13:34:20' 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-03 21:34:20' AND g.time<='2024-06-04 10:34:20' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:649
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-06 22:58:3' AND e.date<='2024-05-06 23:43:3' AND e.DeviceLoginName='3212' 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-06 19:58:03' AND g.time<='2024-05-06 20:43:03' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:41
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-14 22:58:3' AND e.date<='2024-05-14 23:43:3' AND e.DeviceLoginName='3212' 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-14 19:58:03' AND g.time<='2024-05-14 20:43:03' AND g.DeviceLoginName='3212' GROUP BY  g.time, g.Distance;
CountAzimuth:15
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-17 0:8:48' AND e.date<='2024-05-23 15:8:48' 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-05-16 21:08:48' AND g.time<='2024-05-23 12:08:48' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:9190
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:8:48' AND e.date<='2024-05-20 15:8:48' 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-05-19 21:08:48' AND g.time<='2024-05-20 12:08:48' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-19 0:8:48' AND e.date<='2024-05-21 15:8:48' 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-05-18 21:08:48' AND g.time<='2024-05-21 12:08:48' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:2477
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:8:48' AND e.date<='2024-05-20 23:8:48' 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-05-19 21:08:48' AND g.time<='2024-05-20 20:08:48' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:241
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-21 23:0:0' AND e.date<='2024-05-22 5:0:0' AND e.DeviceLoginName='3206' 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-21 20:00:00' AND g.time<='2024-05-22 02:00:00' AND g.DeviceLoginName='3206' GROUP BY  g.time, g.Distance;
CountAzimuth:109
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-27 16:22:55' AND e.date<='2024-06-04 16:22:55' AND e.DeviceLoginName='3032' 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-27 13:22:55' AND g.time<='2024-06-04 13:22:55' AND g.DeviceLoginName='3032' GROUP BY  g.time, g.Distance;
CountAzimuth:676