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-05 22:00:00' AND g.time<='2024-12-06 07:18:50' AND g.DeviceLoginName='352353083463817' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 05:08:49' AND TIME<='2024-12-06 05:18:49' AND DeviceLoginName='352353083463817' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 05:39:22' AND TIME<='2024-12-06 05:49:22' AND DeviceLoginName='352353083463817' AND speed=0 Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083463817' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 22:00:00' AND e.date<='2024-12-06 07:18:50' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 05:08:49' AND TIME<='2024-12-06 05:18:49' AND DeviceLoginName='352353083463817' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 05:39:22' AND TIME<='2024-12-06 05:49:22' AND DeviceLoginName='352353083463817' 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-12-05 22:00:00' AND g.time<='2024-12-06 07:19:25' AND g.DeviceLoginName='2829' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-05 22:33:12' AND TIME<='2024-12-05 22:43:12' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-05 22:46:07' AND TIME<='2024-12-05 22:56:07' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 02:14:02' AND TIME<='2024-12-06 02:24:02' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 02:29:02' AND TIME<='2024-12-06 02:39:02' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 06:18:23' AND TIME<='2024-12-06 06:28:23' AND DeviceLoginName='2829' AND speed=0 Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 22:00:00' AND e.date<='2024-12-06 07:19:25' Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-05 22:33:12' AND TIME<='2024-12-05 22:43:12' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-05 22:46:07' AND TIME<='2024-12-05 22:56:07' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 02:14:02' AND TIME<='2024-12-06 02:24:02' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 02:29:02' AND TIME<='2024-12-06 02:39:02' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 05:44:49' AND TIME<='2024-12-06 05:54:49' AND DeviceLoginName='2829' AND speed=0 Method:GetStopsCoord; Query:SELECT latitude,longitude,time FROM tms_gpsdata_fixed WHERE TIME>='2024-12-06 06:18:23' AND TIME<='2024-12-06 06:28:23' AND DeviceLoginName='2829' AND speed=0 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 9:51:36' AND e.date<='2024-12-06 9:51:36' AND e.DeviceLoginName='2684' 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 07:51:36' AND g.time<='2024-12-06 07:51:36' AND g.DeviceLoginName='2684' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='3075' GROUP BY g.time, g.Distance; CountAzimuth:63 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:60 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='354836080152241' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='354836080152241' GROUP BY g.time, g.Distance; CountAzimuth:23 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='2677' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='2677' GROUP BY g.time, g.Distance; CountAzimuth:71 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:90 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:122 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='3124' GROUP BY g.time, g.Distance; CountAzimuth:111 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:136 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='3092' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='3092' GROUP BY g.time, g.Distance; CountAzimuth:47 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:198 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='2504' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='2504' GROUP BY g.time, g.Distance; CountAzimuth:65 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='3061' GROUP BY g.time, g.Distance; CountAzimuth:323 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 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-12-02 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:118 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='352353086185623' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='352353086185623' GROUP BY g.time, g.Distance; CountAzimuth:10 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='2627' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='2627' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='2752' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='2752' GROUP BY g.time, g.Distance; CountAzimuth:52 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 23:0:0' AND e.date<='2024-12-03 5:0:0' AND e.DeviceLoginName='4819' 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 21:00:00' AND g.time<='2024-12-03 03:00:00' AND g.DeviceLoginName='4819' GROUP BY g.time, g.Distance; CountAzimuth:145 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='353173060485131' GROUP BY g.time, g.Distance; CountAzimuth:42 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='3108' GROUP BY g.time, g.Distance; CountAzimuth:71 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='3064' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='3064' GROUP BY g.time, g.Distance; CountAzimuth:196 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:192 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='356078111430837' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='356078111430837' GROUP BY g.time, g.Distance; CountAzimuth:5 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='2535' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='2535' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='2876' GROUP BY g.time, g.Distance; CountAzimuth:187 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:62 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='2500' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='2500' GROUP BY g.time, g.Distance; CountAzimuth:48 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='3030' GROUP BY g.time, g.Distance; CountAzimuth:566 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:419 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='3092' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='3092' GROUP BY g.time, g.Distance; CountAzimuth:25 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:181 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='3061' GROUP BY g.time, g.Distance; CountAzimuth:332 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='356078111279820' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='356078111279820' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5: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-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='2948' GROUP BY g.time, g.Distance; CountAzimuth:12 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='2707' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='2707' GROUP BY g.time, g.Distance; CountAzimuth:72 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 5:0:0' AND e.DeviceLoginName='2526' 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 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='2526' GROUP BY g.time, g.Distance; CountAzimuth:30 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-03 23:0:0' AND e.date<='2024-12-04 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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-03 21:00:00' AND g.time<='2024-12-04 03:00:00' AND g.DeviceLoginName='3197' GROUP BY g.time, g.Distance; CountAzimuth:26 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='356078116287711' GROUP BY g.time, g.Distance; CountAzimuth:14 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03: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-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='9011' GROUP BY g.time, g.Distance; CountAzimuth:122 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 5:0:0' AND e.DeviceLoginName='4848' 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 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='4848' GROUP BY g.time, g.Distance; CountAzimuth:232 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 5:0:0' AND e.DeviceLoginName='2686' 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 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='2686' GROUP BY g.time, g.Distance; CountAzimuth:231 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='862531041050148' GROUP BY g.time, g.Distance; CountAzimuth:753 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='4861' GROUP BY g.time, g.Distance; CountAzimuth:113 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='2470' GROUP BY g.time, g.Distance; CountAzimuth:24 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 5:0:0' AND e.DeviceLoginName='2662' 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 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='2662' GROUP BY g.time, g.Distance; CountAzimuth:48 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:292 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:225 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='2499' GROUP BY g.time, g.Distance; CountAzimuth:24 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 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-12-04 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='2584' GROUP BY g.time, g.Distance; CountAzimuth:7 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 5:0:0' AND e.DeviceLoginName='3172' 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 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='3172' GROUP BY g.time, g.Distance; CountAzimuth:11 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-04 23:0:0' AND e.date<='2024-12-05 5:0:0' AND e.DeviceLoginName='4819' 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 21:00:00' AND g.time<='2024-12-05 03:00:00' AND g.DeviceLoginName='4819' GROUP BY g.time, g.Distance; CountAzimuth:95 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='9010' GROUP BY g.time, g.Distance; CountAzimuth:362 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 5:0:0' AND e.DeviceLoginName='4848' 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 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='4848' GROUP BY g.time, g.Distance; CountAzimuth:103 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 5:0:0' AND e.DeviceLoginName='5131' 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 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='5131' GROUP BY g.time, g.Distance; CountAzimuth:272 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='4849' GROUP BY g.time, g.Distance; CountAzimuth:197 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='5117' GROUP BY g.time, g.Distance; CountAzimuth:88 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 5:0:0' AND e.DeviceLoginName='2513' 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 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='2513' GROUP BY g.time, g.Distance; CountAzimuth:92 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 5:0:0' AND e.DeviceLoginName='2665' 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 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='2665' GROUP BY g.time, g.Distance; CountAzimuth:192 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 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-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='2866' GROUP BY g.time, g.Distance; CountAzimuth:484 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 5:0:0' AND e.DeviceLoginName='3092' 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 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='3092' GROUP BY g.time, g.Distance; CountAzimuth:94 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 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-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='4862' GROUP BY g.time, g.Distance; CountAzimuth:3 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 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-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='3061' GROUP BY g.time, g.Distance; CountAzimuth:219 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 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-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:55 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-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 2:0:0'),g.speed,g.altitude,g.Distance FROM tms_gpsdata_fixed g WHERE g.time>='2024-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='353173060497698' GROUP BY g.time, g.Distance; CountAzimuth:28 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 5:0:0' AND e.DeviceLoginName='2627' 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 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='2627' GROUP BY g.time, g.Distance; CountAzimuth:152 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 5:0:0' AND e.DeviceLoginName='4819' 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 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='4819' GROUP BY g.time, g.Distance; CountAzimuth:427 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 23:0:0' AND e.date<='2024-12-06 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-12-05 21:00:00' AND g.time<='2024-12-06 03:00:00' AND g.DeviceLoginName='3156' GROUP BY g.time, g.Distance; CountAzimuth:55 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 11:13:32' AND e.date<='2024-12-05 23:13:32' 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 09:13:32' AND g.time<='2024-12-05 21:13:32' AND g.DeviceLoginName='2556' GROUP BY g.time, g.Distance; CountAzimuth:146 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 11:14:49' AND e.date<='2024-12-05 23:14:49' 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-12-05 09:14:49' AND g.time<='2024-12-05 21:14:49' AND g.DeviceLoginName='356078116278207' GROUP BY g.time, g.Distance; CountAzimuth:1465 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 11:15:32' AND e.date<='2024-12-05 23:15:32' 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-05 09:15:32' AND g.time<='2024-12-05 21:15:32' AND g.DeviceLoginName='354836080167561' GROUP BY g.time, g.Distance; CountAzimuth:708 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-05 11:15:55' AND e.date<='2024-12-05 23:15:55' AND e.DeviceLoginName='358021081803706' 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 09:15:55' AND g.time<='2024-12-05 21:15:55' AND g.DeviceLoginName='358021081803706' GROUP BY g.time, g.Distance; CountAzimuth:951 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-02 0:59:33' AND e.date<='2024-12-05 12:59:33' AND e.DeviceLoginName='3136' 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:59:33' AND g.time<='2024-12-05 10:59:33' AND g.DeviceLoginName='3136' GROUP BY g.time, g.Distance; CountAzimuth:1017 Method:GetCountStops; Query:SELECT COUNT(e.id) FROM tms_events e WHERE e.date>='2024-12-01 0:59:33' AND e.date<='2024-12-01 23:59:33' AND e.DeviceLoginName='9378' 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-30 22:59:33' AND g.time<='2024-12-01 21:59:33' AND g.DeviceLoginName='9378' GROUP BY g.time, g.Distance; CountAzimuth:67