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-09-20 01:31:19' AND e.date<='2024-09-20 04:31: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-09-20 01:31:19' AND e.date<='2024-09-20 04:31: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 04:32:36' AND e.date<='2024-09-19 20:32: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 04:32:36' AND e.date<='2024-09-19 20:32: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-09-19 04:35:10' AND e.date<='2024-09-19 20:35:10' 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-09-19 04:35:10' AND e.date<='2024-09-19 20:35:10' 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-09-19 02:25:21' AND e.date<='2024-09-19 20:25:21' 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-09-19 02:25:21' AND e.date<='2024-09-19 20:25:21' 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-09-19 05:26:33' AND e.date<='2024-09-19 20:26:33' 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-09-19 05:26:33' AND e.date<='2024-09-19 20:26:33' 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-09-20 03:26:55' AND e.date<='2024-09-20 05:26: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-20 03:26:55' AND e.date<='2024-09-20 05:26: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='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 05:27:27' AND e.date<='2024-09-19 20:27: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 05:27:27' AND e.date<='2024-09-19 20:27:27' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='864866053465430' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 21:00:00' AND e.date<='2024-09-20 06:24:49' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3081' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 07:12:56' AND e.date<='2024-09-20 07:12: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='3081' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 07:12:56' AND e.date<='2024-09-20 07:12: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='2790' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-01 07:20:52' AND e.date<='2024-09-20 07:20: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='2790' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-01 07:20:52' AND e.date<='2024-09-20 07:20: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='2790' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 07:31:26' AND e.date<='2024-09-20 07:31:26' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2790' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 07:31:26' AND e.date<='2024-09-20 07:31:26' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2790' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-01 21:31:26' AND e.date<='2024-09-02 20:31:26' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2790' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-01 21:31:26' AND e.date<='2024-09-02 20:31:26' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2790' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-02 21:31:26' AND e.date<='2024-09-03 20:31:26' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2790' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-02 21:31:26' AND e.date<='2024-09-03 20:31:26' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055575019' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-01 07:20:52' AND e.date<='2024-09-20 07:20: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='355234055575019' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-01 07:20:52' AND e.date<='2024-09-20 07:20: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='2590' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 21:17:29' AND e.date<='2024-09-20 11:17: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='2590' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 21:17:29' AND e.date<='2024-09-20 11:17: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='2590' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 21:17:29' AND e.date<='2024-09-20 11:17: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='2590' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 21:17:29' AND e.date<='2024-09-20 11:17: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='3059' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 21:22:20' AND e.date<='2024-09-20 11:22: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='3059' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 21:22:20' AND e.date<='2024-09-20 11:22: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='3059' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-08 21:22:20' AND e.date<='2024-09-09 20:22: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='3059' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-08 21:22:20' AND e.date<='2024-09-09 20:22: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='3059' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-09 21:22:20' AND e.date<='2024-09-10 20:22: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='3059' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-09 21:22:20' AND e.date<='2024-09-10 20:22: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='3059' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-10 21:22:20' AND e.date<='2024-09-11 20:22: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='3059' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-10 21:22:20' AND e.date<='2024-09-11 20:22: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='356078111471005' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-08-19 11:35:41' AND e.date<='2024-09-20 11:35: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='356078111471005' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-08-19 11:35:41' AND e.date<='2024-09-20 11:35:41'