Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083439767' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 22:00:00' AND e.date<='2023-12-18 06:26:57' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-14 22:34:17' AND e.date<='2023-12-15 21:34:17' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-14 22:34:17' AND e.date<='2023-12-15 21:34:17' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 22:34:17' AND e.date<='2023-12-16 21:34:17' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 22:34:17' AND e.date<='2023-12-16 21:34:17' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-11 03:22:09' AND e.date<='2023-12-11 21:22:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-11 03:22:09' AND e.date<='2023-12-11 21:22:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-12 03:22:09' AND e.date<='2023-12-12 21:22:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-12 03:22:09' AND e.date<='2023-12-12 21:22:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-13 03:22:09' AND e.date<='2023-12-13 21:22:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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>='2023-12-13 03:22:09' AND e.date<='2023-12-13 21:22:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-11 03:22:09' AND e.date<='2023-12-11 21:22:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-11 03:22:09' AND e.date<='2023-12-11 21:22:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-12 03:22:09' AND e.date<='2023-12-12 21:22:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-12 03:22:09' AND e.date<='2023-12-12 21:22:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-13 03:22:09' AND e.date<='2023-12-13 21:22:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-13 03:22:09' AND e.date<='2023-12-13 21:22:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-14 03:22:09' AND e.date<='2023-12-14 21:22:09' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2829' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-14 03:22:09' AND e.date<='2023-12-14 21:22:09' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2756' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-11 10:00:02' AND e.date<='2023-12-17 10:00:02' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2756' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-11 10:00:02' AND e.date<='2023-12-17 10:00:02' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-18 01:29:40' AND e.date<='2023-12-18 10:29:40' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-18 01:29:40' AND e.date<='2023-12-18 10:29:40' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5135' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-14 22:35:17' AND e.date<='2023-12-15 21:35:17' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5135' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-14 22:35:17' AND e.date<='2023-12-15 21:35:17' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='354836080080582' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='354836080080582' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='862531041085110' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='862531041085110' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='4966' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='4966' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='3045' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='3045' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='5129' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='5129' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='4861' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='4861' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='2866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='2866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='356078111312860' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='356078111312860' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-15 21:00:00' AND e.date<='2023-12-16 03:00: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='862531041078313' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='862531041078313' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3185' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3185' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='862531041072357' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='862531041072357' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='4964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='4964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2543' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2543' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='9014' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='9014' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='4966' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='4966' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3045' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3045' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='354836080168387' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='354836080168387' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3188' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3188' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2576' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2576' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='352353086181416' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='352353086181416' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2499' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2499' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3115' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3115' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='2964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-16 21:00:00' AND e.date<='2023-12-17 03:00: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='3090' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='3090' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='9009' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='9009' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='354836080152241' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='354836080152241' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='3060' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='3060' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='2904' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='2904' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='2953' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='2953' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='3187' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='3187' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 21:00:00' AND e.date<='2023-12-18 03:00: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='2510' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-17 05:35:54' AND e.date<='2023-12-18 15:35:54' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2510' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-17 05:35:54' AND e.date<='2023-12-18 15:35:54' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2510' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2023-12-18 05:35:54' AND e.date<='2023-12-18 15:35:54' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2510' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2023-12-18 05:35:54' AND e.date<='2023-12-18 15:35:54'