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-18 21:00:00' AND e.date<='2024-09-19 05:39:06' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4077' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-09 06:00:14' AND e.date<='2024-09-13 06:00: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='4077' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-09 06:00:14' AND e.date<='2024-09-13 06:00: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='2871' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-18 21:18:33' AND e.date<='2024-09-19 06:18: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='2871' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-18 21:18:33' AND e.date<='2024-09-19 06:18: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='2871' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-17 21:18:33' AND e.date<='2024-09-19 06:18: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='2871' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-17 21:18:33' AND e.date<='2024-09-19 06:18: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 02:37:05' AND e.date<='2024-09-19 06:37:05' 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 02:37:05' AND e.date<='2024-09-19 06:37:05' 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-18 06:37:45' AND e.date<='2024-09-18 20:37: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-18 06:37:45' AND e.date<='2024-09-18 20:37:45' 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 00:38:33' AND e.date<='2024-09-19 06:38: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 00:38:33' AND e.date<='2024-09-19 06:38: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='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 03:39:28' AND e.date<='2024-09-19 06:39: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='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 03:39:28' AND e.date<='2024-09-19 06:39: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='3056' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 04:39:58' AND e.date<='2024-09-19 06:39:58' 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-09-19 04:39:58' AND e.date<='2024-09-19 06:39:58' 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:00:34' AND e.date<='2024-09-19 07:00:34' 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:00:34' AND e.date<='2024-09-19 07:00:34' 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-09-19 05:01:02' AND e.date<='2024-09-19 07:01: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='3056' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 05:01:02' AND e.date<='2024-09-19 07:01:02' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='3209' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-18 21:00:00' AND e.date<='2024-09-19 07:48:31' Method:GetStops; stop_time2024-09-19 06:59: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='352353084655866' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-15 21:00:38' AND e.date<='2024-09-19 08:00:38' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353084655866' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-15 21:00:38' AND e.date<='2024-09-19 08:00:38' 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 00:38:04' AND e.date<='2024-09-19 08:38: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 00:38:04' AND e.date<='2024-09-19 08:38: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='3081' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-18 08:46:03' AND e.date<='2024-09-19 08:46: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='3081' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-18 08:46:03' AND e.date<='2024-09-19 08:46: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 02:56:48' AND e.date<='2024-09-19 08:56:48' 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 02:56:48' AND e.date<='2024-09-19 08:56:48' 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 00:08:53' AND e.date<='2024-09-19 09:08:53' 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 00:08:53' AND e.date<='2024-09-19 09:08:53' 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:14:38' AND e.date<='2024-09-19 09:14:38' 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:14:38' AND e.date<='2024-09-19 09:14:38' 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 05:26:04' AND e.date<='2024-09-19 09: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 05:26:04' AND e.date<='2024-09-19 09: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 03:26:39' AND e.date<='2024-09-19 09:26:39' 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 03:26:39' AND e.date<='2024-09-19 09:26:39' 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-18 21:00:00' AND e.date<='2024-09-19 10:12:21' Method:GetStops; stop_time2024-09-19 08:54:04 Method:GetStops; stop_time2024-09-19 09:09: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='2528' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-18 10:55:46' AND e.date<='2024-09-19 10:55:46' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-18 10:55:46' AND e.date<='2024-09-19 10:55:46' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-16 10:55:46' AND e.date<='2024-09-16 10:55:46' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-16 10:55:46' AND e.date<='2024-09-16 10:55:46' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-15 21:55:46' AND e.date<='2024-09-16 20:55:46' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-15 21:55:46' AND e.date<='2024-09-16 20:55:46' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-16 21:55:46' AND e.date<='2024-09-17 20:55:46' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-16 21:55:46' AND e.date<='2024-09-17 20:55:46' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-17 21:55:46' AND e.date<='2024-09-18 20:55:46' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2528' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-17 21:55:46' AND e.date<='2024-09-18 20:55:46' 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 02:23:30' AND e.date<='2024-09-19 11:23:30' 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 02:23:30' AND e.date<='2024-09-19 11:23:30' 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 01:30:40' AND e.date<='2024-09-19 11:30: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 01:30:40' AND e.date<='2024-09-19 11:30: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='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 05:31:43' AND e.date<='2024-09-19 11:31: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-09-19 05:31:43' AND e.date<='2024-09-19 11:31: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-18 21:32:02' AND e.date<='2024-09-19 11:32: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-09-18 21:32:02' AND e.date<='2024-09-19 11:32: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 04:34:37' AND e.date<='2024-09-19 11:34: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 04:34:37' AND e.date<='2024-09-19 11:34: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 06:01:04' AND e.date<='2024-09-19 12:01: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 06:01:04' AND e.date<='2024-09-19 12:01: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-19 03:09:07' AND e.date<='2024-09-19 12:09:07' 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 03:09:07' AND e.date<='2024-09-19 12:09:07' 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 07:12:20' AND e.date<='2024-09-19 12: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-19 07:12:20' AND e.date<='2024-09-19 12: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='355234055575019' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-18 13:13:52' AND e.date<='2024-09-19 13:13: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-18 13:13:52' AND e.date<='2024-09-19 13:13: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='355234055575019' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-18 20:03:23' AND e.date<='2024-09-19 20:03: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='355234055575019' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-18 20:03:23' AND e.date<='2024-09-19 20:03:23'