Steps to reproduce:

1. Update from 7.0.0 to 7.0.6

Result:
In /var/log/zabbix_server.log when action processing, error:
2615712:20241205:114920.250 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR:  invalid reference to FROM-clause entry for table "h"

Query:

select distinct h.hostid,h.proxyid,h.host,h.tls_connect,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk,h.monitored_by,hp.proxyid 
    from hosts h,interface i,dservices ds 
    left join host_proxy hp on h.hostid=hp.hostid 
    where h.hostid=i.hostid and i.ip=ds.ip and i.useip=1 and h.status=0 and ds.dhostid=399

Error:

ERROR: There is an entry for table "h", but it cannot be referenced from this part of the query.invalid reference to FROM-clause entry for table "h" ERROR: invalid reference to FROM-clause entry for table "h" SQL state: 42P01 Detail: There is an entry for table "h", but it cannot be referenced from this part of the query. Character: 273

Problem maybe in bugfix https://support.zabbix.com/browse/ZBX-25322