Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3172' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-28 21:06:10' AND e.date<='2024-04-30 07:06:10'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3172' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-28 21:06:10' AND e.date<='2024-04-30 07:06:10'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086156905' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-26 20:00:00' AND e.date<='2024-04-27 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086156905' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-26 20:00:00' AND e.date<='2024-04-27 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-26 20:00:00' AND e.date<='2024-04-27 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9004' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-26 20:00:00' AND e.date<='2024-04-27 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2557' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-26 20:00:00' AND e.date<='2024-04-27 02:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2557' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-26 20:00:00' AND e.date<='2024-04-27 02:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-26 21:00:08' AND e.date<='2024-04-27 20:59: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='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-26 21:00:08' AND e.date<='2024-04-27 20:59: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='356078118085311' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-27 21:00:08' AND e.date<='2024-04-28 20:59: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='356078118085311' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-27 21:00:08' AND e.date<='2024-04-28 20:59: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='352353084275277' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-30 09:00:00' AND e.date<='2024-04-30 12:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084275277' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-30 09:00:00' AND e.date<='2024-04-30 12:00:00'