Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2526' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-19 22:06:21' AND e.date<='2023-12-23 21:06:21'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2526' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-19 22:06:21' AND e.date<='2023-12-23 21:06:21'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-22 21:00:00' AND e.date<='2023-12-23 03:00:00'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-22 21:00:00' AND e.date<='2023-12-23 03:00:00'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4865' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-25 13:45:08' AND e.date<='2023-12-26 13:45:08'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4865' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-25 13:45:08' AND e.date<='2023-12-26 13:45:08'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-25 02:04:07' AND e.date<='2023-12-25 21:04:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-25 02:04:07' AND e.date<='2023-12-25 21:04:07'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-24 02:04:07' AND e.date<='2023-12-24 21:04:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-24 02:04:07' AND e.date<='2023-12-24 21:04:07'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-23 02:04:07' AND e.date<='2023-12-23 21:04:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-23 02:04:07' AND e.date<='2023-12-23 21:04:07'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-19 13:04:07' AND e.date<='2023-12-19 21:04:07'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-19 13:04:07' AND e.date<='2023-12-19 21:04:07'