Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083473444' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-27 22:24:53' AND e.date<='2024-11-28 21:24:53' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083473444' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-27 22:24:53' AND e.date<='2024-11-28 21:24:53' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118074109' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-24 22:25:37' AND e.date<='2024-11-25 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118074109' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-24 22:25:37' AND e.date<='2024-11-25 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2703' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-27 22:25:37' AND e.date<='2024-11-28 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2703' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-27 22:25:37' AND e.date<='2024-11-28 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-24 22:14:29' AND e.date<='2024-11-29 21:14:29' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-24 22:14:29' AND e.date<='2024-11-29 21:14:29' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-24 22:14:29' AND e.date<='2024-11-25 21:14:29' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-24 22:14:29' AND e.date<='2024-11-25 21:14:29' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-25 22:14:29' AND e.date<='2024-11-26 21:14:29' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-25 22:14:29' AND e.date<='2024-11-26 21:14:29' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-24 22:25:37' AND e.date<='2024-11-25 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-24 22:25:37' AND e.date<='2024-11-25 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-25 22:25:37' AND e.date<='2024-11-26 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-25 22:25:37' AND e.date<='2024-11-26 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-26 22:25:37' AND e.date<='2024-11-27 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-26 22:25:37' AND e.date<='2024-11-27 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-27 22:25:37' AND e.date<='2024-11-28 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-27 22:25:37' AND e.date<='2024-11-28 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-28 22:25:37' AND e.date<='2024-11-29 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-28 22:25:37' AND e.date<='2024-11-29 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 22:25:37' AND e.date<='2024-12-01 21:25:37' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3070' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 22:25:37' AND e.date<='2024-12-01 21:25:37' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116287711' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='356078116287711' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='4848' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='4848' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='2703' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='2703' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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-11-29 21:00:00' AND e.date<='2024-11-30 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-11-29 21:00:00' AND e.date<='2024-11-30 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='4959' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='4959' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='3132' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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='3132' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 21:00:00' AND e.date<='2024-11-30 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-11-29 21:00:00' AND e.date<='2024-11-30 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-11-29 21:00:00' AND e.date<='2024-11-30 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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='3184' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='3184' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='3114' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='3114' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='862531041079980' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='862531041079980' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='357804048849149' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='357804048849149' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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-11-30 21:00:00' AND e.date<='2024-12-01 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-11-30 21:00:00' AND e.date<='2024-12-01 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='4959' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='4959' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='2947' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='2947' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='2953' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='2953' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='3033' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='3033' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='2584' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='2584' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='4819' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='4819' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 21:00:00' AND e.date<='2024-12-01 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='4848' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='4848' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='356078116298288' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='356078116298288' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='864866053466610' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='864866053466610' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3090' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3090' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5080' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5080' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5129' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5129' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5076' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='5076' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2947' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2947' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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-12-01 21:00:00' AND e.date<='2024-12-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-12-01 21:00:00' AND e.date<='2024-12-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-12-01 21:00:00' AND e.date<='2024-12-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-12-01 21:00:00' AND e.date<='2024-12-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='2662' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2662' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3029' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3029' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3061' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='3061' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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-12-01 21:00:00' AND e.date<='2024-12-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-12-01 21:00:00' AND e.date<='2024-12-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='2867' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2867' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2707' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2707' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2602' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2602' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2888' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='2888' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 21:00:00' AND e.date<='2024-12-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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 00:12:41' AND e.date<='2024-11-30 21:12:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-30 00:12:41' AND e.date<='2024-11-30 21:12:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-12-01 02:14:18' AND e.date<='2024-12-01 21:14:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-12-01 02:14:18' AND e.date<='2024-12-01 21:14:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-12-02 02:14:35' AND e.date<='2024-12-02 09:14:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-12-02 02:14:35' AND e.date<='2024-12-02 09:14:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 09:15:05' AND e.date<='2024-12-01 18:15: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='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 09:15:05' AND e.date<='2024-12-01 18:15: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 06:15:28' AND e.date<='2024-12-01 21:15:28' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-12-01 06:15:28' AND e.date<='2024-12-01 21:15:28' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-26 22:24:12' AND e.date<='2024-11-27 21:24:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-26 22:24:12' AND e.date<='2024-11-27 21:24:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-27 22:24:12' AND e.date<='2024-11-28 21:24:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-27 22:24:12' AND e.date<='2024-11-28 21:24:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 22:24:12' AND e.date<='2024-11-30 21:24:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 22:24:12' AND e.date<='2024-11-30 21:24:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 22:24:12' AND e.date<='2024-12-01 21:24:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 22:24:12' AND e.date<='2024-12-01 21:24:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2948' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 22:40:26' AND e.date<='2024-11-30 21:40:26' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2948' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 22:40:26' AND e.date<='2024-11-30 21:40:26' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-12-01 22:16:06' AND e.date<='2024-12-02 11: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 22:16:06' AND e.date<='2024-12-02 11: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 23:17:00' AND e.date<='2024-12-01 21:17: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 23:17:00' AND e.date<='2024-12-01 21:17: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 02:46:17' AND e.date<='2024-12-02 11:46:17' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-12-02 02:46:17' AND e.date<='2024-12-02 11:46:17' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-12-02 05:53:24' AND e.date<='2024-12-02 11:53: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 05:53:24' AND e.date<='2024-12-02 11:53: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='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 02:02:44' AND e.date<='2024-12-01 21:02: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='3212' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 02:02:44' AND e.date<='2024-12-01 21:02: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='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 02:02:44' AND e.date<='2024-11-30 21:02: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='3212' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 02:02:44' AND e.date<='2024-11-30 21:02: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='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-02 02:02:44' AND e.date<='2024-12-02 21:02: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='3212' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-02 02:02:44' AND e.date<='2024-12-02 21:02: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='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-29 02:02:44' AND e.date<='2024-11-29 21:02: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='3212' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-29 02:02:44' AND e.date<='2024-11-29 21:02: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='3212' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 03:07:52' AND e.date<='2024-11-30 21:07:52' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-30 03:07:52' AND e.date<='2024-11-30 21:07:52' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3021' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-30 11:19:03' AND e.date<='2024-11-30 21:19:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3021' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-30 11:19:03' AND e.date<='2024-11-30 21:19:03' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-12-02 11:28:28' AND e.date<='2024-12-02 13:28:28' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-12-02 11:28:28' AND e.date<='2024-12-02 13:28:28'