Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3123' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3123' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2913' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2913' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3238' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3238' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2470' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3020' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3020' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8983' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8983' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2495' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2495' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-01 21:00:00' AND e.date<='2024-01-02 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041078313' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041078313' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3188' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3188' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5132' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5132' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116277977' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116277977' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3197' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3197' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-02 21:00:00' AND e.date<='2024-01-03 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2769' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2769' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5078' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3166' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3166' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2662' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2662' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2674' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2674' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-03 21:00:00' AND e.date<='2024-01-04 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3059' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3059' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2725' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2725' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8993' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8993' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='864866053465679' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='864866053465679' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055578880' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055578880' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-04 21:00:00' AND e.date<='2024-01-05 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5135' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5135' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2949' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2949' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8991' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8991' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081932786' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081932786' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4868' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4868' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2599' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2599' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3187' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-05 21:00:00' AND e.date<='2024-01-06 03:00:00'