select p.portal_id, name from portals p, dotlrn_communities dc where dc.portal_template_id = p.portal_id and dc.portal_id is NULL and dc.admin_portal_id is NULL and dc.community_type != 'user_workspace'