select name from subsite_themes where key = :new_theme select site_template_id from dotlrn_site_templates where pretty_name = :site_template_name select theme_id from portal_element_themes where name = :site_template_name update portals set theme_id = :theme_id select layout_id as old_id from portal_layouts where name = :old select layout_id as new_id from portal_layouts where name = :new update portal_pages set layout_id = :new_id where layout_id = :old_id