Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 21:37:43' AND e.date<='2024-10-01 20:37:43'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 21:37:43' AND e.date<='2024-10-01 20:37:43'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 21:41:12' AND e.date<='2024-10-02 20:41:12'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 21:41:12' AND e.date<='2024-10-02 20:41:12'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:41:43' AND e.date<='2024-10-03 20:41:43'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:41:43' AND e.date<='2024-10-03 20:41:43'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 21:45:14' AND e.date<='2024-10-07 06:45:14'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 21:45:14' AND e.date<='2024-10-07 06:45:14'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 21:45:14' AND e.date<='2024-10-04 20:45:14'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3144' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 21:45:14' AND e.date<='2024-10-04 20:45:14'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 06:55:50' AND e.date<='2024-10-10 06:55:50'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 06:55:50' AND e.date<='2024-10-10 06:55:50'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 06:55:50' AND e.date<='2024-10-10 06:55:50'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 06:55:50' AND e.date<='2024-10-10 06:55:50'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-08 21:55:50' AND e.date<='2024-10-09 20:55:50'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-08 21:55:50' AND e.date<='2024-10-09 20:55:50'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-06 21:55:50' AND e.date<='2024-10-07 20:55:50'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2593' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-06 21:55:50' AND e.date<='2024-10-07 20:55:50'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-09 07:02:23' AND e.date<='2024-10-10 07:02:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 07:02:23' AND e.date<='2024-10-10 07:02:23'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 21:02:23' AND e.date<='2024-10-01 20:02:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 21:02:23' AND e.date<='2024-10-01 20:02:23'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 21:02:23' AND e.date<='2024-10-02 20:02:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 21:02:23' AND e.date<='2024-10-02 20:02:23'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:02:23' AND e.date<='2024-10-03 20:02:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:02:23' AND e.date<='2024-10-03 20:02:23'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 21:02:23' AND e.date<='2024-10-04 20:02:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 21:02:23' AND e.date<='2024-10-04 20:02:23'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-10-08 21:05:13' AND e.date<='2024-10-09 20:05:13'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-10-08 21:05:13' AND e.date<='2024-10-09 20:05:13'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-06 21:02:23' AND e.date<='2024-10-07 20:02:23'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2751' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-06 21:02:23' AND e.date<='2024-10-07 20:02:23'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3033' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-09 21:00:00' AND e.date<='2024-10-10 07:50:40'
Method:GetStops; stop_time2024-10-10 05:30:58
Method:GetStops; stop_time2024-10-10 06:12:03
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3033' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:55:32' AND e.date<='2024-10-03 20:55:32'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3033' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:55:32' AND e.date<='2024-10-03 20:55:32'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-11 20:00:39' AND e.date<='2024-09-11 20:59:39'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-11 20:00:39' AND e.date<='2024-09-11 20:59:39'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-12 20:00:39' AND e.date<='2024-09-12 20:59:39'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-12 20:00:39' AND e.date<='2024-09-12 20:59:39'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-12 19:00:39' AND e.date<='2024-09-12 20:59:39'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-12 19:00:39' AND e.date<='2024-09-12 20:59:39'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-11 19:00:39' AND e.date<='2024-09-11 20:59:39'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-11 19:00:39' AND e.date<='2024-09-11 20:59:39'