Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 2:26:22' AND e.date<='2024-05-23 12:26:22' 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-22 23:26:22' AND g.time<='2024-05-23 09:26:22' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:520
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 2:37:26' AND e.date<='2024-05-23 12:37:26' 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-22 23:37:26' AND g.time<='2024-05-23 09:37:26' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:615
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 1:58:26' AND e.date<='2024-05-23 12:58:26' 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-22 22:58:26' AND g.time<='2024-05-23 09:58:26' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:683
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 0:1:40' AND e.date<='2024-05-23 13:1:40' 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-22 21:01:40' AND g.time<='2024-05-23 10:01:40' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:702
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 5:10:53' AND e.date<='2024-05-23 13:10:53' 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-23 02:10:53' AND g.time<='2024-05-23 10:10:53' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:774
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 8:23:10' AND e.date<='2024-05-23 13:23:10' 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-23 05:23:10' AND g.time<='2024-05-23 10:23:10' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:480
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-23 4:23:35' AND e.date<='2024-05-23 13:23:35' 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-05-23 01:23:35' AND g.time<='2024-05-23 10:23:35' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:326
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 17:0:30' AND e.date<='2024-05-22 19:0:30' AND e.DeviceLoginName='3123' 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-22 14:00:30' AND g.time<='2024-05-22 16:00:30' AND g.DeviceLoginName='3123' GROUP BY  g.time, g.Distance;
CountAzimuth:636
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 17:0:30' AND e.date<='2024-05-22 19:0:30' AND e.DeviceLoginName='2785' 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-22 14:00:30' AND g.time<='2024-05-22 16:00:30' AND g.DeviceLoginName='2785' GROUP BY  g.time, g.Distance;
CountAzimuth:154
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 17:0:30' AND e.date<='2024-05-22 19:0:30' AND e.DeviceLoginName='3123' 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-22 14:00:30' AND g.time<='2024-05-22 16:00:30' AND g.DeviceLoginName='3123' GROUP BY  g.time, g.Distance;
CountAzimuth:636
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-22 17:0:30' AND e.date<='2024-05-22 19:0:30' AND e.DeviceLoginName='2785' 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-22 14:00:30' AND g.time<='2024-05-22 16:00:30' AND g.DeviceLoginName='2785' GROUP BY  g.time, g.Distance;
CountAzimuth:154
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-05-22 21:00:00' AND g.time<='2024-05-23 12:26:19' AND g.DeviceLoginName='2726'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 20:55:03' AND TIME<='2024-05-22 21:05:03' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 21:34:48' AND TIME<='2024-05-22 21:44:48' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 21:52:33' AND TIME<='2024-05-22 22:02:33' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 22:19:33' AND TIME<='2024-05-22 22:29:33' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 22:30:33' AND TIME<='2024-05-22 22:40:33' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 22:48:03' AND TIME<='2024-05-22 22:58:03' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 00:12:03' AND TIME<='2024-05-23 00:22:03' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 00:37:48' AND TIME<='2024-05-23 00:47:48' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 02:51:32' AND TIME<='2024-05-23 03:01:32' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 03:43:31' AND TIME<='2024-05-23 03:53:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 04:07:16' AND TIME<='2024-05-23 04:17:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 05:57:16' AND TIME<='2024-05-23 06:07:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 06:19:31' AND TIME<='2024-05-23 06:29:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 07:38:46' AND TIME<='2024-05-23 07:48:46' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 07:48:46' AND TIME<='2024-05-23 07:58:46' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:00:46' AND TIME<='2024-05-23 08:10:46' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:11:16' AND TIME<='2024-05-23 08:21:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:20:31' AND TIME<='2024-05-23 08:30:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:38:16' AND TIME<='2024-05-23 08:48:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 09:18:01' AND TIME<='2024-05-23 09:28:01' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 10:31:01' AND TIME<='2024-05-23 10:41:01' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 10:44:31' AND TIME<='2024-05-23 10:54:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-22 21:00:00' AND e.date<='2024-05-23 12:26:19'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 20:55:03' AND TIME<='2024-05-22 21:05:03' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 21:26:03' AND TIME<='2024-05-22 21:36:03' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 21:34:48' AND TIME<='2024-05-22 21:44:48' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 21:44:48' AND TIME<='2024-05-22 21:54:48' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 21:52:33' AND TIME<='2024-05-22 22:02:33' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 22:19:33' AND TIME<='2024-05-22 22:29:33' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 22:30:33' AND TIME<='2024-05-22 22:40:33' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-22 22:48:03' AND TIME<='2024-05-22 22:58:03' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 00:12:03' AND TIME<='2024-05-23 00:22:03' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 00:37:48' AND TIME<='2024-05-23 00:47:48' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 02:51:32' AND TIME<='2024-05-23 03:01:32' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 03:43:31' AND TIME<='2024-05-23 03:53:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 04:07:16' AND TIME<='2024-05-23 04:17:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 05:57:16' AND TIME<='2024-05-23 06:07:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 06:19:31' AND TIME<='2024-05-23 06:29:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 07:25:22' AND TIME<='2024-05-23 07:35:22' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 07:38:46' AND TIME<='2024-05-23 07:48:46' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 07:44:01' AND TIME<='2024-05-23 07:54:01' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 07:48:46' AND TIME<='2024-05-23 07:58:46' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 07:55:31' AND TIME<='2024-05-23 08:05:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:00:46' AND TIME<='2024-05-23 08:10:46' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:11:16' AND TIME<='2024-05-23 08:21:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:17:01' AND TIME<='2024-05-23 08:27:01' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:20:31' AND TIME<='2024-05-23 08:30:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 08:38:16' AND TIME<='2024-05-23 08:48:16' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 09:18:01' AND TIME<='2024-05-23 09:28:01' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 10:20:31' AND TIME<='2024-05-23 10:30:31' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 10:31:01' AND TIME<='2024-05-23 10:41:01' AND DeviceLoginName='2726' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-05-23 10:44:31' AND TIME<='2024-05-23 10:54:31' AND DeviceLoginName='2726' AND speed=0