MariaDB [zabbix]> SELECT DISTINCT t.triggerid,t.lastchange FROM triggers t,functions f,items i WHERE i.hostid='10084' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.flags IN ('0','4') ORDER BY t.lastchange LIMIT 22;