select alias.* from SIF_AN_SMECE alias where 1=1 and alias.idfirma = 4