select * from tabelle T where t.codicetabella = 178 and (t.tutteprocedure = '1' or exists (select * from proceduretabelle pt, settoriprocedure sp where
pt.idtabella = t.idtabelle and pt.idproceduredip = sp.idprocedura and sp.idsettore in (select S.idsettori from settori S, unitaoperative U, areedipartimentale A
where s.idunitaoperativa = u.idunitaoperative and u.idarea = a.idareedip and a.idareedip in (3, 4, 5, 6))))