select dptm.portal_id, p.name from portals p, dotlrn_portal_types_map dptm where p.portal_id = dptm.portal_id order by p.name