Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-24 22:50:04' AND e.date<='2023-12-29 05:50:04' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-24 22:50:04' AND e.date<='2023-12-29 05:50:04' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3028' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 22:17:04' AND e.date<='2023-12-18 21:17:04' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3028' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 22:17:04' AND e.date<='2023-12-18 21:17:04' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3028' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-21 22:17:04' AND e.date<='2023-12-22 21:17:04' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3028' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-21 22:17:04' AND e.date<='2023-12-22 21:17:04' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081803706' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-29 06:07:00' AND e.date<='2023-12-29 12:07:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081803706' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-29 06:07:00' AND e.date<='2023-12-29 12:07:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-29 07:09:11' AND e.date<='2023-12-29 12:09:11' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-29 07:09:11' AND e.date<='2023-12-29 12:09:11' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081803706' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-29 10:10:26' AND e.date<='2023-12-29 12:10:26' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081803706' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-29 10:10:26' AND e.date<='2023-12-29 12:10:26' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 22:18:41' AND e.date<='2023-12-16 21:18:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 22:18:41' AND e.date<='2023-12-16 21:18:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 22:18:41' AND e.date<='2023-12-17 21:18:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 22:18:41' AND e.date<='2023-12-17 21:18:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-24 22:18:41' AND e.date<='2023-12-25 21:18:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-24 22:18:41' AND e.date<='2023-12-25 21:18:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-22 22:18:41' AND e.date<='2023-12-24 21:18:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-22 22:18:41' AND e.date<='2023-12-24 21:18:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081803706' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-29 10:24:59' AND e.date<='2023-12-29 12:24:59' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081803706' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-29 10:24:59' AND e.date<='2023-12-29 12:24:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041064321' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-25 22:49:43' AND e.date<='2023-12-26 21:49:43' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041064321' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-25 22:49:43' AND e.date<='2023-12-26 21:49:43' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041064321' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-26 22:49:43' AND e.date<='2023-12-27 21:49:43' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041064321' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-26 22:49:43' AND e.date<='2023-12-27 21:49:43' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2576' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-28 13:34:01' AND e.date<='2023-12-29 13:34:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2576' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-28 13:34:01' AND e.date<='2023-12-29 13:34:01'