SELECT c.* FROM importazione.v_cataloghi2opere as c LEFT JOIN importazione.v_netbull_cat_operaestesa as e ON c.fk_opera = e.fk_opera WHERE c.fk_opera ilike 'O_U238580' and c.fk_lingua = 'it' AND c.iscatalogoprincipale = '1' and e.visibile = '1'