Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-17 22:12:47' AND e.date<='2024-10-18 21:12:47' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-17 22:12:47' AND e.date<='2024-10-18 21:12:47' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-23 22:14:48' AND e.date<='2024-10-24 21:14:48' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-23 22:14:48' AND e.date<='2024-10-24 21:14:48' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 22:16:06' AND e.date<='2024-10-23 21:16:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 22:16:06' AND e.date<='2024-10-23 21:16:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 22:17:05' AND e.date<='2024-10-22 21:17:05' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 22:17:05' AND e.date<='2024-10-22 21:17:05' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 22:18:13' AND e.date<='2024-10-21 21:18:13' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 22:18:13' AND e.date<='2024-10-21 21:18:13' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-17 22:19:02' AND e.date<='2024-10-18 21:19:02' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-17 22:19:02' AND e.date<='2024-10-18 21:19:02' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-16 22:20:23' AND e.date<='2024-10-17 21:20:23' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-16 22:20:23' AND e.date<='2024-10-17 21:20:23' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-15 22:21:20' AND e.date<='2024-10-16 21:21:20' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-15 22:21:20' AND e.date<='2024-10-16 21:21:20' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-14 22:22:40' AND e.date<='2024-10-15 21:22:40' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-14 22:22:40' AND e.date<='2024-10-15 21:22:40' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-13 22:23:47' AND e.date<='2024-10-14 21:23:47' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2749' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-13 22:23:47' AND e.date<='2024-10-14 21:23:47'