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'
)