Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-04 0:31:4' AND e.date<='2024-06-05 0:31:4' 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-03 21:31:04' AND g.time<='2024-06-04 21:31:04' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:215
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-20 0:3:38' AND e.date<='2024-05-20 23:3:38' 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:03:38' AND g.time<='2024-05-20 20:03:38' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:240
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-05 0:22:28' AND e.date<='2024-06-05 11:22:28' 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-04 21:22:28' AND g.time<='2024-06-05 08:22:28' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-05 0:22:28' AND e.date<='2024-06-05 11:22:28' 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-04 21:22:28' AND g.time<='2024-06-05 08:22:28' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-04 14:22:52' AND e.date<='2024-06-05 14:22:52' 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-04 11:22:52' AND g.time<='2024-06-05 11:22:52' AND g.DeviceLoginName='4884' GROUP BY  g.time, g.Distance;
CountAzimuth:332
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-04 21:00:00' AND g.time<='2024-06-05 12:09:29' AND g.DeviceLoginName='2768'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 04:10:34' AND TIME<='2024-06-05 04:20:34' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 04:32:19' AND TIME<='2024-06-05 04:42:19' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 04:41:19' AND TIME<='2024-06-05 04:51:19' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 05:03:25' AND TIME<='2024-06-05 05:13:25' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 05:44:57' AND TIME<='2024-06-05 05:54:57' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 06:23:42' AND TIME<='2024-06-05 06:33:42' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 06:42:12' AND TIME<='2024-06-05 06:52:12' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 07:29:27' AND TIME<='2024-06-05 07:39:27' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 07:40:42' AND TIME<='2024-06-05 07:50:42' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 08:14:12' AND TIME<='2024-06-05 08:24:12' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 08:38:12' AND TIME<='2024-06-05 08:48:12' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 09:51:26' AND TIME<='2024-06-05 10:01:26' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:07:41' AND TIME<='2024-06-05 10:17:41' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:16:11' AND TIME<='2024-06-05 10:26:11' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:42:11' AND TIME<='2024-06-05 10:52:11' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:58:56' AND TIME<='2024-06-05 11:08:56' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 11:20:26' AND TIME<='2024-06-05 11:30:26' AND DeviceLoginName='2768' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2768' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-04 21:00:00' AND e.date<='2024-06-05 12:09:29'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 04:10:34' AND TIME<='2024-06-05 04:20:34' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 04:32:19' AND TIME<='2024-06-05 04:42:19' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 05:44:57' AND TIME<='2024-06-05 05:54:57' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 06:23:42' AND TIME<='2024-06-05 06:33:42' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 06:42:12' AND TIME<='2024-06-05 06:52:12' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 07:29:27' AND TIME<='2024-06-05 07:39:27' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 07:40:42' AND TIME<='2024-06-05 07:50:42' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 08:14:12' AND TIME<='2024-06-05 08:24:12' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 08:38:12' AND TIME<='2024-06-05 08:48:12' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 09:51:26' AND TIME<='2024-06-05 10:01:26' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:07:41' AND TIME<='2024-06-05 10:17:41' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:16:11' AND TIME<='2024-06-05 10:26:11' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:28:56' AND TIME<='2024-06-05 10:38:56' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:35:41' AND TIME<='2024-06-05 10:45:41' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:42:11' AND TIME<='2024-06-05 10:52:11' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 10:58:56' AND TIME<='2024-06-05 11:08:56' AND DeviceLoginName='2768' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-06-05 11:20:26' AND TIME<='2024-06-05 11:30:26' AND DeviceLoginName='2768' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-04 15:21:19' AND e.date<='2024-06-05 15:21:19' AND e.DeviceLoginName='356078118083027' 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-04 12:21:19' AND g.time<='2024-06-05 12:21:19' AND g.DeviceLoginName='356078118083027' GROUP BY  g.time, g.Distance;
CountAzimuth:431
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-05-11 0:0:11' AND e.date<='2024-05-11 23:41:11' 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-05-10 21:00:11' AND g.time<='2024-05-11 20:41:11' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:462
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-01 0:0:11' AND e.date<='2024-06-01 23:41:11' 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-05-31 21:00:11' AND g.time<='2024-06-01 20:41:11' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:189
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-02 0:0:11' AND e.date<='2024-06-02 23:41:11' 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-06-01 21:00:11' AND g.time<='2024-06-02 20:41:11' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:202
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-06-03 0:0:11' AND e.date<='2024-06-05 23:41:11' 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-06-02 21:00:11' AND g.time<='2024-06-05 20:41:11' AND g.DeviceLoginName='2500' GROUP BY  g.time, g.Distance;
CountAzimuth:1435