SQL: select * from categories where catid = '1' order by category select worldregions.* from worldregions where worldregions.countryid = 'US' group by worldregions.regionid order by worldregions.region