Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 7:9:42' AND e.date<='2024-12-04 23:9:42' 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-12-04 05:09:42' AND g.time<='2024-12-04 21:09:42' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:1116
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 5:26:40' AND e.date<='2024-12-05 23:26:40' AND e.DeviceLoginName='2556' 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-12-05 03:26:40' AND g.time<='2024-12-05 21:26:40' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:73
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 7:31:12' AND e.date<='2024-12-04 22:31:12' AND e.DeviceLoginName='2556' 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-12-04 05:31:12' AND g.time<='2024-12-04 20:31:12' AND g.DeviceLoginName='2556' GROUP BY  g.time, g.Distance;
CountAzimuth:671
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 7:31:41' AND e.date<='2024-12-04 20:31:41' 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-12-04 05:31:41' AND g.time<='2024-12-04 18:31:41' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:387
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 12:33:55' AND e.date<='2024-12-05 2:33:55' 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-12-04 10:33:55' AND g.time<='2024-12-05 00:33:55' AND g.DeviceLoginName='2594' GROUP BY  g.time, g.Distance;
CountAzimuth:225
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 0:2:17' AND e.date<='2024-12-02 23:2:17' AND e.DeviceLoginName='3045' 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-12-01 22:02:17' AND g.time<='2024-12-02 21:02:17' AND g.DeviceLoginName='3045' GROUP BY  g.time, g.Distance;
CountAzimuth:2542
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 0:29:26' AND e.date<='2024-12-02 23:29:26' AND e.DeviceLoginName='3076' 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-12-01 22:29:26' AND g.time<='2024-12-02 21:29:26' AND g.DeviceLoginName='3076' GROUP BY  g.time, g.Distance;
CountAzimuth:3318
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 0:29:26' AND e.date<='2024-12-03 23:29:26' AND e.DeviceLoginName='3076' 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-12-02 22:29:26' AND g.time<='2024-12-03 21:29:26' AND g.DeviceLoginName='3076' GROUP BY  g.time, g.Distance;
CountAzimuth:1077
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 0:29:26' AND e.date<='2024-12-04 23:29:26' AND e.DeviceLoginName='3076' 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-12-03 22:29:26' AND g.time<='2024-12-04 21:29:26' AND g.DeviceLoginName='3076' GROUP BY  g.time, g.Distance;
CountAzimuth:4072
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-12-04 22:00:00' AND g.time<='2024-12-05 08:10:53' AND g.DeviceLoginName='356078116291713'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-05 07:54:11' AND TIME<='2024-12-05 08:04:11' AND DeviceLoginName='356078116291713' AND speed=0
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='356078116291713' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 22:00:00' AND e.date<='2024-12-05 08:10:53'
Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-05 07:54:11' AND TIME<='2024-12-05 08:04:11' AND DeviceLoginName='356078116291713' AND speed=0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-23 0:58:38' AND e.date<='2024-11-24 23:58:38' 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-22 22:58:38' AND g.time<='2024-11-24 21:58:38' AND g.DeviceLoginName='2783' GROUP BY  g.time, g.Distance;
CountAzimuth:314
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 2:31:18' AND e.date<='2024-12-05 11:31:18' 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-12-05 00:31:18' AND g.time<='2024-12-05 09:31:18' 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-12-05 0:31:34' AND e.date<='2024-12-05 11:31:34' 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-12-04 22:31:34' AND g.time<='2024-12-05 09:31:34' 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-12-04 17:31:45' AND e.date<='2024-12-05 11:31:45' 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-12-04 15:31:45' AND g.time<='2024-12-05 09:31:45' AND g.DeviceLoginName='352353083458635' GROUP BY  g.time, g.Distance;
CountAzimuth:236
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 4:42:55' AND e.date<='2024-12-05 11:42:55' 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-12-05 02:42:55' AND g.time<='2024-12-05 09:42:55' 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-12-05 0:30:2' AND e.date<='2024-12-05 13:30:2' AND e.DeviceLoginName='354836080392292' 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-12-04 22:30:02' AND g.time<='2024-12-05 11:30:02' AND g.DeviceLoginName='354836080392292' GROUP BY  g.time, g.Distance;
CountAzimuth:819
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 0:30:2' AND e.date<='2024-12-04 23:30:2' AND e.DeviceLoginName='354836080392292' 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-12-03 22:30:02' AND g.time<='2024-12-04 21:30:02' AND g.DeviceLoginName='354836080392292' GROUP BY  g.time, g.Distance;
CountAzimuth:2162
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 0:30:2' AND e.date<='2024-12-03 23:30:2' AND e.DeviceLoginName='354836080392292' 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-12-02 22:30:02' AND g.time<='2024-12-03 21:30:02' AND g.DeviceLoginName='354836080392292' GROUP BY  g.time, g.Distance;
CountAzimuth:1657
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 0:30:2' AND e.date<='2024-12-02 23:30:2' AND e.DeviceLoginName='354836080392292' 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-12-01 22:30:02' AND g.time<='2024-12-02 21:30:02' AND g.DeviceLoginName='354836080392292' GROUP BY  g.time, g.Distance;
CountAzimuth:1672
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-06 7:19:35' AND e.date<='2024-12-05 15:19:35' 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-12-06 05:19:35' AND g.time<='2024-12-05 13:19:35' AND g.DeviceLoginName='354836080167561' GROUP BY  g.time, g.Distance;
CountAzimuth:0
Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-11-01 4:12:7' AND e.date<='2024-11-01 23:12:7' AND e.DeviceLoginName='2849' 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-01 02:12:07' AND g.time<='2024-11-01 21:12:07' AND g.DeviceLoginName='2849' GROUP BY  g.time, g.Distance;
CountAzimuth:4402