Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111469876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 17:51:47' AND e.date<='2024-10-04 04:51: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='356078111469876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 17:51:47' AND e.date<='2024-10-04 04:51: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='356078111469876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 14:51:47' AND e.date<='2024-10-04 04:51: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='356078111469876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 14:51:47' AND e.date<='2024-10-04 04:51: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='356078111469876' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 12:51:47' AND e.date<='2024-10-04 04:51: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='356078111469876' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 12:51:47' AND e.date<='2024-10-04 04:51: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='2846' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 21:50:38' AND e.date<='2024-10-01 20:50: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='2846' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 21:50:38' AND e.date<='2024-10-01 20:50: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='2846' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 21:50:38' AND e.date<='2024-10-02 20:50: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='2846' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 21:50:38' AND e.date<='2024-10-02 20:50: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='356078118082904' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:54:23' AND e.date<='2024-10-03 20:54: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='356078118082904' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:54:23' AND e.date<='2024-10-03 20:54: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='356078118082904' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 21:54:23' AND e.date<='2024-10-04 20:54: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='356078118082904' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 21:54:23' AND e.date<='2024-10-04 20:54: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='2623' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-22 21:54:23' AND e.date<='2024-09-29 20:54: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='2623' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-22 21:54:23' AND e.date<='2024-09-29 20:54: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='2623' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-22 21:54:23' AND e.date<='2024-09-29 20:54: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='2623' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-22 21:54:23' AND e.date<='2024-09-29 20:54: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='358021081838710' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:38:07' AND e.date<='2024-10-03 20:59: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='358021081838710' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:38:07' AND e.date<='2024-10-03 20:59:07' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='358021081838710' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 21:00:00' AND e.date<='2024-10-04 07:39: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='358021081838710' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 16:39:17' AND e.date<='2024-10-04 07:39:17' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081838710' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 16:39:17' AND e.date<='2024-10-04 07:39:17' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081838710' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:39:11' AND e.date<='2024-10-03 20:39:11' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081838710' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:39:11' AND e.date<='2024-10-03 20:39:11' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI3421' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 18:45:24' AND e.date<='2024-10-03 20:45:24' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI3421' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 18:45:24' AND e.date<='2024-10-03 20:45:24' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI3421HP' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 16:45:24' AND e.date<='2024-10-03 20:45:24' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='AI3421HP' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 16:45:24' AND e.date<='2024-10-03 20:45:24' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='358021081838710' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:46:27' AND e.date<='2024-10-03 20:46: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='358021081838710' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:46:27' AND e.date<='2024-10-03 20:46:27' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083473741' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 21:00:00' AND e.date<='2024-10-04 08:17:23' Method:GetStops; stop_time2024-10-04 05:12:11 Method:GetStops; stop_time2024-10-04 05:18: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='352353086180491' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-29 21:24:22' AND e.date<='2024-09-30 20:24:22' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086180491' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-29 21:24:22' AND e.date<='2024-09-30 20:24:22' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086182380' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-29 21:29:14' AND e.date<='2024-09-30 20:29: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='352353086182380' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-29 21:29:14' AND e.date<='2024-09-30 20:29:14' 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-10-03 21:00:00' AND e.date<='2024-10-04 08:32: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='352353086182380' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 21:32:42' AND e.date<='2024-10-01 20:32:42' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086182380' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 21:32:42' AND e.date<='2024-10-01 20:32:42' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086182380' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 21:39:12' AND e.date<='2024-10-02 20:39:12' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086182380' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 21:39:12' AND e.date<='2024-10-02 20:39:12' 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-30 20:00:00' AND e.date<='2024-10-01 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='3056' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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-09-30 20:00:00' AND e.date<='2024-10-01 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-09-30 20:00:00' AND e.date<='2024-10-01 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='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2954' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2954' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2665' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2665' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2624' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2624' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2809' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2809' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='352353084150330' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='352353084150330' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2888' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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='2888' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-09-30 20:00:00' AND e.date<='2024-10-01 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-10-01 20:00:00' AND e.date<='2024-10-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-10-01 20:00:00' AND e.date<='2024-10-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='2874' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='2874' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3081' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3081' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='2633' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='2633' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='862531041041535' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='862531041041535' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3092' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3092' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='2846' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='2846' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3061' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3061' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3205' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='3205' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 20:00:00' AND e.date<='2024-10-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='9010' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='9010' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='2554' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='2554' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='5131' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='5131' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='8992' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='8992' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='4849' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='4849' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3238' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3238' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3025' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3025' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='4966' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='4966' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3081' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3081' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3063' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3063' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3124' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3124' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='2662' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='2662' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='352353085616701' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='352353085616701' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3061' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3061' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='5132' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='5132' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='356078116291259' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='356078116291259' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='2964' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='2964' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 20:00:00' AND e.date<='2024-10-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='3176' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='3176' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='4863' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='4863' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='3081' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='3081' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='4862' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='4862' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='353173060497698' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='353173060497698' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='3172' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='3172' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='4819' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='4819' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-03 20:00:00' AND e.date<='2024-10-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='2554' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 23:40:15' AND e.date<='2024-10-04 19:40:15' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2554' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 23:40:15' AND e.date<='2024-10-04 19:40:15'