Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 16:51:56' AND e.date<='2024-01-30 23:51:56' AND e.DeviceLoginName='2594' 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-01-29 14:51:56' AND g.time<='2024-01-30 21:51:56' AND g.DeviceLoginName='2594' GROUP BY  g.time, g.Distance;
CountAzimuth:527
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-28 0:49:50' AND e.date<='2024-01-28 23:49:50' AND e.DeviceLoginName='352353084175477' 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-01-27 22:49:50' AND g.time<='2024-01-28 21:49:50' AND g.DeviceLoginName='352353084175477' GROUP BY  g.time, g.Distance;
CountAzimuth:147
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-27 0:51:18' AND e.date<='2024-01-27 23:51:18' AND e.DeviceLoginName='352353084175477' 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-01-26 22:51:18' AND g.time<='2024-01-27 21:51:18' AND g.DeviceLoginName='352353084175477' GROUP BY  g.time, g.Distance;
CountAzimuth:4
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-26 15:52:38' AND e.date<='2024-01-26 23:52:38' AND e.DeviceLoginName='352353084175477' 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-01-26 13:52:38' AND g.time<='2024-01-26 21:52:38' AND g.DeviceLoginName='352353084175477' GROUP BY  g.time, g.Distance;
CountAzimuth:518
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-28 0:53:35' AND e.date<='2024-01-28 23:53:35' AND e.DeviceLoginName='5046' 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-01-27 22:53:35' AND g.time<='2024-01-28 21:53:35' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:9
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-27 0:54:45' AND e.date<='2024-01-27 23:54:45' AND e.DeviceLoginName='5046' 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-01-26 22:54:45' AND g.time<='2024-01-27 21:54:45' AND g.DeviceLoginName='5046' GROUP BY  g.time, g.Distance;
CountAzimuth:398
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-28 0:58:15' AND e.date<='2024-01-28 23:58:15' 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-01-27 22:58:15' AND g.time<='2024-01-28 21:58:15' AND g.DeviceLoginName='2530' GROUP BY  g.time, g.Distance;
CountAzimuth:253
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-29 10:59:1' AND e.date<='2024-01-30 10:59:1' AND e.DeviceLoginName='3133' 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-01-29 08:59:01' AND g.time<='2024-01-30 08:59:01' AND g.DeviceLoginName='3133' GROUP BY  g.time, g.Distance;
CountAzimuth:556
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-27 0:58:56' AND e.date<='2024-01-27 23:58:56' 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-01-26 22:58:56' AND g.time<='2024-01-27 21:58:56' AND g.DeviceLoginName='2530' GROUP BY  g.time, g.Distance;
CountAzimuth:5
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-28 0:1:8' AND e.date<='2024-01-28 23:1:8' AND e.DeviceLoginName='4849' 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-01-27 22:01:08' AND g.time<='2024-01-28 21:01:08' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:763
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-27 0:1:50' AND e.date<='2024-01-27 23:1:50' AND e.DeviceLoginName='4849' 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-01-26 22:01:50' AND g.time<='2024-01-27 21:01:50' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:1189
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-26 0:11:2' AND e.date<='2024-01-26 23:11:2' AND e.DeviceLoginName='352353083550043' 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-01-25 22:11:02' AND g.time<='2024-01-26 21:11:02' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:1148
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-25 0:28:19' AND e.date<='2024-01-25 23:28:19' AND e.DeviceLoginName='352353083550043' 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-01-24 22:28:19' AND g.time<='2024-01-25 21:28:19' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:671
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-24 0:30:15' AND e.date<='2024-01-24 23:30:15' AND e.DeviceLoginName='352353083550043' 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-01-23 22:30:15' AND g.time<='2024-01-24 21:30:15' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:545
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-23 0:32:7' AND e.date<='2024-01-23 23:32:7' AND e.DeviceLoginName='352353083550043' 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-01-22 22:32:07' AND g.time<='2024-01-23 21:32:07' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:721
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 0:33:29' AND e.date<='2024-01-22 23:33:29' AND e.DeviceLoginName='352353083550043' 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-01-21 22:33:29' AND g.time<='2024-01-22 21:33:29' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:693
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-19 0:34:47' AND e.date<='2024-01-19 23:34:47' AND e.DeviceLoginName='352353083550043' 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-01-18 22:34:47' AND g.time<='2024-01-19 21:34:47' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:455
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 0:36:13' AND e.date<='2024-01-18 23:36:13' AND e.DeviceLoginName='352353083550043' 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-01-17 22:36:13' AND g.time<='2024-01-18 21:36:13' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:889
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-17 0:39:20' AND e.date<='2024-01-17 23:39:20' AND e.DeviceLoginName='352353083550043' 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-01-16 22:39:20' AND g.time<='2024-01-17 21:39:20' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:825
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-16 0:40:56' AND e.date<='2024-01-16 23:40:56' AND e.DeviceLoginName='352353083550043' 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-01-15 22:40:56' AND g.time<='2024-01-16 21:40:56' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:333
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-15 0:42:14' AND e.date<='2024-01-15 23:42:14' AND e.DeviceLoginName='352353083550043' 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-01-14 22:42:14' AND g.time<='2024-01-15 21:42:14' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:6
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 0:0:17' AND e.date<='2024-01-18 23:59:17' AND e.DeviceLoginName='352353083550043' 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-01-17 22:00:17' AND g.time<='2024-01-18 21:59:17' AND g.DeviceLoginName='352353083550043' GROUP BY  g.time, g.Distance;
CountAzimuth:889
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-22 0:52:35' AND e.date<='2024-01-26 23:52:35' AND e.DeviceLoginName='352353084655866' 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-01-21 22:52:35' AND g.time<='2024-01-26 21:52:35' AND g.DeviceLoginName='352353084655866' GROUP BY  g.time, g.Distance;
CountAzimuth:3531
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-01-29 22:00:00' AND g.time<='2024-01-30 13:01:41' AND g.DeviceLoginName='352353084146916'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 09:57:28' AND TIME<='2024-01-30 10:07:28' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 10:07:50' AND TIME<='2024-01-30 10:17:50' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 10:21:20' AND TIME<='2024-01-30 10:31:20' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 11:09:54' AND TIME<='2024-01-30 11:19:54' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 11:26:06' AND TIME<='2024-01-30 11:36:06' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 11:42:40' AND TIME<='2024-01-30 11:52:40' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 12:23:51' AND TIME<='2024-01-30 12:33:51' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353084146916' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-29 22:00:00' AND e.date<='2024-01-30 13:01:41'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 09:57:28' AND TIME<='2024-01-30 10:07:28' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 10:07:50' AND TIME<='2024-01-30 10:17:50' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 10:21:20' AND TIME<='2024-01-30 10:31:20' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 11:09:54' AND TIME<='2024-01-30 11:19:54' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 11:26:06' AND TIME<='2024-01-30 11:36:06' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 11:42:40' AND TIME<='2024-01-30 11:52:40' AND DeviceLoginName='352353084146916' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-01-30 12:23:51' AND TIME<='2024-01-30 12:33:51' AND DeviceLoginName='352353084146916' AND speed=0