select child_id as illustration_item_id from cr_child_rels where relation_tag = 'illustration' and parent_id = :item_id select parent_id from cr_child_rels where child_id = :item_id and relation_tag = 'parent glossary' insert into glossary_termsi ( item_id, revision_id, title, context_id, creation_user, creation_ip, mime_type ) values ( :item_id, :revision_id, :term, :glossary_item_id, :user_id, :peeraddr, :mime_type ) update cr_items set live_revision = :revision_id, publish_status = :publish_status where item_id = :item_id insert into glossary_terms ( term_id ) values ( :new_revision_id ) update cr_items set live_revision = :new_revision_id, name = :name, publish_status = :publish_status where item_id = :new_item_id insert into cr_child_rels ( rel_id, parent_id, child_id, relation_tag ) values ( :rel_id, :glossary_item_id, :new_item_id, 'parent glossary' )