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-02 21:12:10' AND e.date<='2024-06-03 21:12:10' 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-02 21:12:10' AND e.date<='2024-06-03 21:12:10' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 03:52:45' AND e.date<='2024-06-03 06:52:45' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 03:52:45' AND e.date<='2024-06-03 06:52:45' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 01:53:34' AND e.date<='2024-06-03 04:53:34' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 01:53:34' AND e.date<='2024-06-03 04:53:34' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 05:23:20' AND e.date<='2024-06-03 06:54:20' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 05:23:20' AND e.date<='2024-06-03 06:54:20' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 06:56:11' AND e.date<='2024-06-03 09:56: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='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 06:56:11' AND e.date<='2024-06-03 09:56: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='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 09:57:34' AND e.date<='2024-06-03 12:57:34' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 09:57:34' AND e.date<='2024-06-03 12:57:34' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 11:58:15' AND e.date<='2024-06-03 17:58:15' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 11:58:15' AND e.date<='2024-06-03 17:58:15' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 16:59:43' AND e.date<='2024-06-03 20:59:43' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 16:59:43' AND e.date<='2024-06-03 20:59:43' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='9005' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 21:00:00' AND e.date<='2024-06-04 06:07:02' Method:GetStops; stop_time2024-06-04 05:17:55 Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9005' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-26 21:04:49' AND e.date<='2024-05-31 20:04:49' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9005' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-26 21:04:49' AND e.date<='2024-05-31 20:04:49' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-01 21:43:57' AND e.date<='2024-06-02 20:43:57' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-01 21:43:57' AND e.date<='2024-06-02 20:43:57' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-31 21:45:25' AND e.date<='2024-06-01 20:45:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-31 21:45:25' AND e.date<='2024-06-01 20:45:25' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-03 21:34:20' AND e.date<='2024-06-04 10:34:20' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-03 21:34:20' AND e.date<='2024-06-04 10:34:20' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-06 19:58:03' AND e.date<='2024-05-06 20:43:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3212' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-06 19:58:03' AND e.date<='2024-05-06 20:43:03' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 19:58:03' AND e.date<='2024-05-14 20:43:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3212' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 19:58:03' AND e.date<='2024-05-14 20:43:03' 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-16 21:08:48' AND e.date<='2024-05-23 12:08:48' 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-16 21:08:48' AND e.date<='2024-05-23 12:08:48' 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:08:48' AND e.date<='2024-05-20 12:08:48' 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:08:48' AND e.date<='2024-05-20 12:08:48' 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-18 21:08:48' AND e.date<='2024-05-21 12:08:48' 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-18 21:08:48' AND e.date<='2024-05-21 12:08:48' 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:08:48' AND e.date<='2024-05-20 20:08:48' 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:08:48' AND e.date<='2024-05-20 20:08:48' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-21 20:00:00' AND e.date<='2024-05-22 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-21 20:00:00' AND e.date<='2024-05-22 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3032' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-27 13:22:55' AND e.date<='2024-06-04 13:22:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3032' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-27 13:22:55' AND e.date<='2024-06-04 13:22:55'