select dst.site_template_id, dst.pretty_name, pet.name || ' ( ' || pet.description || ' )' as portal_theme from dotlrn_site_templates dst, portal_element_themes pet where dst.portal_theme_id = pet.theme_id