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-07-05 00:56:28' AND e.date<='2024-07-05 05:56: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-07-05 00:56:28' AND e.date<='2024-07-05 05:56: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 05:57:23' AND e.date<='2024-07-04 20:57:23' 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-07-04 05:57:23' AND e.date<='2024-07-04 20:57:23' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3057' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-23 21:55:29' AND e.date<='2024-07-05 20:55:29' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3057' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-23 21:55:29' AND e.date<='2024-07-05 20:55:29' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 21:15:51' AND e.date<='2024-07-04 20:15:51' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 21:15:51' AND e.date<='2024-07-04 20:15:51' 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-07-04 23:22:27' AND e.date<='2024-07-05 08:22:27' 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-07-04 23:22:27' AND e.date<='2024-07-05 08:22:27' 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-07-03 21:22:47' AND e.date<='2024-07-04 20:22: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='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 21:22:47' AND e.date<='2024-07-04 20:22: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='3203' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3203' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3123' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3123' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' 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-07-03 21:23:43' AND e.date<='2024-07-04 20:23:43' 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-07-03 21:23:43' AND e.date<='2024-07-04 20:23:43' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' 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-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' 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-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-04 08:24:14' AND e.date<='2024-07-04 20:24:14' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-04 08:24:14' AND e.date<='2024-07-04 20:24:14' 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-07-04 08:24:59' AND e.date<='2024-07-04 20:24:59' 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-07-04 08:24:59' AND e.date<='2024-07-04 20:24:59' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3179' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3156' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2763' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2763' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3197' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3197' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 20:00:00' AND e.date<='2024-07-02 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3172' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 08:28:03' AND e.date<='2024-07-04 20:28:03' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3172' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 08:28:03' AND e.date<='2024-07-04 20:28:03' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3203' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3203' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4630' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4630' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3021' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3021' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2769' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2769' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' 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-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' 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-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2684' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2684' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2726' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 20:00:00' AND e.date<='2024-07-03 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3184' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3184' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2575' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2575' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111320111' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9378' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' 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-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' 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-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2500' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3: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>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2623' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2623' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085654322' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085654322' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2610' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2610' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 20:00:00' AND e.date<='2024-07-04 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2704' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2704' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9376' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='9376' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2485' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2485' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173060485131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' 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-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' 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-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3186' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' 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-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' 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-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3100' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3100' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2526' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2526' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4967' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4967' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 20:00:00' AND e.date<='2024-07-05 02:00:00' 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-07-05 05:59:29' AND e.date<='2024-07-05 09:59:29' 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-07-05 05:59:29' AND e.date<='2024-07-05 09:59:29' 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-07-04 22:00:02' AND e.date<='2024-07-05 10:00: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 22:00:02' AND e.date<='2024-07-05 10:00: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='2723' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-07 21:34:45' AND e.date<='2024-06-09 20:34:45' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2723' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-07 21:34:45' AND e.date<='2024-06-09 20:34:45'