Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-14 22:57:23' AND e.date<='2024-02-15 05:57:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-14 22:57:23' AND e.date<='2024-02-15 05:57:23'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2461' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-14 06:29:08' AND e.date<='2024-02-15 06:29: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='2461' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-14 06:29:08' AND e.date<='2024-02-15 06:29: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='355234055581363' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-11 22:29:08' AND e.date<='2024-02-12 21:29: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='355234055581363' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-11 22:29:08' AND e.date<='2024-02-12 21:29: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='355234055581363' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-12 22:29:08' AND e.date<='2024-02-13 21:29: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='355234055581363' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-12 22:29:08' AND e.date<='2024-02-13 21:29: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='355234055581363' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-13 22:29:08' AND e.date<='2024-02-14 21:29: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='355234055581363' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-13 22:29:08' AND e.date<='2024-02-14 21:29: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-05 05:20:00' AND e.date<='2024-02-05 05:40: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-05 05:20:00' AND e.date<='2024-02-05 05:40: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-05 05:30:00' AND e.date<='2024-02-05 05:35: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-05 05:30:00' AND e.date<='2024-02-05 05:35: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-05 05:25:00' AND e.date<='2024-02-05 05:35: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-05 05:25:00' AND e.date<='2024-02-05 05:35: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='2728' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-15 05:25:00' AND e.date<='2024-02-15 20:35: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='2728' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-15 05:25:00' AND e.date<='2024-02-15 20:35: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='2614' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-14 22:18:43' AND e.date<='2024-02-15 12:18:43'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2614' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-14 22:18:43' AND e.date<='2024-02-15 12:18:43'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2505' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-14 22:18:43' AND e.date<='2024-02-15 12:18:43'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2505' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-14 22:18:43' AND e.date<='2024-02-15 12:18:43'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2505' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-14 22:20:19' AND e.date<='2024-02-15 12:20: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='2505' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-14 22:20:19' AND e.date<='2024-02-15 12:20: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='3059' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-02-05 22:01:51' AND e.date<='2024-02-06 21:01:51'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3059' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-05 22:01:51' AND e.date<='2024-02-06 21:01:51'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='8998' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-02-14 22:00:00' AND e.date<='2024-02-15 13:05:42'
Method:GetStops; stop_time2024-02-15 05:38:13