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