Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='356078116474665' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 21:00:00' AND e.date<='2024-05-14 05:54:11' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3206' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 21:00:00' AND e.date<='2024-05-14 05:55:40' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086131585' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-28 21:31:06' AND e.date<='2024-05-12 20:31:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086131585' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-28 21:31:06' AND e.date<='2024-05-12 20:31:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI5164' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-23 21:31:06' AND e.date<='2024-05-24 20:31:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI5164' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-23 21:31:06' AND e.date<='2024-05-24 20:31:06' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 21:00:00' AND e.date<='2024-05-14 07:34:15' Method:GetStops; stop_time2024-05-14 05:18:22 Method:GetStops; stop_time2024-05-14 06:39:05 Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI5164' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-09 21:31:06' AND e.date<='2024-05-10 20:31:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI5164' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-09 21:31:06' AND e.date<='2024-05-10 20:31:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080091142' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-09 21:31:06' AND e.date<='2024-05-10 20:31:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080091142' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-09 21:31:06' AND e.date<='2024-05-10 20:31:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3068' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-05 21:36:46' AND e.date<='2024-05-10 20:36:46' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3068' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-05 21:36:46' AND e.date<='2024-05-10 20:36:46' 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-13 21:17:52' AND e.date<='2024-05-14 08:17: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 21:17:52' AND e.date<='2024-05-14 08:17:52' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 22:19:27' AND e.date<='2024-05-14 08:19: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 22:19:27' AND e.date<='2024-05-14 08:19:27' 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-05-13 21:00:00' AND e.date<='2024-05-14 11:10:31' Method:GetStops; stop_time2024-05-14 10:36: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='356078111301566' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 22:23:09' AND e.date<='2024-05-14 11:23: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='356078111301566' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 22:23:09' AND e.date<='2024-05-14 11:23: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 21:46:34' AND e.date<='2024-05-14 11:46: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 21:46:34' AND e.date<='2024-05-14 11:46: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='2516' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 02:47:00' AND e.date<='2024-05-14 11:47: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='2516' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 02:47:00' AND e.date<='2024-05-14 11:47: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 21:07:51' AND e.date<='2024-05-14 12:07:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 21:07:51' AND e.date<='2024-05-14 12:07:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4865' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-13 12:14:03' AND e.date<='2024-05-14 12:14: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='4865' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-13 12:14:03' AND e.date<='2024-05-14 12:14: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-12 21:44:11' AND e.date<='2024-05-13 20:44: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='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-12 21:44:11' AND e.date<='2024-05-13 20:44: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='2516' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-14 03:56:29' AND e.date<='2024-05-14 12:56: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='2516' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-14 03:56:29' AND e.date<='2024-05-14 12:56:29'