SELECT DISTINCT AT.id AS id_tipologia, AT.tipologia AS tipologia FROM  aziende_tipologie AT JOIN  aziende A ON ( AT.id = A.id_tipologia AND AT.id_lingua = A.id_lingua ) JOIN  ap_aziende AA ON ( A.id = AA.id_aziende AND A.id_lingua = AA.id_lingua AND AA.id_ap LIKE '%SIFAL%' ) WHERE AT.id_lingua='en'
				 		 ORDER BY AT.ordinamento