Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:00:53' AND e.date<='2024-07-03 06:00: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='3186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:00:53' AND e.date<='2024-07-03 06:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-23 21:00:53' AND e.date<='2024-06-28 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-23 21:00:53' AND e.date<='2024-06-28 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-24 21:14:24' AND e.date<='2024-06-25 20:14: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-24 21:14:24' AND e.date<='2024-06-25 20:14: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-25 21:14:24' AND e.date<='2024-06-26 20:14: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-25 21:14:24' AND e.date<='2024-06-26 20:14: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-26 21:14:24' AND e.date<='2024-06-27 20:14: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-26 21:14:24' AND e.date<='2024-06-27 20:14: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-27 21:14:24' AND e.date<='2024-06-28 20:14: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-27 21:14:24' AND e.date<='2024-06-28 20:14: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-23 21:14:24' AND e.date<='2024-06-24 20:14: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-23 21:14:24' AND e.date<='2024-06-24 20:14: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:14:24' AND e.date<='2024-07-03 20:14: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:14:24' AND e.date<='2024-07-03 20:14: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='352353086167449' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 21:18:41' AND e.date<='2024-06-30 20:18:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086167449' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 21:18:41' AND e.date<='2024-06-30 20:18:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055747170' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 21:37:06' AND e.date<='2024-07-07 20:37:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055747170' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 21:37:06' AND e.date<='2024-07-07 20:37:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 21:37:06' AND e.date<='2024-07-07 20:37:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 21:37:06' AND e.date<='2024-07-07 20:37:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 21:37:06' AND e.date<='2024-06-30 20:37:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 21:37:06' AND e.date<='2024-06-30 20:37:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-21 21:37:06' AND e.date<='2024-06-23 20:37:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-21 21:37:06' AND e.date<='2024-06-23 20:37:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 21:37:06' AND e.date<='2024-06-30 20:37:06' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9374' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 21:37:06' AND e.date<='2024-06-30 20:37:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-31 21:26:33' AND e.date<='2024-06-02 20:26:33' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-31 21:26:33' AND e.date<='2024-06-02 20:26:33' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-07 21:26:33' AND e.date<='2024-06-09 20:26:33' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-07 21:26:33' AND e.date<='2024-06-09 20:26:33' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-14 21:26:33' AND e.date<='2024-06-16 20:26:33' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-14 21:26:33' AND e.date<='2024-06-16 20:26:33' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-21 21:26:33' AND e.date<='2024-06-23 20:26:33' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-21 21:26:33' AND e.date<='2024-06-23 20:26:33' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-28 21:26:33' AND e.date<='2024-06-30 20:26:33' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-28 21:26:33' AND e.date<='2024-06-30 20:26:33' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-31 21:26:33' AND e.date<='2024-06-02 20:26:33' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2546' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-31 21:26:33' AND e.date<='2024-06-02 20:26:33'