Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:26:25' AND e.date<='2024-11-20 23:26:25' AND e.DeviceLoginName='2530' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-19 22:26:25' AND g.time<='2024-11-20 21:26:25' AND g.DeviceLoginName='2530' GROUP BY  g.time, g.Distance;
CountAzimuth:1183
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:38:49' AND e.date<='2024-11-21 10:38:49' AND e.DeviceLoginName='353173067110641' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:38:49' AND g.time<='2024-11-21 08:38:49' AND g.DeviceLoginName='353173067110641' GROUP BY  g.time, g.Distance;
CountAzimuth:278
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-10-21 0:42:18' AND e.date<='2024-11-17 23:42:18' AND e.DeviceLoginName='4884' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-10-20 22:42:18' AND g.time<='2024-11-17 21:42:18' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:20256
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:42:18' AND e.date<='2024-11-21 23:42:18' AND e.DeviceLoginName='4884' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-17 22:42:18' AND g.time<='2024-11-21 21:42:18' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:3047
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 11:39:42' AND e.date<='2024-11-21 11:39:42' AND e.DeviceLoginName='355234055581363' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 09:39:42' AND g.time<='2024-11-21 09:39:42' AND g.DeviceLoginName='355234055581363' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 7:52:35' AND e.date<='2024-11-21 11:52:35' AND e.DeviceLoginName='356078116281466' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-21 05:52:35' AND g.time<='2024-11-21 09:52:35' AND g.DeviceLoginName='356078116281466' GROUP BY  g.time, g.Distance;
CountAzimuth:996
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:35:8' AND e.date<='2024-11-21 12:35:8' AND e.DeviceLoginName='2833' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:35:08' AND g.time<='2024-11-21 10:35:08' AND g.DeviceLoginName='2833' GROUP BY  g.time, g.Distance;
CountAzimuth:1776
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:35:8' AND e.date<='2024-11-21 12:35:8' AND e.DeviceLoginName='2833' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-19 22:35:08' AND g.time<='2024-11-21 10:35:08' AND g.DeviceLoginName='2833' GROUP BY  g.time, g.Distance;
CountAzimuth:2102
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:59:7' AND e.date<='2024-11-21 13:59:7' AND e.DeviceLoginName='352353086184998' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-17 22:59:07' AND g.time<='2024-11-21 11:59:07' AND g.DeviceLoginName='352353086184998' GROUP BY  g.time, g.Distance;
CountAzimuth:1853
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 14:31:1' AND e.date<='2024-11-21 14:31:1' AND e.DeviceLoginName='352353086182380' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 12:31:01' AND g.time<='2024-11-21 12:31:01' AND g.DeviceLoginName='352353086182380' GROUP BY  g.time, g.Distance;
CountAzimuth:1180
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude FROM  tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:00:00' AND g.time<='2024-11-21 13:11:00' AND g.DeviceLoginName='352353083504503'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-21 12:16:40' AND TIME<='2024-11-21 12:26:40' AND DeviceLoginName='352353083504503' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083504503' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-20 22:00:00' AND e.date<='2024-11-21 13:11:00'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-21 11:43:38' AND TIME<='2024-11-21 11:53:38' AND DeviceLoginName='352353083504503' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-21 12:16:40' AND TIME<='2024-11-21 12:26:40' AND DeviceLoginName='352353083504503' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:56:41' AND e.date<='2024-11-18 23:56:41' AND e.DeviceLoginName='2590' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-17 22:56:41' AND g.time<='2024-11-18 21:56:41' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:1237
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:56:41' AND e.date<='2024-11-19 23:56:41' AND e.DeviceLoginName='2590' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-18 22:56:41' AND g.time<='2024-11-19 21:56:41' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:1231
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:56:41' AND e.date<='2024-11-20 23:56:41' AND e.DeviceLoginName='2590' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-19 22:56:41' AND g.time<='2024-11-20 21:56:41' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:978
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:56:41' AND e.date<='2024-11-21 23:56:41' AND e.DeviceLoginName='2590' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:56:41' AND g.time<='2024-11-21 21:56:41' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:217
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:56:41' AND e.date<='2024-11-21 23:56:41' AND e.DeviceLoginName='2590' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:56:41' AND g.time<='2024-11-21 21:56:41' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:217
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:56:41' AND e.date<='2024-11-21 23:56:41' AND e.DeviceLoginName='2590' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:56:41' AND g.time<='2024-11-21 21:56:41' AND g.DeviceLoginName='2590' GROUP BY  g.time, g.Distance;
CountAzimuth:217
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:56:41' AND e.date<='2024-11-21 23:56:41' AND e.DeviceLoginName='352353085039086' AND e.EventType=7
Method:GetMovementInfo; Query:SELECT g.latitude,g.longitude,g.azimuth,ADDTIME(g.time,'0 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-11-20 22:56:41' AND g.time<='2024-11-21 21:56:41' AND g.DeviceLoginName='352353085039086' GROUP BY  g.time, g.Distance;
CountAzimuth:815