Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2530' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-19 22:26:25' AND e.date<='2024-11-20 21:26:25' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2530' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-19 22:26:25' AND e.date<='2024-11-20 21:26:25' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173067110641' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-20 22:38:49' AND e.date<='2024-11-21 08:38:49' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='353173067110641' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-20 22:38:49' AND e.date<='2024-11-21 08:38:49' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-10-20 22:42:18' AND e.date<='2024-11-17 21:42:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-10-20 22:42:18' AND e.date<='2024-11-17 21:42:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-17 22:42:18' AND e.date<='2024-11-21 21:42:18' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-17 22:42:18' AND e.date<='2024-11-21 21:42:18' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055581363' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-20 09:39:42' AND e.date<='2024-11-21 09:39:42' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='355234055581363' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-20 09:39:42' AND e.date<='2024-11-21 09:39:42' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116281466' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-21 05:52:35' AND e.date<='2024-11-21 09:52:35' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078116281466' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-21 05:52:35' AND e.date<='2024-11-21 09:52:35' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2833' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-20 22:35:08' AND e.date<='2024-11-21 10:35:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2833' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-20 22:35:08' AND e.date<='2024-11-21 10:35:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2833' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-19 22:35:08' AND e.date<='2024-11-21 10:35:08' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2833' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-19 22:35:08' AND e.date<='2024-11-21 10:35:08' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086184998' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-17 22:59:07' AND e.date<='2024-11-21 11:59:07' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353086184998' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-17 22:59:07' AND e.date<='2024-11-21 11:59:07' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 12:31:01' AND e.date<='2024-11-21 12:31:01' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 12:31:01' AND e.date<='2024-11-21 12:31:01' Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='352353083504503' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-20 22:00:00' AND e.date<='2024-11-21 13:11:00' Method:GetStops; stop_time2024-11-21 12:21:40 Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-17 22:56:41' AND e.date<='2024-11-18 21:56:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-17 22:56:41' AND e.date<='2024-11-18 21:56:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-18 22:56:41' AND e.date<='2024-11-19 21:56:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-18 22:56:41' AND e.date<='2024-11-19 21:56:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-19 22:56:41' AND e.date<='2024-11-20 21:56:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-19 22:56:41' AND e.date<='2024-11-20 21:56:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41' Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085039086' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41' Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='352353085039086' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-11-20 22:56:41' AND e.date<='2024-11-21 21:56:41'