Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='862531041078313' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 21:10:21' AND e.date<='2024-10-02 20:10: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='862531041078313' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 21:10:21' AND e.date<='2024-10-02 20:10: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='2833' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:10:21' AND e.date<='2024-10-03 20:10: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='2833' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:10:21' AND e.date<='2024-10-03 20:10: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='4966' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:10:21' AND e.date<='2024-10-03 20:10: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='4966' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:10:21' AND e.date<='2024-10-03 20:10: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='2526' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-02 21:10:21' AND e.date<='2024-10-03 20:10: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='2526' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-02 21:10:21' AND e.date<='2024-10-03 20:10: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='862531041050148' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-04 21:10:21' AND e.date<='2024-10-05 20:10: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='862531041050148' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-04 21:10:21' AND e.date<='2024-10-05 20:10: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='356078116295276' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-01 21:10:21' AND e.date<='2024-10-02 20:10: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='356078116295276' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-01 21:10:21' AND e.date<='2024-10-02 20:10: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='356078111473761' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 09:25:08' AND e.date<='2024-10-07 10:11:08'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='356078111473761' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 09:25:08' AND e.date<='2024-10-07 10:11:08'
Method:GetStops2; Query:SELECT ADDTIME(e.date,'0 3:0:0'), e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3135' AND (e.EventType='6' OR e.EventType='12') AND e.date>='2024-10-07 09:25:08' AND e.date<='2024-10-07 10:11:08'
Method:GetParking2; Query:SELECT ADDTIME(e.date,'0 3:0:0'),e.EventType,e.GeoX,e.GeoY FROM tms_events e WHERE e.DeviceLoginName='3135' AND (e.EventType='7' OR e.EventType='12') AND e.date>='2024-10-07 09:25:08' AND e.date<='2024-10-07 10:11:08'