Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085630389' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 02:00:37' AND e.date<='2024-04-29 20:00:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085630389' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 02:00:37' AND e.date<='2024-04-29 20:00:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085630389' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 06:29:24' AND e.date<='2024-04-29 09:29:24' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085630389' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 06:29:24' AND e.date<='2024-04-29 09:29:24' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2530' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2530' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='8997' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='8997' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='4962' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='4962' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2974' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2974' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='3263' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='3263' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2773' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='2773' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='3156' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='3156' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-29 20:00:00' AND e.date<='2024-04-30 02:00: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='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='4848' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='4848' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3212' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='4962' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='4962' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='5080' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='5080' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3263' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3263' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2773' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2773' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2904' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2904' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3156' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='3156' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2878' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='2878' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 20:00:00' AND e.date<='2024-05-01 02:00: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='9010' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='9010' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='862531041078313' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='862531041078313' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3203' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3203' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='4962' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='4962' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2566' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2566' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2543' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2543' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2883' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2883' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3263' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3263' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3091' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3091' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2773' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2773' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='2726' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3197' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='3197' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-01 20:00:00' AND e.date<='2024-05-02 02:00: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='9010' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='9010' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='8997' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='8997' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='3079' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='3079' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2883' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2883' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2553' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2553' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='352353084234167' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='352353084234167' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='3263' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='3263' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2773' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2773' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2528' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2528' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='8983' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='8983' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2676' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='2676' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-02 20:00:00' AND e.date<='2024-05-03 02:00: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='4865' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-08 09:15:47' AND e.date<='2024-04-08 17:25:47' 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-04-08 09:15:47' AND e.date<='2024-04-08 17:25:47' 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-04-08 09:15:47' AND e.date<='2024-04-08 09:25:47' 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-04-08 09:15:47' AND e.date<='2024-04-08 09:25:47'