SELECT DISTINCT p.eventid,p.objectid
FROM problem p
  JOIN functions f      ON p.objectid=f.triggerid
  JOIN items i          ON f.itemid=i.itemid
  JOIN host_hgset hh    ON i.hostid=hh.hostid
  JOIN permission pp    ON hh.hgsetid=pp.hgsetid 
                        AND pp.ugsetid=150
WHERE p.cause_eventid=580390324
  AND p.source=0
  AND p.object=0
  AND NOT EXISTS (
    SELECT 1
    FROM functions f1
      JOIN items i1        ON f1.itemid=i1.itemid
      JOIN host_hgset hh1  ON i1.hostid=hh1.hostid
      LEFT JOIN permission pp1
             ON hh1.hgsetid=pp1.hgsetid
            AND pp1.ugsetid=pp.ugsetid
    WHERE p.objectid=f1.triggerid
      AND pp1.permission IS NULL
  )
  AND p.r_eventid IS NULL;