Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='8987' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-18 21:13:50' AND e.date<='2024-04-19 20:13: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='8987' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-18 21:13:50' AND e.date<='2024-04-19 20:13: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='8987' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-11 21:13:50' AND e.date<='2024-04-12 20:13: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='8987' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-11 21:13:50' AND e.date<='2024-04-12 20:13: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='8987' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-12 21:13:50' AND e.date<='2024-04-13 20:13: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='8987' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-12 21:13:50' AND e.date<='2024-04-13 20:13: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='8987' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-13 21:13:50' AND e.date<='2024-04-14 20:13: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='8987' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-13 21:13:50' AND e.date<='2024-04-14 20:13: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='2759' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-07 21:02:47' AND e.date<='2024-04-12 20:02:47' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2759' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-07 21:02:47' AND e.date<='2024-04-12 20:02:47' 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-04-15 21:09:37' AND e.date<='2024-04-16 08:09:37' 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-04-15 21:09:37' AND e.date<='2024-04-16 08:09:37' 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-04-15 21:43:19' AND e.date<='2024-04-16 09:43:19' 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-04-15 21:43:19' AND e.date<='2024-04-16 09:43:19' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-16 01:43:55' AND e.date<='2024-04-16 09:43:55' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5117' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-16 01:43:55' AND e.date<='2024-04-16 09:43:55' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3032' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-07 21:07:36' AND e.date<='2024-04-12 20:07: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='3032' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-07 21:07:36' AND e.date<='2024-04-12 20:07: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-16 01:09:12' AND e.date<='2024-04-16 12:09: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-16 01:09:12' AND e.date<='2024-04-16 12:09: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='352353084159372' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-04-15 12:56:54' AND e.date<='2024-04-16 12:56:54' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084159372' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-04-15 12:56:54' AND e.date<='2024-04-16 12:56:54'