Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-21 21:58:31' AND e.date<='2024-04-22 20:58:31' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-21 21:58:31' AND e.date<='2024-04-22 20:58:31' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-02-25 21:51:50' AND e.date<='2024-02-26 20:51:50' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-02-25 21:51:50' AND e.date<='2024-02-26 20:51:50' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-02-26 21:51:50' AND e.date<='2024-02-27 20:51:50' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-02-26 21:51:50' AND e.date<='2024-02-27 20:51:50' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-02-26 21:12:12' AND e.date<='2024-02-27 20:12:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-02-26 21:12:12' AND e.date<='2024-02-27 20:12:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-03-06 21:12:12' AND e.date<='2024-03-07 20:12:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-03-06 21:12:12' AND e.date<='2024-03-07 20:12:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-03-20 21:12:12' AND e.date<='2024-03-21 20:12:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-03-20 21:12:12' AND e.date<='2024-03-21 20:12:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-03-24 21:12:12' AND e.date<='2024-03-25 20:12:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-03-24 21:12:12' AND e.date<='2024-03-25 20:12:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-03-25 21:12:12' AND e.date<='2024-03-26 20:12:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-03-25 21:12:12' AND e.date<='2024-03-26 20:12:12' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-03-28 21:12:12' AND e.date<='2024-03-29 20:12:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-03-28 21:12:12' AND e.date<='2024-03-29 20:12:12'