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)