SQL: select * from worldcities where countryid = 'IT' and regionid = '10' and cityid = 74625 select worldregions.* from worldregions where worldregions.countryid = 'IT' group by worldregions.regionid order by worldregions.region