Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='2519' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 21:00:00' AND e.date<='2024-07-11 06:04: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='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 06:27:18' AND e.date<='2024-07-11 06:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 06:27:18' AND e.date<='2024-07-11 06:27:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:27:18' AND e.date<='2024-07-01 20:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:27:18' AND e.date<='2024-07-01 20:27:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 21:27:18' AND e.date<='2024-07-02 20:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 21:27:18' AND e.date<='2024-07-02 20:27:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 21:27:18' AND e.date<='2024-07-03 20:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 21:27:18' AND e.date<='2024-07-03 20:27:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 21:27:18' AND e.date<='2024-07-04 20:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 21:27:18' AND e.date<='2024-07-04 20:27:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 21:27:18' AND e.date<='2024-07-07 20:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 21:27:18' AND e.date<='2024-07-07 20:27:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-05 21:27:18' AND e.date<='2024-07-07 20:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-05 21:27:18' AND e.date<='2024-07-07 20:27:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 21:27:18' AND e.date<='2024-07-11 20:27:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='5046' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 21:27:18' AND e.date<='2024-07-11 20:27:18' 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-07-10 18:27:18' AND e.date<='2024-07-11 02:27:18' 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-07-10 18:27:18' AND e.date<='2024-07-11 02:27:18' 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-07-10 16:27:18' AND e.date<='2024-07-11 02:27:18' 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-07-10 16:27:18' AND e.date<='2024-07-11 02:27:18' 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-10 06:37:11' AND e.date<='2024-07-10 20:37: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='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 06:37:11' AND e.date<='2024-07-10 20:37: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='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 23:42:38' AND e.date<='2024-07-11 06:42: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='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 23:42:38' AND e.date<='2024-07-11 06:42: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-07-11 03:59:24' AND e.date<='2024-07-11 06:59: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-11 03:59:24' AND e.date<='2024-07-11 06:59: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:00:04' AND e.date<='2024-07-01 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:00:04' AND e.date<='2024-07-01 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-02 21:00:04' AND e.date<='2024-07-03 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-02 21:00:04' AND e.date<='2024-07-03 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-03 21:00:04' AND e.date<='2024-07-04 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-03 21:00:04' AND e.date<='2024-07-04 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-04 21:00:04' AND e.date<='2024-07-07 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-04 21:00:04' AND e.date<='2024-07-07 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:00:04' AND e.date<='2024-07-01 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:00:04' AND e.date<='2024-07-01 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-07 21:00:04' AND e.date<='2024-07-08 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-07 21:00:04' AND e.date<='2024-07-08 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-08 21:00:04' AND e.date<='2024-07-09 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-08 21:00:04' AND e.date<='2024-07-09 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-09 21:00:04' AND e.date<='2024-07-10 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-09 21:00:04' AND e.date<='2024-07-10 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 21:00:04' AND e.date<='2024-07-11 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 21:00:04' AND e.date<='2024-07-11 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-06-30 21:00:04' AND e.date<='2024-07-01 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-06-30 21:00:04' AND e.date<='2024-07-01 20:00: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-01 21:00:04' AND e.date<='2024-07-02 20:00: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='2762' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-01 21:00:04' AND e.date<='2024-07-02 20:00: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-11 02:44:35' AND e.date<='2024-07-11 08:44:35' 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-11 02:44:35' AND e.date<='2024-07-11 08:44:35' 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-11 05:44:59' AND e.date<='2024-07-11 08:44: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='356078116278207' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-11 05:44:59' AND e.date<='2024-07-11 08:44: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='356078116278207' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 21:04:18' AND e.date<='2024-07-11 09:04:18' 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-10 21:04:18' AND e.date<='2024-07-11 09:04:18' 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-10 01:04:36' AND e.date<='2024-07-10 20:04: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-07-10 01:04:36' AND e.date<='2024-07-10 20:04: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='862531041054447' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-06 21:00:04' AND e.date<='2024-07-07 20:00: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='862531041054447' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-06 21:00:04' AND e.date<='2024-07-07 20:00: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-07-11 08:46:17' AND e.date<='2024-07-11 12:46: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='352353083458635' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-11 08:46:17' AND e.date<='2024-07-11 12:46: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='4884' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-10 21:00:25' AND e.date<='2024-07-11 13:00:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='4884' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-10 21:00:25' AND e.date<='2024-07-11 13:00:25'