SELECT * FROM parks.regioni R JOIN parks.regioni_index RI ON (R.id=RI.id_regione) WHERE RI.id_lingua='it'