Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2504' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-07 21:34:49' AND e.date<='2024-04-08 20:34:49' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2504' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-07 21:34:49' AND e.date<='2024-04-08 20:34:49' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-07 21:36:32' AND e.date<='2024-04-08 20:36:32' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-07 21:36:32' AND e.date<='2024-04-08 20:36:32' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2752' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-07 21:54:44' AND e.date<='2024-04-08 20:54:44' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2752' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-07 21:54:44' AND e.date<='2024-04-08 20:54:44' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2962' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-07 21:55:53' AND e.date<='2024-04-08 20:55:53' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2962' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-07 21:55:53' AND e.date<='2024-04-08 20:55:53' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-31 21:41:08' AND e.date<='2024-04-01 20:41:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-31 21:41:08' AND e.date<='2024-04-01 20:41:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-01 21:41:08' AND e.date<='2024-04-02 20:41:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-01 21:41:08' AND e.date<='2024-04-02 20:41:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-02 21:41:08' AND e.date<='2024-04-03 20:41:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-02 21:41:08' AND e.date<='2024-04-03 20:41:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-03 21:41:08' AND e.date<='2024-04-04 20:41:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-03 21:41:08' AND e.date<='2024-04-04 20:41:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-04 21:41:08' AND e.date<='2024-04-05 20:41:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-04 21:41:08' AND e.date<='2024-04-05 20:41:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-04-01 21:52:03' AND e.date<='2024-04-02 20:52:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-04-01 21:52:03' AND e.date<='2024-04-02 20:52:03' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-03-28 21:52:03' AND e.date<='2024-04-02 20:52:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-03-28 21:52:03' AND e.date<='2024-04-02 20:52:03'