Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-14 21:03:25' AND e.date<='2024-07-15 20:03:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-14 21:03:25' AND e.date<='2024-07-15 20:03:25' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-15 21:03:25' AND e.date<='2024-07-16 20:03:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-15 21:03:25' AND e.date<='2024-07-16 20:03:25' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-16 21:03:25' AND e.date<='2024-07-17 20:03:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-16 21:03:25' AND e.date<='2024-07-17 20:03:25' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-17 21:03:25' AND e.date<='2024-07-18 20:03:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2652' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-17 21:03:25' AND e.date<='2024-07-18 20:03:25' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-23 21:00:00' AND e.date<='2024-07-24 06:36:42' Method:GetStops; stop_time2024-07-23 21:56:21 Method:GetStops; stop_time2024-07-24 01:03:25 Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-07-14 21:55:20' AND e.date<='2024-07-19 20:55: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='2614' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-14 21:55:20' AND e.date<='2024-07-19 20:55: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='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-14 21:55:20' AND e.date<='2024-07-19 20:55: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='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-14 21:55:20' AND e.date<='2024-07-19 20:55: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='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-14 21:57:35' AND e.date<='2024-07-15 20:57:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-14 21:57:35' AND e.date<='2024-07-15 20:57:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-15 21:57:35' AND e.date<='2024-07-16 20:57:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-15 21:57:35' AND e.date<='2024-07-16 20:57:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-16 21:57:35' AND e.date<='2024-07-17 20:57:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-16 21:57:35' AND e.date<='2024-07-17 20:57:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-21 21:55:20' AND e.date<='2024-07-24 20:55: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='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-21 21:55:20' AND e.date<='2024-07-24 20:55: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='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-17 21:57:35' AND e.date<='2024-07-18 20:57:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-17 21:57:35' AND e.date<='2024-07-18 20:57:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-18 21:57:35' AND e.date<='2024-07-19 20:57:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-18 21:57:35' AND e.date<='2024-07-19 20:57:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-22 07:00:08' AND e.date<='2024-07-24 07:00:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-22 07:00:08' AND e.date<='2024-07-24 07:00:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-22 07:00:08' AND e.date<='2024-07-22 07:00:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-22 07:00:08' AND e.date<='2024-07-22 07:00:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-21 21:00:08' AND e.date<='2024-07-22 20:00:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2647' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-21 21:00:08' AND e.date<='2024-07-22 20:00:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111326001' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-22 21:20:57' AND e.date<='2024-07-23 20:20:57' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111326001' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-22 21:20:57' AND e.date<='2024-07-23 20:20:57' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-07-21 21:03:28' AND e.date<='2024-07-24 12:03:28' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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-07-21 21:03:28' AND e.date<='2024-07-24 12:03:28' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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-07-21 21:10:32' AND e.date<='2024-07-22 20:10: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='355234055581363' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-21 21:10:32' AND e.date<='2024-07-22 20:10: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='355234055581363' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-22 21:10:32' AND e.date<='2024-07-23 20:10: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='355234055581363' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-22 21:10:32' AND e.date<='2024-07-23 20:10: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='355234055581363' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-23 21:10:32' AND e.date<='2024-07-24 20:10: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='355234055581363' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-23 21:10:32' AND e.date<='2024-07-24 20:10:32'