Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-09 07:27:54' AND e.date<='2024-12-10 07:27:54'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-09 07:27:54' AND e.date<='2024-12-10 07:27:54'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-04 22:27:54' AND e.date<='2024-12-05 21:27:54'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-04 22:27:54' AND e.date<='2024-12-05 21:27:54'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-05 22:27:54' AND e.date<='2024-12-06 21:27:54'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3162' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-05 22:27:54' AND e.date<='2024-12-06 21:27:54'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-12-10 02:22:01' AND e.date<='2024-12-10 11:22: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='354836080167561' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-10 02:22:01' AND e.date<='2024-12-10 11:22:01'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2: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-12-10 04:31:09' AND e.date<='2024-12-10 11:31:09'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2: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-12-10 04:31:09' AND e.date<='2024-12-10 11:31:09'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2743' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-06 22:30:01' AND e.date<='2024-12-08 21:30: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='2743' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-06 22:30:01' AND e.date<='2024-12-08 21:30:01'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2743' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-01 22:30:01' AND e.date<='2024-12-06 21:30: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='2743' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-01 22:30:01' AND e.date<='2024-12-06 21:30:01'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 2:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2743' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-12-07 22:45:17' AND e.date<='2024-12-08 21:45:17'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 2:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='2743' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-12-07 22:45:17' AND e.date<='2024-12-08 21:45:17'