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-04-23 21:49:29' AND e.date<='2024-04-24 04:49:29' 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-04-23 21:49:29' AND e.date<='2024-04-24 04:49:29' 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-04-23 21:04:21' AND e.date<='2024-04-24 05:04:21' 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-04-23 21:04:21' AND e.date<='2024-04-24 05:04:21' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-18 21:31:57' AND e.date<='2024-04-19 20:31: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='352353084656807' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-18 21:31:57' AND e.date<='2024-04-19 20:31: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='2962' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-18 21:36:27' AND e.date<='2024-04-19 20:36:27' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2962' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-18 21:36:27' AND e.date<='2024-04-19 20:36:27' 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-04-23 21:33:39' AND e.date<='2024-04-24 07:33:39' 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-04-23 21:33:39' AND e.date<='2024-04-24 07:33:39' 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-04-23 21:05:23' AND e.date<='2024-04-24 08:05:23' 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-04-23 21:05:23' AND e.date<='2024-04-24 08:05:23' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:16:28' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:16:41' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:17:06' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353086184048' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:17:27' Method:GetStops; stop_time2024-04-24 04:45:53 Method:GetStops; stop_time2024-04-24 05:18:24 Method:GetStops; stop_time2024-04-24 06:51:59 Method:GetStops; stop_time2024-04-24 07:25:14 Method:GetStops; stop_time2024-04-24 07:56:55 Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:17: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='3044' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-22 21:17:56' AND e.date<='2024-04-23 20:17:56' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-22 21:17:56' AND e.date<='2024-04-23 20:17:56' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:18:37' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3044' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-23 21:00:00' AND e.date<='2024-04-24 08:19:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3081' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-20 21:43:07' AND e.date<='2024-04-21 20:43:07' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3081' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-20 21:43:07' AND e.date<='2024-04-21 20:43:07' 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-04-23 22:09:08' AND e.date<='2024-04-24 09:09:08' 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-04-23 22:09:08' AND e.date<='2024-04-24 09:09:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3122' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-22 21:46:48' AND e.date<='2024-04-23 20:46: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='3122' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-22 21:46:48' AND e.date<='2024-04-23 20:46: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='3122' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-21 21:50:09' AND e.date<='2024-04-22 20:50:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3122' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-21 21:50:09' AND e.date<='2024-04-22 20:50:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-24 05:03:57' AND e.date<='2024-04-24 12:03: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='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-24 05:03:57' AND e.date<='2024-04-24 12:03: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='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-24 07:36:22' AND e.date<='2024-04-24 12:36:22' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-24 07:36:22' AND e.date<='2024-04-24 12:36:22'