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-31 00:38:51' AND e.date<='2024-07-31 04:38:51'
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-31 00:38:51' AND e.date<='2024-07-31 04:38: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='2556' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-31 00:39:24' AND e.date<='2024-07-31 04:39: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='2556' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-31 00:39:24' AND e.date<='2024-07-31 04:39: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='354836080167561' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-31 03:09:13' AND e.date<='2024-07-31 05:09:13'
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-31 03:09:13' AND e.date<='2024-07-31 05:09:13'
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-31 02:13:05' AND e.date<='2024-07-31 05:13: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-07-31 02:13:05' AND e.date<='2024-07-31 05:13: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='2672' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-30 05:33:30' AND e.date<='2024-07-30 20:33: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='2672' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-30 05:33:30' AND e.date<='2024-07-30 20:33: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='2672' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-29 05:35:21' AND e.date<='2024-07-29 20:35: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='2672' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-07-29 05:35:21' AND e.date<='2024-07-29 20:35: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-30 06:39:49' AND e.date<='2024-07-31 06:39:49'
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-30 06:39:49' AND e.date<='2024-07-31 06:39: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='2762' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-07-28 21:39:49' AND e.date<='2024-07-31 06:39:49'
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-28 21:39:49' AND e.date<='2024-07-31 06:39:49'