Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 7:24:2' AND e.date<='2024-04-07 23:24:2' 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-04-06 04:24:02' AND g.time<='2024-04-07 20:24:02' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:616 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 7:25:3' AND e.date<='2024-04-08 7:25:3' 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-04-07 04:25:03' AND g.time<='2024-04-08 04:25:03' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:291 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 7:25:40' AND e.date<='2024-04-08 7:25:40' AND e.DeviceLoginName='358021081803706' 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-04-06 04:25:40' AND g.time<='2024-04-08 04:25:40' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:890 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 7:27:22' AND e.date<='2024-04-08 7:27:22' 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-04-06 04:27:22' AND g.time<='2024-04-08 04:27:22' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:6 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 7:27:40' AND e.date<='2024-04-08 7:27:40' AND e.DeviceLoginName='356078111301566' 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-04-06 04:27:40' AND g.time<='2024-04-08 04:27:40' AND g.DeviceLoginName='356078111301566' GROUP BY g.time, g.Distance; CountAzimuth:1794 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 7:28:46' AND e.date<='2024-04-08 7:28:46' AND e.DeviceLoginName='356078111301566' 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-04-06 04:28:46' AND g.time<='2024-04-08 04:28:46' AND g.DeviceLoginName='356078111301566' GROUP BY g.time, g.Distance; CountAzimuth:1794 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 0:1:3' AND e.date<='2024-04-05 23:1:3' AND e.DeviceLoginName='2473' 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-04-04 21:01:03' AND g.time<='2024-04-05 20:01:03' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:1849 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:2:58' AND e.date<='2024-04-06 23:2:58' AND e.DeviceLoginName='353173060485131' 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-04-05 21:02:58' AND g.time<='2024-04-06 20:02:58' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:443 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 0:2:58' AND e.date<='2024-04-05 23:2:58' AND e.DeviceLoginName='355234055304584' 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-04-04 21:02:58' AND g.time<='2024-04-05 20:02:58' AND g.DeviceLoginName='355234055304584' GROUP BY g.time, g.Distance; CountAzimuth:1581 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 0:2:58' AND e.date<='2024-04-05 23:2:58' AND e.DeviceLoginName='3179' 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-04-04 21:02:58' AND g.time<='2024-04-05 20:02:58' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:1486 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-04 0:2:58' AND e.date<='2024-04-04 23:2:58' AND e.DeviceLoginName='353173060485131' 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-04-03 21:02:58' AND g.time<='2024-04-04 20:02:58' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:925 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-04 0:2:58' AND e.date<='2024-04-04 23:2:58' AND e.DeviceLoginName='2652' 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-04-03 21:02:58' AND g.time<='2024-04-04 20:02:58' AND g.DeviceLoginName='2652' GROUP BY g.time, g.Distance; CountAzimuth:1952 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:2:58' AND e.date<='2024-04-06 23:2:58' AND e.DeviceLoginName='2652' 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-04-05 21:02:58' AND g.time<='2024-04-06 20:02:58' AND g.DeviceLoginName='2652' GROUP BY g.time, g.Distance; CountAzimuth:1788 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:2:58' AND e.date<='2024-04-01 23:2:58' AND e.DeviceLoginName='356078111293789' 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-03-31 21:02:58' AND g.time<='2024-04-01 20:02:58' AND g.DeviceLoginName='356078111293789' GROUP BY g.time, g.Distance; CountAzimuth:1649 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:0:0' AND e.date<='2024-04-06 23:59:59' AND e.DeviceLoginName='2724' 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-04-05 21:00:00' AND g.time<='2024-04-06 20:59:59' AND g.DeviceLoginName='2724' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:0:0' AND e.date<='2024-04-06 23:59:59' AND e.DeviceLoginName='8987' 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-04-05 21:00:00' AND g.time<='2024-04-06 20:59:59' AND g.DeviceLoginName='8987' GROUP BY g.time, g.Distance; CountAzimuth:1342 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-01 0:2:58' AND e.date<='2024-04-01 23:2:58' AND e.DeviceLoginName='352353086167548' 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-03-31 21:02:58' AND g.time<='2024-04-01 20:02:58' AND g.DeviceLoginName='352353086167548' GROUP BY g.time, g.Distance; CountAzimuth:1037 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:2:58' AND e.date<='2024-04-07 23:2:58' AND e.DeviceLoginName='352353086167548' 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-04-05 21:02:58' AND g.time<='2024-04-07 20:02:58' AND g.DeviceLoginName='352353086167548' GROUP BY g.time, g.Distance; CountAzimuth:2615 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:150 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='862531041078313' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:18 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:213 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='2898' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='2898' GROUP BY g.time, g.Distance; CountAzimuth:46 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='2652' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='2652' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='3154' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='3154' GROUP BY g.time, g.Distance; CountAzimuth:62 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='352353084209250' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='352353084209250' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:356 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='4966' GROUP BY g.time, g.Distance; CountAzimuth:40 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='3081' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='3081' GROUP BY g.time, g.Distance; CountAzimuth:91 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='2703' GROUP BY g.time, g.Distance; CountAzimuth:25 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:32 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:142 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='2585' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='2585' GROUP BY g.time, g.Distance; CountAzimuth:43 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='3179' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:49 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='353173060497698' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='356078111326001' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='356078111326001' GROUP BY g.time, g.Distance; CountAzimuth:75 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 5:0:0' AND e.DeviceLoginName='3197' 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-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:21 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-05 23:0:0' AND e.date<='2024-04-06 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-05 20:00:00' AND g.time<='2024-04-06 02:00:00' AND g.DeviceLoginName='2964' GROUP BY g.time, g.Distance; CountAzimuth:63 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='862531041078313' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='862531041078313' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:39 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='4964' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='4964' GROUP BY g.time, g.Distance; CountAzimuth:166 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:211 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='2883' GROUP BY g.time, g.Distance; CountAzimuth:88 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='2876' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='2876' GROUP BY g.time, g.Distance; CountAzimuth:28 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='2585' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='2585' GROUP BY g.time, g.Distance; CountAzimuth:24 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='3179' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:102 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='8983' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='8983' GROUP BY g.time, g.Distance; CountAzimuth:163 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='5132' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='5132' GROUP BY g.time, g.Distance; CountAzimuth:190 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='2630' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:56 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 23:0:0' AND e.date<='2024-04-07 5:0:0' AND e.DeviceLoginName='4865' 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-04-06 20:00:00' AND g.time<='2024-04-07 02:00:00' AND g.DeviceLoginName='4865' GROUP BY g.time, g.Distance; CountAzimuth:51 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:86 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='3161' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='3161' GROUP BY g.time, g.Distance; CountAzimuth:85 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:177 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='353173060487970' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='353173060487970' GROUP BY g.time, g.Distance; CountAzimuth:92 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:222 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='3124' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='3124' GROUP BY g.time, g.Distance; CountAzimuth:106 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='3179' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='3179' GROUP BY g.time, g.Distance; CountAzimuth:119 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 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 3:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:157 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='2735' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='2735' GROUP BY g.time, g.Distance; CountAzimuth:25 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='2550' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='2550' GROUP BY g.time, g.Distance; CountAzimuth:208 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='2630' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='2630' GROUP BY g.time, g.Distance; CountAzimuth:52 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 23:0:0' AND e.date<='2024-04-08 5:0:0' AND e.DeviceLoginName='4967' 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-04-07 20:00:00' AND g.time<='2024-04-08 02:00:00' AND g.DeviceLoginName='4967' GROUP BY g.time, g.Distance; CountAzimuth:249 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-06 0:35:2' AND e.date<='2024-04-06 23:35:2' AND e.DeviceLoginName='8987' 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-04-05 21:35:02' AND g.time<='2024-04-06 20:35:02' AND g.DeviceLoginName='8987' GROUP BY g.time, g.Distance; CountAzimuth:1342 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-07 0:35:2' AND e.date<='2024-04-07 23:35:2' AND e.DeviceLoginName='8987' 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-04-06 21:35:02' AND g.time<='2024-04-07 20:35:02' AND g.DeviceLoginName='8987' GROUP BY g.time, g.Distance; CountAzimuth:1343 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 4:4:1' AND e.date<='2024-04-08 15:4:1' AND e.DeviceLoginName='2473' 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-04-08 01:04:01' AND g.time<='2024-04-08 12:04:01' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:1058 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 9:12:40' AND e.date<='2024-04-08 15:12:40' AND e.DeviceLoginName='2473' 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-04-08 06:12:40' AND g.time<='2024-04-08 12:12:40' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:722 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 7:30:54' AND e.date<='2024-04-08 15:30:54' 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-04-08 04:30:54' AND g.time<='2024-04-08 12:30:54' AND g.DeviceLoginName='352353083458635' GROUP BY g.time, g.Distance; CountAzimuth:1 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 6:31:7' AND e.date<='2024-04-08 15:31:7' AND e.DeviceLoginName='2473' 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-04-08 03:31:07' AND g.time<='2024-04-08 12:31:07' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:1069 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-04-08 5:35:26' AND e.date<='2024-04-08 15:35:26' AND e.DeviceLoginName='2473' 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-04-08 02:35:26' AND g.time<='2024-04-08 12:35:26' AND g.DeviceLoginName='2473' GROUP BY g.time, g.Distance; CountAzimuth:1069 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-26 0:36:44' AND e.date<='2024-04-08 23:36:44' AND e.DeviceLoginName='3152' 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-03-25 21:36:44' AND g.time<='2024-04-08 20:36:44' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:532 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-01 0:36:44' AND e.date<='2024-03-26 23:36:44' AND e.DeviceLoginName='3152' 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-02-29 21:36:44' AND g.time<='2024-03-26 20:36:44' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:540 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-20 10:0:0' AND e.date<='2024-01-20 11:0:0' AND e.DeviceLoginName='3152' 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-01-20 07:00:00' AND g.time<='2024-01-20 08:00:00' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-20 0:0:0' AND e.date<='2024-01-20 23:0:0' AND e.DeviceLoginName='3152' 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-01-19 21:00:00' AND g.time<='2024-01-20 20:00:00' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:2097 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-19 17:0:0' AND e.date<='2024-01-20 23:0:0' AND e.DeviceLoginName='3152' 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-01-19 14:00:00' AND g.time<='2024-01-20 20:00:00' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:2097 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-19 11:0:0' AND e.date<='2024-01-20 23:0:0' AND e.DeviceLoginName='3152' 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-01-19 08:00:00' AND g.time<='2024-01-20 20:00:00' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:2097 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-01-18 11:0:0' AND e.date<='2024-01-20 23:0:0' AND e.DeviceLoginName='3152' 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-01-18 08:00:00' AND g.time<='2024-01-20 20:00:00' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:4724 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-26 9:1:37' AND e.date<='2024-04-08 17:1:37' AND e.DeviceLoginName='3152' 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-03-26 06:01:37' AND g.time<='2024-04-08 14:01:37' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:532 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-03-26 5:13:46' AND e.date<='2024-03-26 23:13:46' AND e.DeviceLoginName='3152' 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-03-26 02:13:46' AND g.time<='2024-03-26 20:13:46' AND g.DeviceLoginName='3152' GROUP BY g.time, g.Distance; CountAzimuth:532