Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3086' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-18 05:40:45' AND e.date<='2024-03-19 05:40:45'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3086' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-18 05:40:45' AND e.date<='2024-03-19 05:40:45'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2574' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-18 10:25:52' AND e.date<='2024-03-19 10:25:52'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2574' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-18 10:25:52' AND e.date<='2024-03-19 10:25:52'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2574' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-18 12:02:18' AND e.date<='2024-03-19 12:02: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='2574' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-18 12:02:18' AND e.date<='2024-03-19 12:02: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='2516' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-19 01:37:28' AND e.date<='2024-03-19 12:37:28'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2516' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-19 01:37:28' AND e.date<='2024-03-19 12:37:28'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2837' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-18 22:38:35' AND e.date<='2024-03-19 12:38: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='2837' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-18 22:38:35' AND e.date<='2024-03-19 12:38: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='352353083458635' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-19 01:39:32' AND e.date<='2024-03-19 12:39:32'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-03-19 01:39:32' AND e.date<='2024-03-19 12:39:32'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-03-17 22:39:56' AND e.date<='2024-03-18 21:39:56'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-03-17 22:39:56' AND e.date<='2024-03-18 21:39:56'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-18 23:41:16' AND e.date<='2024-03-19 12:41:16'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-18 23:41:16' AND e.date<='2024-03-19 12:41:16'
Method:GetStops; Query:SELECT e.date,e.EventType FROM tms_events e WHERE e.DeviceLoginName='356078111279986' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-18 22:00:00' AND e.date<='2024-03-19 13:05:46'
Method:GetStops; stop_time2024-03-19 12:29:37
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-03-19 01:26:59' AND e.date<='2024-03-19 13:26:59'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2473' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-03-19 01:26:59' AND e.date<='2024-03-19 13:26:59'