Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 7:59:29' AND e.date<='2024-11-25 7:59:29' AND e.DeviceLoginName='352353083458635' 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-23 05:59:29' AND g.time<='2024-11-25 05:59:29' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 4:59:51' AND e.date<='2024-11-25 7:59:51' AND e.DeviceLoginName='352353083458635' 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-25 02:59:51' AND g.time<='2024-11-25 05:59:51' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 6:0:12' AND e.date<='2024-11-25 8:0:12' AND e.DeviceLoginName='352353083458635' 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-22 04:00:12' AND g.time<='2024-11-25 06:00:12' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:736
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 7:0:37' AND e.date<='2024-11-25 8:0:37' AND e.DeviceLoginName='354836080167561' 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-23 05:00:37' AND g.time<='2024-11-25 06:00:37' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:262
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:0:7' AND e.date<='2024-11-22 23:0:7' AND e.DeviceLoginName='862531041078313' 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 22:00:07' AND g.time<='2024-11-22 21:00:07' AND g.DeviceLoginName='862531041078313' GROUP BY  g.time, g.Distance;
CountAzimuth:575
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:0:7' AND e.date<='2024-11-19 23:0:7' AND e.DeviceLoginName='352353086171979' 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:00:07' AND g.time<='2024-11-19 21:00:07' AND g.DeviceLoginName='352353086171979' GROUP BY  g.time, g.Distance;
CountAzimuth:2426
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:0:7' AND e.date<='2024-11-19 23:0:7' AND e.DeviceLoginName='862531041050148' 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:00:07' AND g.time<='2024-11-19 21:00:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:2049
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:0:7' AND e.date<='2024-11-18 23:0:7' AND e.DeviceLoginName='862531041050148' 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:00:07' AND g.time<='2024-11-18 21:00:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:1398
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:0:7' AND e.date<='2024-11-19 23:0:7' AND e.DeviceLoginName='862531041050148' 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:00:07' AND g.time<='2024-11-19 21:00:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:2049
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:0:7' AND e.date<='2024-11-20 23:0:7' AND e.DeviceLoginName='862531041050148' 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:00:07' AND g.time<='2024-11-20 21:00:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:1708
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:0:7' AND e.date<='2024-11-21 23:0:7' AND e.DeviceLoginName='862531041050148' 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:00:07' AND g.time<='2024-11-21 21:00:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:735
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:0:7' AND e.date<='2024-11-22 23:0:7' AND e.DeviceLoginName='862531041050148' 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 22:00:07' AND g.time<='2024-11-22 21:00:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:1559
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 0:0:7' AND e.date<='2024-11-24 23:0:7' AND e.DeviceLoginName='862531041050148' 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-23 22:00:07' AND g.time<='2024-11-24 21:00:07' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:437
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 0:0:7' AND e.date<='2024-11-24 23:0: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-23 22:00:07' AND g.time<='2024-11-24 21:00:07' AND g.DeviceLoginName='352353086184998' GROUP BY  g.time, g.Distance;
CountAzimuth:2517
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-24 22:00:00' AND g.time<='2024-11-25 07:26:27' AND g.DeviceLoginName='2906'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-25 06:49:11' AND TIME<='2024-11-25 06:59:11' AND DeviceLoginName='2906' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2906' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-24 22:00:00' AND e.date<='2024-11-25 07:26:27'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-25 06:49:11' AND TIME<='2024-11-25 06:59:11' AND DeviceLoginName='2906' AND speed=0
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-24 22:00:00' AND g.time<='2024-11-25 08:25:12' AND g.DeviceLoginName='864866053465430'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-25 07:41:50' AND TIME<='2024-11-25 07:51:50' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='864866053465430' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-24 22:00:00' AND e.date<='2024-11-25 08:25:12'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-25 07:35:24' AND TIME<='2024-11-25 07:45:24' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-11-25 07:41:50' AND TIME<='2024-11-25 07:51:50' AND DeviceLoginName='864866053465430' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='356078116287711' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='356078116287711' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='356078111446148' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='356078111446148' GROUP BY  g.time, g.Distance;
CountAzimuth:162
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' 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-11-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:121
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='356078111320111' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='356078111320111' GROUP BY  g.time, g.Distance;
CountAzimuth:362
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='5117' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='5117' GROUP BY  g.time, g.Distance;
CountAzimuth:335
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='4825' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='4825' GROUP BY  g.time, g.Distance;
CountAzimuth:134
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='4862' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='4862' GROUP BY  g.time, g.Distance;
CountAzimuth:265
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='3061' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:196
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 23:0:0' AND e.date<='2024-11-23 5:0:0' AND e.DeviceLoginName='2676' 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-22 21:00:00' AND g.time<='2024-11-23 03:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:26
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='9010' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='9010' GROUP BY  g.time, g.Distance;
CountAzimuth:90
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='9011' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='9011' GROUP BY  g.time, g.Distance;
CountAzimuth:89
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='356078111430936' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='356078111430936' GROUP BY  g.time, g.Distance;
CountAzimuth:93
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' 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-11-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='4849' GROUP BY  g.time, g.Distance;
CountAzimuth:188
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='862531041050148' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:300
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='2783' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:82
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='3030' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:23
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='4861' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='4861' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='2470' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='2470' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='3061' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='3061' GROUP BY  g.time, g.Distance;
CountAzimuth:108
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='3156' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:65
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='2728' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='2728' GROUP BY  g.time, g.Distance;
CountAzimuth:61
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='2676' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='2676' GROUP BY  g.time, g.Distance;
CountAzimuth:80
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 23:0:0' AND e.date<='2024-11-24 5:0:0' AND e.DeviceLoginName='2499' 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-23 21:00:00' AND g.time<='2024-11-24 03:00:00' AND g.DeviceLoginName='2499' GROUP BY  g.time, g.Distance;
CountAzimuth:114
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='353173060485131' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY  g.time, g.Distance;
CountAzimuth:13
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='3108' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='3108' GROUP BY  g.time, g.Distance;
CountAzimuth:56
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='3073' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='3073' GROUP BY  g.time, g.Distance;
CountAzimuth:11
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='4966' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='4966' GROUP BY  g.time, g.Distance;
CountAzimuth:160
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='2883' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='2883' GROUP BY  g.time, g.Distance;
CountAzimuth:167
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='2703' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='2703' GROUP BY  g.time, g.Distance;
CountAzimuth:33
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='9375' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='9375' GROUP BY  g.time, g.Distance;
CountAzimuth:12
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='862531041050148' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY  g.time, g.Distance;
CountAzimuth:33
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='3030' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='3030' GROUP BY  g.time, g.Distance;
CountAzimuth:1120
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='9019' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='9019' GROUP BY  g.time, g.Distance;
CountAzimuth:29
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='2866' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='2866' GROUP BY  g.time, g.Distance;
CountAzimuth:980
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='2584' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='2584' GROUP BY  g.time, g.Distance;
CountAzimuth:18
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 23:0:0' AND e.date<='2024-11-25 5:0:0' AND e.DeviceLoginName='2964' 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-24 21:00:00' AND g.time<='2024-11-25 03:00:00' AND g.DeviceLoginName='2964' GROUP BY  g.time, g.Distance;
CountAzimuth:152
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 17:20:57' AND e.date<='2024-11-18 18:20:57' AND e.DeviceLoginName='3075' 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 15:20:57' AND g.time<='2024-11-18 16:20:57' AND g.DeviceLoginName='3075' GROUP BY  g.time, g.Distance;
CountAzimuth:547
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 18:20:57' AND e.date<='2024-11-18 19:20:57' AND e.DeviceLoginName='3075' 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 16:20:57' AND g.time<='2024-11-18 17:20:57' AND g.DeviceLoginName='3075' GROUP BY  g.time, g.Distance;
CountAzimuth:705
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 23:0:0' AND e.date<='2024-11-19 5:0:0' AND e.DeviceLoginName='3156' 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 21:00:00' AND g.time<='2024-11-19 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:19
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 23:0:0' AND e.date<='2024-11-20 5:0:0' AND e.DeviceLoginName='3156' 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 21:00:00' AND g.time<='2024-11-20 03:00:00' AND g.DeviceLoginName='3156' GROUP BY  g.time, g.Distance;
CountAzimuth:243
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 23:0:0' AND e.date<='2024-11-19 5:0:0' AND e.DeviceLoginName='356078116296357' 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 21:00:00' AND g.time<='2024-11-19 03:00:00' AND g.DeviceLoginName='356078116296357' GROUP BY  g.time, g.Distance;
CountAzimuth:102
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-01 0:0:0' AND e.date<='2024-11-01 23:0:0' AND e.DeviceLoginName='2948' 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-31 22:00:00' AND g.time<='2024-11-01 21:00:00' AND g.DeviceLoginName='2948' GROUP BY  g.time, g.Distance;
CountAzimuth:6125
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-11 0:0:0' AND e.date<='2024-11-11 23:0:0' AND e.DeviceLoginName='2954' 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-10 22:00:00' AND g.time<='2024-11-11 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:1348
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-12 0:0:0' AND e.date<='2024-11-12 23:0:0' AND e.DeviceLoginName='2954' 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-11 22:00:00' AND g.time<='2024-11-12 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:1329
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-01 0:0:0' AND e.date<='2024-11-01 23:0:0' AND e.DeviceLoginName='2954' 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-31 22:00:00' AND g.time<='2024-11-01 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:1744
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-05 0:0:0' AND e.date<='2024-11-05 23:0:0' AND e.DeviceLoginName='2954' 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-04 22:00:00' AND g.time<='2024-11-05 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:1281
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 13:19:24' AND e.date<='2024-11-25 13:19:24' 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-11-18 11:19:24' AND g.time<='2024-11-25 11:19:24' AND g.DeviceLoginName='352353084175477' GROUP BY  g.time, g.Distance;
CountAzimuth:5890
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-08 0:0:0' AND e.date<='2024-11-08 23:0:0' AND e.DeviceLoginName='2954' 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-07 22:00:00' AND g.time<='2024-11-08 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:2218
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-14 0:0:0' AND e.date<='2024-11-14 23:0:0' AND e.DeviceLoginName='2954' 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-13 22:00:00' AND g.time<='2024-11-14 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:2985
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 4:20:47' AND e.date<='2024-11-25 13:20:47' AND e.DeviceLoginName='352353083458635' 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-25 02:20:47' AND g.time<='2024-11-25 11:20:47' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 5:21:1' AND e.date<='2024-11-25 13:21:1' AND e.DeviceLoginName='352353083458635' 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-22 03:21:01' AND g.time<='2024-11-25 11:21:01' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:736
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:0:0' AND e.date<='2024-11-18 23:0:0' AND e.DeviceLoginName='2954' 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:00:00' AND g.time<='2024-11-18 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:1777
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 0:0:0' AND e.date<='2024-11-24 23:0:0' AND e.DeviceLoginName='2954' 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-23 22:00:00' AND g.time<='2024-11-24 21:00:00' AND g.DeviceLoginName='2954' GROUP BY  g.time, g.Distance;
CountAzimuth:1076
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-24 14:4:54' AND e.date<='2024-11-25 14:4:54' AND e.DeviceLoginName='2783' 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-24 12:04:54' AND g.time<='2024-11-25 12:04:54' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:2423
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 0:7:28' AND e.date<='2024-11-25 14:7:28' AND e.DeviceLoginName='2783' 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-24 22:07:28' AND g.time<='2024-11-25 12:07:28' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:2252
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-25 5:21:41' AND e.date<='2024-11-25 15:21:41' AND e.DeviceLoginName='356078116278207' 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-25 03:21:41' AND g.time<='2024-11-25 13:21:41' AND g.DeviceLoginName='356078116278207' GROUP BY  g.time, g.Distance;
CountAzimuth:573
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:28:21' AND e.date<='2024-11-18 23:28:21' 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-17 22:28:21' AND g.time<='2024-11-18 21:28:21' AND g.DeviceLoginName='352353086182380' GROUP BY  g.time, g.Distance;
CountAzimuth:554
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:28:21' AND e.date<='2024-11-19 23:28:21' 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-18 22:28:21' AND g.time<='2024-11-19 21:28:21' AND g.DeviceLoginName='352353086182380' GROUP BY  g.time, g.Distance;
CountAzimuth:416
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:28:21' AND e.date<='2024-11-20 23:28:21' 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-19 22:28:21' AND g.time<='2024-11-20 21:28:21' AND g.DeviceLoginName='352353086182380' GROUP BY  g.time, g.Distance;
CountAzimuth:1076
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:28:21' AND e.date<='2024-11-21 23:28:21' 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 22:28:21' AND g.time<='2024-11-21 21:28:21' AND g.DeviceLoginName='352353086182380' GROUP BY  g.time, g.Distance;
CountAzimuth:1072
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:28:21' AND e.date<='2024-11-22 23:28:21' 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-21 22:28:21' AND g.time<='2024-11-22 21:28:21' AND g.DeviceLoginName='352353086182380' GROUP BY  g.time, g.Distance;
CountAzimuth:587
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:28:21' AND e.date<='2024-11-18 23:28:21' AND e.DeviceLoginName='352353086180491' 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:28:21' AND g.time<='2024-11-18 21:28:21' AND g.DeviceLoginName='352353086180491' GROUP BY  g.time, g.Distance;
CountAzimuth:1624
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:28:21' AND e.date<='2024-11-19 23:28:21' AND e.DeviceLoginName='352353086180491' 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:28:21' AND g.time<='2024-11-19 21:28:21' AND g.DeviceLoginName='352353086180491' GROUP BY  g.time, g.Distance;
CountAzimuth:2264
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:28:21' AND e.date<='2024-11-20 23:28:21' AND e.DeviceLoginName='352353086180491' 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:28:21' AND g.time<='2024-11-20 21:28:21' AND g.DeviceLoginName='352353086180491' GROUP BY  g.time, g.Distance;
CountAzimuth:2179
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:28:21' AND e.date<='2024-11-21 23:28:21' AND e.DeviceLoginName='352353086180491' 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:28:21' AND g.time<='2024-11-21 21:28:21' AND g.DeviceLoginName='352353086180491' GROUP BY  g.time, g.Distance;
CountAzimuth:1890
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:28:21' AND e.date<='2024-11-22 23:28:21' AND e.DeviceLoginName='352353086180491' 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 22:28:21' AND g.time<='2024-11-22 21:28:21' AND g.DeviceLoginName='352353086180491' GROUP BY  g.time, g.Distance;
CountAzimuth:221
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:28:21' AND e.date<='2024-11-18 23:28:21' AND e.DeviceLoginName='352353086185151' 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:28:21' AND g.time<='2024-11-18 21:28:21' AND g.DeviceLoginName='352353086185151' GROUP BY  g.time, g.Distance;
CountAzimuth:1564
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:28:21' AND e.date<='2024-11-19 23:28:21' AND e.DeviceLoginName='352353086185151' 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:28:21' AND g.time<='2024-11-19 21:28:21' AND g.DeviceLoginName='352353086185151' GROUP BY  g.time, g.Distance;
CountAzimuth:2137
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:28:21' AND e.date<='2024-11-20 23:28:21' AND e.DeviceLoginName='352353086185151' 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:28:21' AND g.time<='2024-11-20 21:28:21' AND g.DeviceLoginName='352353086185151' GROUP BY  g.time, g.Distance;
CountAzimuth:1121
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:28:21' AND e.date<='2024-11-21 23:28:21' AND e.DeviceLoginName='352353086185151' 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:28:21' AND g.time<='2024-11-21 21:28:21' AND g.DeviceLoginName='352353086185151' GROUP BY  g.time, g.Distance;
CountAzimuth:1382
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:28:21' AND e.date<='2024-11-22 23:28:21' AND e.DeviceLoginName='352353086185151' 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 22:28:21' AND g.time<='2024-11-22 21:28:21' AND g.DeviceLoginName='352353086185151' GROUP BY  g.time, g.Distance;
CountAzimuth:1303
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:28:21' AND e.date<='2024-11-19 23:28:21' AND e.DeviceLoginName='352353086181390' 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:28:21' AND g.time<='2024-11-19 21:28:21' AND g.DeviceLoginName='352353086181390' GROUP BY  g.time, g.Distance;
CountAzimuth:597
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:28:21' AND e.date<='2024-11-20 23:28:21' AND e.DeviceLoginName='352353086181390' 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:28:21' AND g.time<='2024-11-20 21:28:21' AND g.DeviceLoginName='352353086181390' GROUP BY  g.time, g.Distance;
CountAzimuth:400
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:28:21' AND e.date<='2024-11-21 23:28:21' AND e.DeviceLoginName='352353086181390' 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:28:21' AND g.time<='2024-11-21 21:28:21' AND g.DeviceLoginName='352353086181390' GROUP BY  g.time, g.Distance;
CountAzimuth:563
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:28:21' AND e.date<='2024-11-22 23:28:21' AND e.DeviceLoginName='352353086181390' 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 22:28:21' AND g.time<='2024-11-22 21:28:21' AND g.DeviceLoginName='352353086181390' GROUP BY  g.time, g.Distance;
CountAzimuth:838
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:28:21' AND e.date<='2024-11-18 23:28:21' AND e.DeviceLoginName='2515' 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:28:21' AND g.time<='2024-11-18 21:28:21' AND g.DeviceLoginName='2515' GROUP BY  g.time, g.Distance;
CountAzimuth:178
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:28:21' AND e.date<='2024-11-19 23:28:21' AND e.DeviceLoginName='2515' 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:28:21' AND g.time<='2024-11-19 21:28:21' AND g.DeviceLoginName='2515' GROUP BY  g.time, g.Distance;
CountAzimuth:254
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:28:21' AND e.date<='2024-11-20 23:28:21' AND e.DeviceLoginName='2515' 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:28:21' AND g.time<='2024-11-20 21:28:21' AND g.DeviceLoginName='2515' GROUP BY  g.time, g.Distance;
CountAzimuth:797
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:28:21' AND e.date<='2024-11-21 23:28:21' AND e.DeviceLoginName='2515' 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:28:21' AND g.time<='2024-11-21 21:28:21' AND g.DeviceLoginName='2515' GROUP BY  g.time, g.Distance;
CountAzimuth:708
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:28:21' AND e.date<='2024-11-22 23:28:21' AND e.DeviceLoginName='2515' 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 22:28:21' AND g.time<='2024-11-22 21:28:21' AND g.DeviceLoginName='2515' GROUP BY  g.time, g.Distance;
CountAzimuth:214
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-18 0:28:21' AND e.date<='2024-11-18 23:28:21' AND e.DeviceLoginName='2589' 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:28:21' AND g.time<='2024-11-18 21:28:21' AND g.DeviceLoginName='2589' GROUP BY  g.time, g.Distance;
CountAzimuth:923
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-19 0:28:21' AND e.date<='2024-11-19 23:28:21' AND e.DeviceLoginName='2589' 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:28:21' AND g.time<='2024-11-19 21:28:21' AND g.DeviceLoginName='2589' GROUP BY  g.time, g.Distance;
CountAzimuth:305
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-20 0:28:21' AND e.date<='2024-11-20 23:28:21' AND e.DeviceLoginName='2589' 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:28:21' AND g.time<='2024-11-20 21:28:21' AND g.DeviceLoginName='2589' GROUP BY  g.time, g.Distance;
CountAzimuth:567
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-21 0:28:21' AND e.date<='2024-11-21 23:28:21' AND e.DeviceLoginName='2589' 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:28:21' AND g.time<='2024-11-21 21:28:21' AND g.DeviceLoginName='2589' GROUP BY  g.time, g.Distance;
CountAzimuth:615
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-22 0:28:21' AND e.date<='2024-11-22 23:28:21' AND e.DeviceLoginName='2589' 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 22:28:21' AND g.time<='2024-11-22 21:28:21' AND g.DeviceLoginName='2589' GROUP BY  g.time, g.Distance;
CountAzimuth:280