Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2912' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-28 06:37:24' AND e.date<='2024-10-30 06:37:24' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2912' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-28 06:37:24' AND e.date<='2024-10-30 06:37:24' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-10-29 08:04:01' AND e.date<='2024-10-30 08:04:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-10-29 08:04:01' AND e.date<='2024-10-30 08:04:01' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-10-27 22:04:01' AND e.date<='2024-10-28 21:04:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-10-27 22:04:01' AND e.date<='2024-10-28 21:04:01' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-10-28 22:04:01' AND e.date<='2024-10-29 21:04:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-10-28 22:04:01' AND e.date<='2024-10-29 21:04:01' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-10-20 22:04:01' AND e.date<='2024-10-21 21:04:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-10-20 22:04:01' AND e.date<='2024-10-21 21:04:01' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-10-21 22:04:01' AND e.date<='2024-10-22 21:04:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-10-21 22:04:01' AND e.date<='2024-10-22 21:04:01' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-10-21 22:04:01' AND e.date<='2024-10-23 21:04:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-10-21 22:04:01' AND e.date<='2024-10-23 21:04:01' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9020' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-18 22:00:45' AND e.date<='2024-10-19 21:00:45' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9020' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-18 22:00:45' AND e.date<='2024-10-19 21:00:45' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9020' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 22:00:45' AND e.date<='2024-10-21 21:00:45' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9020' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 22:00:45' AND e.date<='2024-10-21 21:00:45' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-29 10:57:44' AND e.date<='2024-10-30 10:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-29 10:57:44' AND e.date<='2024-10-30 10:57:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-20 22:57:44' AND e.date<='2024-10-21 21:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-20 22:57:44' AND e.date<='2024-10-21 21:57:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-21 22:57:44' AND e.date<='2024-10-22 21:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-21 22:57:44' AND e.date<='2024-10-22 21:57:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-22 22:57:44' AND e.date<='2024-10-23 21:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-22 22:57:44' AND e.date<='2024-10-23 21:57:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 22:57:44' AND e.date<='2024-10-01 21:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 22:57:44' AND e.date<='2024-10-01 21:57:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 22:57:44' AND e.date<='2024-10-02 21:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 22:57:44' AND e.date<='2024-10-02 21:57:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 22:57:44' AND e.date<='2024-10-03 21:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 22:57:44' AND e.date<='2024-10-03 21:57:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 22:57:44' AND e.date<='2024-10-04 21:57:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 22:57:44' AND e.date<='2024-10-04 21:57:44'