insert into dotlrn_classes (class_key) values (:class_key) select node_id from site_nodes where object_id = (select package_id from dotlrn_classes_full where class_key = :class_type)