Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 0:30:32' AND e.date<='2024-07-23 9:30:32' 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-07-22 21:30:32' AND g.time<='2024-07-23 06:30:32' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:340
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-22 10:45:32' AND e.date<='2024-07-23 10:45:32' 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-07-22 07:45:32' AND g.time<='2024-07-23 07:45:32' AND g.DeviceLoginName='352353083473741' GROUP BY  g.time, g.Distance;
CountAzimuth:2024
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 0:25:11' AND e.date<='2024-07-23 11:25:11' AND e.DeviceLoginName='354836080167561' 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-07-22 21:25:11' AND g.time<='2024-07-23 08:25:11' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:324
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 6:40:19' AND e.date<='2024-07-23 11:40:19' 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-07-23 03:40:19' AND g.time<='2024-07-23 08:40:19' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:74
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 7:20:27' AND e.date<='2024-07-23 13:20:27' AND e.DeviceLoginName='356078116278207' 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-07-23 04:20:27' AND g.time<='2024-07-23 10:20:27' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:567
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 3:50:50' AND e.date<='2024-07-23 13:50:50' AND e.DeviceLoginName='356078116278207' 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-07-23 00:50:50' AND g.time<='2024-07-23 10:50:50' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:650
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 3:51:27' AND e.date<='2024-07-23 13:51:27' AND e.DeviceLoginName='3056' 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-07-23 00:51:27' AND g.time<='2024-07-23 10:51:27' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:977
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 10:51:54' AND e.date<='2024-07-23 13:51:54' AND e.DeviceLoginName='354836080167561' 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-07-23 07:51:54' AND g.time<='2024-07-23 10:51:54' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:608
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 14:25:42' AND e.date<='2024-07-23 14:25:42' AND e.DeviceLoginName='3056' 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-07-23 11:25:42' AND g.time<='2024-07-23 11:25:42' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 14:25:42' AND e.date<='2024-07-23 14:25:42' AND e.DeviceLoginName='3056' 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-07-23 11:25:42' AND g.time<='2024-07-23 11:25:42' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 12:26:0' AND e.date<='2024-07-23 14:26:0' AND e.DeviceLoginName='3056' 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-07-23 09:26:00' AND g.time<='2024-07-23 11:26:00' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:394
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 12:26:29' AND e.date<='2024-07-23 14:26:29' AND e.DeviceLoginName='356078116278207' 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-07-23 09:26:29' AND g.time<='2024-07-23 11:26:29' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:151
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 12:35:10' AND e.date<='2024-07-23 14:35:10' AND e.DeviceLoginName='3056' 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-07-23 09:35:10' AND g.time<='2024-07-23 11:35:10' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:368
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 13:31:21' AND e.date<='2024-07-23 15:31:21' AND e.DeviceLoginName='3056' 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-07-23 10:31:21' AND g.time<='2024-07-23 12:31:21' AND g.DeviceLoginName='3056' GROUP BY  g.time, g.Distance;
CountAzimuth:523
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 13:31:40' AND e.date<='2024-07-23 15:31:40' AND e.DeviceLoginName='356078116278207' 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-07-23 10:31:40' AND g.time<='2024-07-23 12:31:40' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:188
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-23 1:32:22' AND e.date<='2024-07-23 15:32:22' AND e.DeviceLoginName='354836080167561' 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-07-22 22:32:22' AND g.time<='2024-07-23 12:32:22' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:919
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-07-22 21:00:00' AND g.time<='2024-07-23 12:47:35' AND g.DeviceLoginName='352353083473741'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 05:10:12' AND TIME<='2024-07-23 05:20:12' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 09:12:29' AND TIME<='2024-07-23 09:22:29' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 10:53:27' AND TIME<='2024-07-23 11:03:27' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 12:33:20' AND TIME<='2024-07-23 12:43:20' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-22 21:00:00' AND e.date<='2024-07-23 12:47:35'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 03:43:01' AND TIME<='2024-07-23 03:53:01' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 05:10:12' AND TIME<='2024-07-23 05:20:12' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 09:12:29' AND TIME<='2024-07-23 09:22:29' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 10:53:27' AND TIME<='2024-07-23 11:03:27' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 11:39:29' AND TIME<='2024-07-23 11:49:29' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 11:49:39' AND TIME<='2024-07-23 11:59:39' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 12:03:44' AND TIME<='2024-07-23 12:13:44' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-07-23 12:33:20' AND TIME<='2024-07-23 12:43:20' AND DeviceLoginName='352353083473741' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-10 13:38:23' AND e.date<='2024-07-10 14:38:23' AND e.DeviceLoginName='864866053465430' 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-07-10 10:38:23' AND g.time<='2024-07-10 11:38:23' AND g.DeviceLoginName='864866053465430' GROUP BY  g.time, g.Distance;
CountAzimuth:232
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 18:38:23' AND e.date<='2024-07-17 19:56:23' AND e.DeviceLoginName='864866053465430' 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-07-17 15:38:23' AND g.time<='2024-07-17 16:56:23' AND g.DeviceLoginName='864866053465430' GROUP BY  g.time, g.Distance;
CountAzimuth:208
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 19:24:23' AND e.date<='2024-07-17 19:56:23' AND e.DeviceLoginName='864866053465430' 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-07-17 16:24:23' AND g.time<='2024-07-17 16:56:23' AND g.DeviceLoginName='864866053465430' GROUP BY  g.time, g.Distance;
CountAzimuth:118
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-07-17 19:24:23' AND e.date<='2024-07-17 19:42:23' AND e.DeviceLoginName='864866053465430' 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-07-17 16:24:23' AND g.time<='2024-07-17 16:42:23' AND g.DeviceLoginName='864866053465430' GROUP BY  g.time, g.Distance;
CountAzimuth:92