Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2940' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-04 21:00:00' AND e.date<='2024-09-05 06:09:52' Method:GetStops; stop_time2024-09-05 00:41:54 Method:GetStops; stop_time2024-09-05 03:04:51 Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111451585' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-02 06:34:22' AND e.date<='2024-09-05 06:34:22' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111451585' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-02 06:34:22' AND e.date<='2024-09-05 06:34:22' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-09 21:06:59' AND e.date<='2024-08-11 20:06:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-09 21:06:59' AND e.date<='2024-08-11 20:06:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-16 21:06:59' AND e.date<='2024-08-18 20:06:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-16 21:06:59' AND e.date<='2024-08-18 20:06:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-23 21:06:59' AND e.date<='2024-08-25 20:06:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-23 21:06:59' AND e.date<='2024-08-25 20:06:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-30 21:06:59' AND e.date<='2024-09-01 20:06:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111293896' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-30 21:06:59' AND e.date<='2024-09-01 20:06:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2536' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-01 21:37:36' AND e.date<='2024-09-02 20:37:36' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2536' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-01 21:37:36' AND e.date<='2024-09-02 20:37:36' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2536' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-02 21:37:36' AND e.date<='2024-09-03 20:37:36' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2536' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-02 21:37:36' AND e.date<='2024-09-03 20:37:36' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111446148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-02 21:45:03' AND e.date<='2024-08-04 20:45:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111446148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-02 21:45:03' AND e.date<='2024-08-04 20:45: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='356078111446148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-09 21:45:03' AND e.date<='2024-08-11 20:45:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111446148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-09 21:45:03' AND e.date<='2024-08-11 20:45: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='356078111446148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-16 21:45:03' AND e.date<='2024-08-18 20:45:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111446148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-16 21:45:03' AND e.date<='2024-08-18 20:45: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='356078116288354' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-02 21:50:51' AND e.date<='2024-08-04 20:50:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-02 21:50:51' AND e.date<='2024-08-04 20:50:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-09 21:50:51' AND e.date<='2024-08-11 20:50:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-09 21:50:51' AND e.date<='2024-08-11 20:50:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-09 21:50:51' AND e.date<='2024-08-11 20:50:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-09 21:50:51' AND e.date<='2024-08-11 20:50:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-16 21:50:51' AND e.date<='2024-08-18 20:50:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-16 21:50:51' AND e.date<='2024-08-18 20:50:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-23 21:50:51' AND e.date<='2024-08-25 20:50:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116288354' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-23 21:50:51' AND e.date<='2024-08-25 20:50:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084275186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-23 21:50:51' AND e.date<='2024-08-25 20:50:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084275186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-23 21:50:51' AND e.date<='2024-08-25 20:50:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084275186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-16 21:50:51' AND e.date<='2024-08-18 20:50:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084275186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-16 21:50:51' AND e.date<='2024-08-18 20:50:51' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-02 21:56:20' AND e.date<='2024-08-04 20:56:20' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-02 21:56:20' AND e.date<='2024-08-04 20:56:20' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-09 21:56:20' AND e.date<='2024-08-11 20:56:20' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-09 21:56:20' AND e.date<='2024-08-11 20:56:20' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-16 21:56:20' AND e.date<='2024-08-18 20:56:20' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-16 21:56:20' AND e.date<='2024-08-18 20:56:20' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-23 21:56:20' AND e.date<='2024-08-25 20:56:20' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5129' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-23 21:56:20' AND e.date<='2024-08-25 20:56:20' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-04 11:46:40' AND e.date<='2024-09-04 20:46:40' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-04 11:46:40' AND e.date<='2024-09-04 20:46:40' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-05 01:51:03' AND e.date<='2024-09-05 11:51:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-05 01:51:03' AND e.date<='2024-09-05 11:51: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='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-04 11:51:29' AND e.date<='2024-09-04 20:51:29' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-04 11:51:29' AND e.date<='2024-09-04 20:51:29' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-05 00:51:51' AND e.date<='2024-09-05 11:51:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-05 00:51:51' AND e.date<='2024-09-05 11:51:51' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2940' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-04 21:00:00' AND e.date<='2024-09-05 18:26:16' Method:GetStops; stop_time2024-09-05 00:41:54 Method:GetStops; stop_time2024-09-05 03:04:51 Method:GetStops; stop_time2024-09-05 10:20:07 Method:GetStops; stop_time2024-09-05 11:46:46 Method:GetStops; stop_time2024-09-05 16:26:46 Method:GetStops; stop_time2024-09-05 17:44:56 Method:GetStops; stop_time2024-09-05 18:07:36