Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-17 21:01:56' AND e.date<='2024-06-18 20:01:56' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084656807' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-17 21:01:56' AND e.date<='2024-06-18 20:01:56' 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-06-19 00:15:52' AND e.date<='2024-06-19 05:15:52' 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-06-19 00:15:52' AND e.date<='2024-06-19 05:15:52' 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-06-18 05:16:32' AND e.date<='2024-06-18 20:16: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 05:16:32' AND e.date<='2024-06-18 20:16: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 21:18:50' AND e.date<='2024-06-19 05:18: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='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 21:18:50' AND e.date<='2024-06-19 05:18: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='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 05:25:40' AND e.date<='2024-06-18 20:25: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 05:25:40' AND e.date<='2024-06-18 20:25: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-06-18 05:26:04' AND e.date<='2024-06-18 20:26:04' 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-06-18 05:26:04' AND e.date<='2024-06-18 20:26:04' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 05:26:37' AND e.date<='2024-06-18 20:26: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='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 05:26:37' AND e.date<='2024-06-18 20:26: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='3056' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 05:28:41' AND e.date<='2024-06-18 20:28:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3056' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 05:28:41' AND e.date<='2024-06-18 20:28:41' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 21:00:00' AND e.date<='2024-06-19 06:04:17' 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-06-18 06:33:31' AND e.date<='2024-06-19 06:33:31' 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-06-18 06:33:31' AND e.date<='2024-06-19 06:33:31' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 07:12:20' AND e.date<='2024-06-19 07:12: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='355234055763185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 07:12:20' AND e.date<='2024-06-19 07:12: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='355234055763185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 07:12:20' AND e.date<='2024-06-19 20:12: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='355234055763185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-18 07:12:20' AND e.date<='2024-06-19 20:12: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-18 21:51:18' AND e.date<='2024-06-19 08:51:18' 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-06-18 21:51:18' AND e.date<='2024-06-19 08:51:18' 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-06-19 02:15:28' AND e.date<='2024-06-19 11:15: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-19 02:15:28' AND e.date<='2024-06-19 11:15: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-19 03:26:09' AND e.date<='2024-06-19 11:26:09' 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-06-19 03:26:09' AND e.date<='2024-06-19 11:26:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-10 11:49:02' AND e.date<='2024-06-16 11:49:02' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-10 11:49:02' AND e.date<='2024-06-16 11:49:02' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-16 21:49:02' AND e.date<='2024-06-16 11:49:02' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-16 21:49:02' AND e.date<='2024-06-16 11:49:02' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-16 21:49:02' AND e.date<='2024-06-19 11:49:02' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055763185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-16 21:49:02' AND e.date<='2024-06-19 11:49:02'