Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 21:31:04' AND e.date<='2024-06-04 21:31:04' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 21:31:04' AND e.date<='2024-06-04 21:31:04' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-19 21:03:38' AND e.date<='2024-05-20 20:03:38' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-19 21:03:38' AND e.date<='2024-05-20 20:03:38' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-04 21:22:28' AND e.date<='2024-06-05 08:22:28' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-04 21:22:28' AND e.date<='2024-06-05 08:22:28' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-04 21:22:28' AND e.date<='2024-06-05 08:22:28' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-04 21:22:28' AND e.date<='2024-06-05 08:22:28' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-04 11:22:52' AND e.date<='2024-06-05 11:22:52' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-04 11:22:52' AND e.date<='2024-06-05 11:22:52' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2768' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-04 21:00:00' AND e.date<='2024-06-05 12:09:29' Method:GetStops; stop_time2024-06-05 04:15:34 Method:GetStops; stop_time2024-06-05 04:37:19 Method:GetStops; stop_time2024-06-05 04:46:19 Method:GetStops; stop_time2024-06-05 05:08:25 Method:GetStops; stop_time2024-06-05 05:49:57 Method:GetStops; stop_time2024-06-05 06:28:42 Method:GetStops; stop_time2024-06-05 06:47:12 Method:GetStops; stop_time2024-06-05 07:34:27 Method:GetStops; stop_time2024-06-05 07:45:42 Method:GetStops; stop_time2024-06-05 08:19:12 Method:GetStops; stop_time2024-06-05 08:43:12 Method:GetStops; stop_time2024-06-05 09:56:26 Method:GetStops; stop_time2024-06-05 10:12:41 Method:GetStops; stop_time2024-06-05 10:21:11 Method:GetStops; stop_time2024-06-05 10:47:11 Method:GetStops; stop_time2024-06-05 11:03:56 Method:GetStops; stop_time2024-06-05 11:25:26 Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118083027' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-04 12:21:19' AND e.date<='2024-06-05 12:21:19' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118083027' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-04 12:21:19' AND e.date<='2024-06-05 12:21:19' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-10 21:00:11' AND e.date<='2024-05-11 20:41:11' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-10 21:00:11' AND e.date<='2024-05-11 20:41:11' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-31 21:00:11' AND e.date<='2024-06-01 20:41:11' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-31 21:00:11' AND e.date<='2024-06-01 20:41:11' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-01 21:00:11' AND e.date<='2024-06-02 20:41:11' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-01 21:00:11' AND e.date<='2024-06-02 20:41:11' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-02 21:00:11' AND e.date<='2024-06-05 20:41:11' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-02 21:00:11' AND e.date<='2024-06-05 20:41:11'