Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8990' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-19 21:59:53' AND e.date<='2024-05-20 20:59: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='8990' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-19 21:59:53' AND e.date<='2024-05-20 20:59: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='8990' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-20 21:59:53' AND e.date<='2024-05-21 20:59: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='8990' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-20 21:59:53' AND e.date<='2024-05-21 20:59: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='8990' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-21 21:59:53' AND e.date<='2024-05-22 20:59: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='8990' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-21 21:59:53' AND e.date<='2024-05-22 20:59: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='8990' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-22 21:59:53' AND e.date<='2024-05-23 20:59: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='8990' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-22 21:59:53' AND e.date<='2024-05-23 20:59: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='8990' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-23 21:59:53' AND e.date<='2024-05-24 20:59: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='8990' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-23 21:59:53' AND e.date<='2024-05-24 20:59: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='8990' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-23 21:59:53' AND e.date<='2024-05-24 20:59: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='8990' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-23 21:59:53' AND e.date<='2024-05-24 20:59: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='8990' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-05-23 21:09:16' AND e.date<='2024-05-24 20:09:16'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8990' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-05-23 21:09:16' AND e.date<='2024-05-24 20:09:16'