SELECT strutture.ragionesociale, strutture.categoria, strutture.citta, strutture.oid
FROM strutture
WHERE strutture.citta ='Assisi' OR strutture.citta ='Perugia'
OR strutture.citta ='Torgiano' OR strutture.citta ='Todi'
ORDER BY strutture.categoria desc
italian excursions | destinations | Tuscany
Umbria : Evocative landscapes
The distinctive and peaceful Umbrian countryside has, for
centuries been a favourite haunt of travellers looking to escape the crowded
cities. It is a region where the past and the present merge in pleasant
harmony.
