Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-01-05 22:44:04' AND e.date<='2024-01-06 21:44:04' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-01-05 22:44:04' AND e.date<='2024-01-06 21:44:04' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-01-04 22:44:04' AND e.date<='2024-01-05 21:44:04' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-01-04 22:44:04' AND e.date<='2024-01-05 21:44:04' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-10 22:58:15' AND e.date<='2024-01-11 21:58:15' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-10 22:58:15' AND e.date<='2024-01-11 21:58:15' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-09 22:58:15' AND e.date<='2024-01-10 21:58:15' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-09 22:58:15' AND e.date<='2024-01-10 21:58:15' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-09 22:58:15' AND e.date<='2024-01-10 21:58:15' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-09 22:58:15' AND e.date<='2024-01-10 21:58:15' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-10 13:58:15' AND e.date<='2024-01-11 21:58:15' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-10 13:58:15' AND e.date<='2024-01-11 21:58:15' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-10 09:39:19' AND e.date<='2024-01-11 09:39:19' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-10 09:39:19' AND e.date<='2024-01-11 09:39:19' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-10 22:39:19' AND e.date<='2024-01-11 09:39:19' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-10 22:39:19' AND e.date<='2024-01-11 09:39:19' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-01-10 22:16:48' AND e.date<='2024-01-11 10:16:48' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3133' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-01-10 22:16:48' AND e.date<='2024-01-11 10:16:48'